Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
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
Today is November 21, 2024, 3:33 am This article has been viewed 35232 times.
|
|