Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
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 May 2, 2024, 1:04 am This article has been viewed 35121 times.
|
|