ADOCE DataTable issues

[Guest]

I am having some strange issues with some Data Tables in my application and
was hoping someone could help shed some light on the issue or at least tell
me if it seems like the correct behavior.

Basically, my DataTables quit working properly when they, for a lack of a
better word, lose focus. So for instance, if I have two seperate DataTables
open, the first DataTable wont SAVE any data after I have opened or filled
some data to the second DataTable. I say SAVE because records can still
being written to the DataTable (I can navigate between them) but they do not
get saved to the database from the point in which I opened/filled the second
DataTable. I have stripped down my code to the bare basics of opening and
populating datatables and have verified this behavior. So in psuedo code.....

SCENARIO 1 - THIS WORKS PROPERLY
-Create and Fill DataTable
-Bind Controls on my Form
-Add Records
-Save DataTable
-Data is correctly added to the database


SCENARIO 2 - THIS DOES NOT WRITE THE DATA TO THE DATATABLE

-Create and Fill DataTable
-Bind Controls on my Form
-Add Records
-CREATE AND FILL A SECOND DATATABLE
-Add more records.
-Save DataTable
-No Data gets saved to the first DataTable.

I am perplexed because I have several previoulsy working apps that are now
showing this behavior. I know I used to be able to do this type of thing
with no problem. Note: I'm using InTheHand ADOCE library in my app(s).


Thanks!

 

[Peter Foot [MVP]]

This is certainly an odd issue. Are you using the same data adapter to fill
both datatables separately? For the AdoceDataAdapter to work in the current
version, you must use the same data adapter you used to fill the dataset to
later update it.
If you can send me some specific code snippets (take the nospam out of my
email address) I can try and help work through the issue some more.

Peter

 

[Guest]

Peter, I am using different Data Adapters to fill each DataTable. I sent you
some code snippets via your instructions below. Thank-you for your help!

Mike