Dear Larry, I just learned something new that now make my programming life easier . Thank you for the suggestion. It works.
Chuck Conrad From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Tuesday, 06 October, 2009 18:34 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: EEP - Append Command << APPEND gl_genled TO gl_genled WHERE CURRENT OF cur1 UPDATE gl_genled SET acctno = 111000900 + WHERE COUNT = LAST AND amtdr > 0 APPEND gl_genled TO gl_genled WHERE CURRENT OF cur1 UPDATE gl_genled SET acctno = 111000900 WHERE COUNT = LAST >> In addition to the AND in the WHERE clause, you should be aware that COUNT = LAST is not multi-user safe. Use COUNT = INSERT instead, to get the last row inserted into the table by this session of R:Base. -- Larry Lustig
