[idpintl]

It seems I answered my own question . . . . .

http://forums.devshed.com/t67976/s.html&hi…light=bookmarks

[idpintl]

Thanks for the clarification Shadow.

[idpintl]

I have posted the logs containing the SQL statement at the following locations:

Note: I posted on our website because the pages of these logs are too long to post here.

odbc_trace.txt was run today because there have been some configuration changes to the SQL DB. There were two sync's performed during this trace (the first one was updating fields: successful; the second was inserting a new record into the PDA: failed)

sql.txt was run last Thursday, and is the log that the Syware tech looked at and commented on.

http://www.idpintl.org/temp/odbc_trace.txt

http://www.idpintl.org/temp/sql.txt

CalEvans: Yes, I have made NTBN an auto_increment number. And I wholly agree with you, the PK is being given a value that already exists. However, I do not understand the reason for removing the NTBN number from the insert statement (I am very new to this by the way).

Thanks for your time – JW

[idpintl]

I am synchronizing data through an add-on to the Syware Visual CE package called MEnable – this allows us to synchronize the PDA table's to the SQL tables. And by “updating data” I mean adding new information to a patients' on-going record. The underlying problem is this: when I add new patient's to the SQL database, this information easily sync's to the PDA (and these records can be updated with additional data from the PDA); however, the sync only fails when a new record is added to the PDA and the initial sync to the SQL DB is performed. So long as the record is originally added in SQL I can update any record in the DB and PDA without fail.

I have been troubleshooting this with a tech from Syware, and he's convinced this is a SQL problem. His reply this morning was:

SQLSetPos(SQL_ADD) appears to have a bug in it. We pass the value 2 as the second parameter to the call. It appears that it is interpreting it as 1.

Any thoughts?

[idpintl]

The PDA is an iPAQ PocketPC with Windows CE. The conduit is commercial, which is a software called Visual CE from Syware. This project is a non-profit humanitarian endeavour for the purpose of managing Tuberculosis in third-world settings. Our health workers in Uganda utilize the PDA to capture and record data on patient compliance to medication, patient disposition, etc., and the data is synchronized through the Internet (via mobile phone connected to the PDA) to the primary TB database.

[Author]

Posts