Re: Some questions on SPL, need your help!
Posted in 1997
Xu Wenwei wrote: > > Anyone who can answer my questions on SPL? Thanks in advance. > > 1. In SPL , after an insert statement , how can I read Rowid and System Serial of > this record By using the function "dbinfo( 'sqlca.sqlerrd1' )". > 2. Can sqlca.sqlerrd[] be used in SPL (just as used in 4GL)? No, have a look at your manual and try to find some information about the dbinfo() function. > 3. In SPL, how to judge the correctness after the operation of database, > I found * if (SQLCODE = 0) ... * did not work. At the end of your SQL Syntax Guide you will find all the information concerning SPL, especially about EXCEPTION handling. > > Note, our database engine is Online 5.0 > > Any of your suggestions will highly appreciated. > > Sincerely, > Wenwei Xu Bye Stefan