ADO problem

[GCTIberica]

OK, I have quite a problem with ADO! In my server, I have an ADOConnection and an ADOQuery. These are "supposed" to run concurrently, however, it doesn´t seem to work!
Therefore, if I send 2 queries to the server at the same time, sometimes the values are lost - they don´t reach the database. Does anyone know about this or has anyone had the same problem?

Thanks

 

[Zathras]

If you need two active queries at the same time, you need two TADOQuery objects. They can use the same connection.

 

[GCTIberica]

Hi Zathras
I have the queries as objects! Really I should only have one adoquery to access the db, but it doesn´t seem to work :-(

 

[Zathras]

Yes, you only need one TADOQuery if you are only going to execute one query at a time. But you said

...I send 2 queries to the server at the same time... (emphasis added)

so you need to have two TADOQuery components dropped on your form (or data module) otherwise you might find that

...sometimes the values are lost - they don´t reach the database...