Tom,
In the past, R:BASE has been very forgiving of a lot of stuff. As the product evolves and things get tightened, some of what used to work but perhaps shouldn't have may stop working. SQLCODE is only valid for use in conjunction with SQL commands. SQL commands operate on tables or the data within the tables directly, and ENTER/EDIT are not part of the SQL specification. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Friday, May 14, 2010 10:58 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Scratch I agree my code is not the best, but what happened in the lastest update to make this not work. Tom Hart _____ From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, May 14, 2010 9:52:55 AM Subject: [RBASE-L] - Re: Scratch Aha! I could be wrong, but "edit using" is not a sql command, therefore it does not evaluate properly using "sqlcode". As Bill stated in an earlier email, trapping for sqlcode should only work for an actual sql command (such as select, insert, update). "edit using" is an RBase command to bring up a form... Karen Forgot to say there are no triggers, just a simple Edit using form, if sqlcode <>0 then, Enter using form. Tom Hart
