Missing fields when querying citadel using ADO

[MFScotty]

Hello everyone.
We are logging 372 data points in citadel.
We have a MS Access application running alongside Lookout that does a lot of processing. We use ADO to query Citadel and pull out the required data across all of the data points.
However, each time the query is run it returns a different number of fields - sometimes 368, 370 other times the full count , 372.
Obviously this is quite a problem.

Any suggestions anyone?

All the best,

Scotty

[Roli]

Hy Scotty,

Obviously you are using ADO ODBC driver that connects to Citadels ODBC driver. I used sometimes the ODBC driver for Citadel but I did not encounter such problems so far.
Do you have maybe a small MS Access example and a database example which would reproduce that behavior? I would be interessed to see how you'll get the different amount of results.

Please, let me know
Roland

[MFScotty]

Roli
(Roland?)
I emailed you a detailed description last night and have uploaded the whole database to your ftp site. Sending you the access DB would be difficult because it is a pretty complex one. I will have a look at trimming it down

Mark