Query returning live-result...

Query returning live-result...

Post by Sylvain St.Germai » Tue, 10 Sep 1996 04:00:00


(Using Delphi 2 and Sybase SQL Anywhere 5.02)

I learned that in order to be able to modify the query results
from within a DBGrid, the query must return a live set.

I also learned that a live set is obtained by :
 1 - using the open method of the TQuery
 2 - having a query refering to only one table

This is what I am doing... However, I have in my DBGrid a lookup
field which is working fine into the DBGrid but does not post
the changes to the database...

Am I missing something here? Any help appreciated.



Query returning live-result...

Post by Stephen Novotn » Wed, 18 Sep 1996 04:00:00

Make sure that your not using an order by clause in the SQL,
and the property 'request Live' of TQuery := TRUE



1. Live Query Result Set where PK also FK

We have discovered a problem with using a live Query updateable result set in
Delphi 1.0.  When the column being updated has the following characteristics
we get an integrity constraint violation on our Oracle 7.1 database:

Column part of the  Primary Key
Column is also a Foreign Key to a different table
Column is a TStringField

I know this sounds strange but we have over 100 tables in our model and we
tested this theory on over twenty tables and the problem seems to be real.  

1) Is this a known bug?  It seems rather large to have gone unnoticed
2) Is this problem unique to Oracle 7.x servers
3) Anyone know of a work around?

Any help is appreciated.  -tv

2. help with SQLMail

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

4. upsizing timeout error

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

6. Users lost

7. Full Text Query Return 0 Rows When Valid Results are Present in the dat

8. How do I unsubscribe?

9. Query with executing dynamic sql statements and returning result to variable

10. Contains query doesn't return expected results

11. Can Stored Procedures return results to Queries?

12. function to return query result

13. SQL Query - returning n results