Hi all Hope someone can help with this because it is driving me nuts!!
I have this code snippet to insert a record into the customers table ** f_rn is auto Inc field in tblcustomers ** oCrCustomers is a cursor adapter to tblcustomers and returns alias of customers oCrCustomers.cSelectCMDFilter="f_rn=0" && just create an empty cursor. oCrCustomers.Cursorfill() Select Customers Append blank repl cust_name with "Hello" =tableupdate() I'm trying to find an easy way to retrieve the value of f_rn for this record, the only way I can see is to do oCrCustomers.cSelectCMDFilter="cust_name='Hello'" oCrCustomers.cursorfill() m.f_rn=customers.f_rn Thanks Graham Brown CompSYS Software Solutions T:0845 202 8480 BNI Member. The Business Referral Organisation _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
