D1,Sybase Anywhere SQL - Change Data with Grid

D1,Sybase Anywhere SQL - Change Data with Grid

Post by Stefan Wolbe » Sun, 31 Dec 1899 09:00:00



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

 
 
 

1. 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

2. Difference b/w Intro and C/S versions of Delphi

3. D1, Sybase SQL Anywhere: ReportSmith

4. override the generated by default on identity

5. Undocumented 3602 , severity 25 error on Compaq Proliant 4500.

6. DELPHI with SYBASE SQL ANYWHERE------ DELPHI with SYBASE SQL ANYWHERE

7. Visual C++, Access 97 and DAO

8. D1, SQL Anywhere - Master / Detail Table

9. How many using D1 and SQL Anywhere???

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

11. Getting Sybase 11 data to Sybase Anywhere

12. Datetime data type and Sybase SQL Anywhere