any body can tell me why i get error when syncr. 2 simple tables!
it was working with the Version 8 but i use to work with the version 7 !
with version 7 i am getting this error.
----------------------------------------------------------------------------
-------
I. 07/15 14:44:23. <thread 1.5>: ml_scripts_modified last modified at:
2003-07-14 18:06:15.959000
I. 07/15 14:44:23. <thread 1.5>: Synchronization request from: ml_user
(version: default)
I. 07/15 14:44:23. [ml_user]: ODBC isolation set to: Read Committed
I. 07/15 14:44:23. [ml_user]: begin_connection <connection> (undefined)
I. 07/15 14:44:23. [ml_user]: COMMIT
I. 07/15 14:44:23. [ml_user]: begin_synchronization <connection> (undefined)
I. 07/15 14:44:23. [ml_user]: begin_synchronization cust (undefined)
I. 07/15 14:44:23. [ml_user]: COMMIT
I. 07/15 14:44:23. [ml_user]: begin_upload <connection> (undefined)
I. 07/15 14:44:23. [ml_user]: begin_upload cust (undefined)
I. 07/15 14:44:23. [ml_user]: begin_upload_rows cust (undefined)
I. 07/15 14:44:23. [ml_user]: Inserted row:
I. 07/15 14:44:23. [ml_user]: 10000001
I. 07/15 14:44:23. [ml_user]: newrecord
I. 07/15 14:44:23. [ml_user]: upload_cursor cust (open for read and write):
insert into cust(cust_id, cust_name) values ( ? , ? )
E. 07/15 14:44:23. [ml_user]: Error: Expecting 2 columns in cursor, but
found 0
E. 07/15 14:44:23. [ml_user]: Error: Unable to open upload_cursor
I. 07/15 14:44:23. [ml_user]: Warning: The handle_error script is not
defined. The default action code (3000) will decide error behaviour.
I. 07/15 14:44:23. [ml_user]: Parameters for handle_error:
sqlcode = 0
message = Expecting 2 columns in cursor, but found 0
user name = ml_user
table name = cust
script id = 2
E. 07/15 14:44:23. [ml_user]: Error: Unable to insert into table "cust"
using upload_cursor
I. 07/15 14:44:23. [ml_user]: ROLLBACK
I. 07/15 14:44:23. [ml_user]: end_connection <connection> (undefined)
I. 07/15 14:44:23. [ml_user]: COMMIT
I. 07/15 14:44:23. [ml_user]: Disconnected from consolidated database
I. 07/15 14:44:23. [ml_user]: Synchronization failed
----------------------------------------------------------------------------
------

thanks
Matani