Now to the SYBASE database data from a table into SQL SERVER, the corresponding list to write programs in POWERBUILDER10. Can also perform after finished the program, but I can't found in SQL SERVER list from the data. After debugging found application in the following few lines out of the question:

//cycle
The do while SQLCA_AS. SQLCODE=0

//read a row
The fetch Cur_gds into: c_gid, c_gcode, : c_subcode, c_barcode, : c_pluno, c_ccode, c_name, : c_subname, : c_basic_unit;

//to write data into the SQL SERVER database table (tb_gds)
Insert into tb_gds (c_gid) values (: c_gid) using the SQLCA.
LOOP
SQLCA_AS as from the SYBASE data of the transaction, the SQLCA to SQL SERVER transaction data.
Program is running to insert into tb_gds (c_gid) values (: c_gid) using the SQLCA. After passed, without any hint of pass the data in SQL SERVER and can't see, does anyone know why this is?
Database is c_gid int type; The PB c_gid variables for long.

CodePudding user response:

You use a messagebox (" ", the sqlca. Sqlerrtext) check, and see what tip

CodePudding user response:

Problem clearly. Because the goal list has three fields can't be empty, and I didn't pass this a few fields, so the transmitted data is not successful.

CodePudding user response:

sha

CodePudding user response:

Support her Lord, collection