Error PB to save insert data? Please help...

PB dw.update can be successfully saved, but the INSERT prompt error.
Prompt is A SQLServer request resulted in a bad return code or status but no error message was returned
No changes made to database.
INSERT INTO DX_SZ_GB ( CODE, NAME ) VALUES ( 99, 'Debut' )

The database is SQL2000.
if tab_1.tabpage_2.dw_edit.update() = 1 then //Successfully saved
commit using sqlca;
else
ls_error = sqlca.SQLErrText
messagebox('',ls_error)
rollback using sqlca;
end if

Please help to solve. Be indebted forever.

Started by Verne at February 01, 2016 - 4:36 AM

INSERT INTO DX_SZ_GB ( CODE, NAME ) VALUES ( 99, 'Debut' )


Look at your table has several fields in DX_SZ_GB, is not a field has no value?

Posted by Baron at February 09, 2016 - 5:14 AM

PB dw.update can be successfully saved, but the INSERT prompt error.
Is not your field in the table definition type was changed, the DW window to generate, and then save.

Posted by Joshua at December 02, 2016 - 1:17 AM

You: I development version of PB 9.01, MSSQL 2000, hit SP3, 8.00.2039 is the version number
I have been re built a DW, is in the same situation, error. Using PB for many years, encountered this problem first.

Posted by Verne at December 07, 2016 - 1:46 AM

In this table, there is not an identity column.?

Posted by Miya at December 20, 2016 - 1:59 AM

Please check directly in the SQL query analyzer to perform the script can execute successfully? 
INSERT INTO DX_SZ_GB ( CODE, NAME ) VALUES ( 99, 'Debut' )

Posted by Joshua at January 03, 2017 - 3:54 AM

A table is inserted.?

Posted by Janet at January 04, 2017 - 2:31 AM

The code value '99' is already exists in the database

Posted by Brandon at January 06, 2017 - 3:29 AM

I've met a computer has this kind of situation, reinstall resolved

Posted by Montague at January 13, 2017 - 3:46 AM