PB in dw. Update can successfully saved, but the INSERT tip error,
Prompt content is essentially A request resulted in A bad return code or status but no error message was returned
No changes made to the database.
INSERT INTO DX_SZ_GB (CODE, NAME) VALUES (99, 'first')

The database is sql2000.
If tab_1. Tabpage_2. Dw_edit. The update ()=1 then//save success
commit using sqlca;
The else
Ls_error=sqlca. SQLErrText
Messagebox (' ', ls_error)
The rollback using sqlca;
End the if

Please help to solve. Thank you very much.

CodePudding user response:

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


Have a look at your watch DX_SZ_GB in several fields, with field without assignment?

CodePudding user response:

PB in dw. Update can successfully saved, but the INSERT tip error,
Is the definition of fields in the table type then you have changed, to regenerate the DW window, try to save again,

CodePudding user response:

You: my PB development version is 9.01, MSSQL 2000, beat sp3 and version number is 8.00.2039
I have built a dw again, it's the same case, an error, using pb for years, first encountered this kind of question,

CodePudding user response:

This table, have identity column ah?

CodePudding user response:

 please check directly in the SQL query analyzer can execute the following script execution success? 
INSERT INTO DX_SZ_GB (CODE, NAME) VALUES (99, 'first') 

CodePudding user response:

Change the insert table?

CodePudding user response:

Whether the code value '99' already exists in the database

CodePudding user response:

I met a computer seems to have one before this kind of situation, reshipment