Live Queries or UpdateSQL

Live Queries or UpdateSQL

Post by TDSla » Sun, 31 Dec 1899 09:00:00



Are TQueries with RequestLive set to True safe to use or are you better
to use TUpdateSQL with a TQuery. Database is Sybase.

Any info welcome

Tim Slack

Quote:>remove 'nojunk' from email address<

 
 
 

Live Queries or UpdateSQL

Post by Robert Cern » Sun, 31 Dec 1899 09:00:00



>Are TQueries with RequestLive set to True safe to use or are you better
>to use TUpdateSQL with a TQuery. Database is Sybase.

>Any info welcome

>Tim Slack

It's exactly the same. Most of times.
The problems arise if you have unique index that is not really unique - the
field allows null values. Sybase supports this and it confuses BDE.
So with  TUpdateSQL you have full control on what gets updated (inserted,
deleted), with live queries BDE handles it for you - allmost the same way:
it builds updatesql and executes on Query.Post.

--
----------------------
Regards
Robert Cerny
Remove both qwe when replying

No questions via email, unless explicitly invited.

 
 
 

Live Queries or UpdateSQL

Post by EWhip » Sun, 31 Dec 1899 09:00:00


Setting RequestLive to true is perfectly safe.  The difference is in the data
traffic.  When you set RequestLive to true, there are A LOT more calls to the
database, because Delphi must retrieve the metadata from the table too(so it
can do updates).  
Contrast with that the ease of use issue...and...
 
 
 

1. Call 1-800-856-2469, LIVE LIVE LIVE 809-474-7588 code4389

18+, 24hours, rates as low as $0.38/min

Hot, Young women want it NOW ----011-592-247-681
Gay, Bi, Bi-curious guys at -----809-474-7604
************************************************
************************************************
************************************************
************************************************

comp.databases.pick

2. solving xp_sendmail !! this is a nightmare

3. Differences between UpdateSQL component and Query.ExecSQL

4. CreateWorkspace - security problem in VB4

5. Query returning live-result...

6. pgsql/src/bin/pg_dump pg_backup_archiver.c

7. Multiple Table Queries with Live Datasets..Please Help!!

8. How to INPUT data to an SQL Anywhere database via Visual Basic/Access?

9. Monitoring SQL query (simple - single table) live?

10. live queries with ObjectPAL in Ver 5

11. How to save a query result (live data)?