Re: big problem about D2000

<$B%+%3%* (BJ <waimanliu_at_hotmail.com>)> schrieb in im Newsbeitrag: 38829889.7FEBF504_at_hotmail.com...
> I have a series problem about this one. I make a button 'save' and type
> the statement on it 'insert into........' and then commit, it's ok, the
> record can be save in the database, but when I create another button
> 'update', and the statement is 'update........' and 'commit', the error
> message occur 'error 40508 : erron in INSERT data'. I just update the
> record why it say error in insert data?? no matter I use what sql
> statement update, delete, once I add the statement 'commit', and this
> message will occur and the record cannot be update and delete .... does
> anybody can help me ???
>
COMMIT in Forms does not only mean commit in the db. Also all changed OR INSERTED
records in any block of the form are posted to the database. This is where the error
occurs. Check SHIFT-F1 (Show-Error) to check the statement issued.

HTH Matthias Received on Tue Jan 18 2000 - 12:54:05 CET