Par2: Retaining row after auto inc add (SQL) 2004-12-09 -- Andre Englebrecht My sincere thanks to Bruce & Leslie from CapeSoft and Eric Churton. Once again they came to my rescue Details of the problem and solution may be of value to someone ... Problem An insert into the standard .tps browse returns and highlights the new record. If the file-driver is sql with an autoincrementing primary key (eg RecordNo) on the sql back-end, an insert into an abc template generated browse returns and highlights the last row Solution In Global Properties/Classes/Browser, select BrowseClass. Select Configure. Set Retain Row (ON) [It appears that the switch defaults to ON for ISAM and System files, but OFF for Sql files] In the Update Window of the browse, WindowManager/TakeCompleted, Fetch the record by a key other than the auto-incremented key Printed May 1, 2024, 10:21 pm This article has been viewed/printed 35120 times. |