Board index » delphi » D1,Sybase Anywhere SQL - Change Data with Grid

Stefan Wolbe

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

D1,Sybase Anywhere SQL - Change Data with Grid

Hi everybody.

I just started programming in Delphi, so my question might be some kind
of trivial to you but for me its a question of to be or not to be.

A table (TBGrid or OvcDBTabel from Orpheus) shall be filled with data by
a SQL Query (TQuery) to the Sybase SQL Anywhere - Server (easy)and then
changed (not easy).

As far as I know it should work by setting RequestLive at TQuery but it
doesn't work. As I only get the error message in german I will give my
best to translate it but you will probably need some phantasy to guess
the meaning. The error message is "Passthrough SQL connection must be
enabled for concurrent access".

I am working in a Network (Novell 3.11 or .12), Delphi 1 and the Sybase
SQL Anywhere Network Server Version 5.0 Build #440.

Another possibility would be to work with TTable but it is probably not
very elegant on a SQL Server and I have no idea how to lock the cells
that the user is working with to prevent other users to work with them.

How big would the network traffic be with RequestLive and is there a
method without it to lock cells that are loaded and to update them
later?

Any comments would be very welcome.

Cu

Stefan Wolber

 
Steve Mora

Delphi Developer
Wed, 15 Mar 2000 03:00:00 GMT

Re:D1,Sybase Anywhere SQL - Change Data with Grid


Quote
> As far as I know it should work by setting RequestLive at TQuery but it
> doesn't work. As I only get the error message in german I will give my
> best to translate it but you will probably need some phantasy to guess
> the meaning. The error message is "Passthrough SQL connection must be
> enabled for concurrent access".

In BDE Administrator somewhere there is a "Passthrough SQL" parameter for
each database alias. This can be "Not shared", "Shared NoAutoCommit" or
"Shared AutoCommit". I always use "Shared NoAutoCommit". Maybe yours has
"Not Shared".

Quote
> How big would the network traffic be with RequestLive and is there a
> method without it to lock cells that are loaded and to update them
> later?

I suggest looking into the Isolation Level settings. Also possibly enabling
cached updates and associating a TUpdateSQL with the TQuery. I am also
working on similar things with Delphi 3 and SQL Anywhere.

Steve Moran
eXact Solutions Ltd. (London)

Other Threads

1. DELPHI with SYBASE SQL ANYWHERE------ DELPHI with SYBASE SQL ANYWHERE

2. D1, Sybase SQL Anywhere: ReportSmith

3. accessing large data with sybase sql anywhere

4. accessing large data with sybase sql anywhere

5. accessing large data with sybase sql anywhere

6. D4 / Sybase SQL Anywhere / Adaptive Server Anywhere 6.0

7. Sybase SQL Anywhere, SQL Links and Delphi 2.0

8. Sybase SQL Anywhere (Watcom SQL) and Delphi

9. Sybase Sql Anywhere and Sql Links

10. Migrating Sybase SQL Anywhere to MS SQL Server