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
Any comments would be very welcome.