` Printed Icetips Article

Icetips Article



SQL Related Articles: MySQL and True page loading in Legacy
2002-12-01 -- Dan Pressnell
 
I've created a template that will turn Legacy template browses for MySQL into true page loaded browses. I've added it to the package that does page loaded ABC browses.
 
http://toolwares.com/MySQLabBrowse.ZIP . To use:
 
1. After installation, copy mysqlbr.tpl to Clarion's template directory.
 
2. Register the mysqlbr.tpl template with Clarion.
 
3. In your app, add the global extension MySQLBrowseSupport, and click the check box.
 
4. For the browses you want page loaded, add the MySQLBrowse extension.
 
There is one important thing that this template (and the ABC class) won't do correctly. If you use "ValidateRecord" code to to filter records, your list box won't be filled. There is no way to fix that, so avoid that technique.
 
There is another thing to look out for with the legacy template. If you have a page loaded browse, and call a procedure that retrieves records on the same table, you MUST have a window open in that other procedure before the retrieval, or that procedure will have its result set incorrectly limited. I might be able to fix this in the future, but it's difficult given the lack of adequate embed points in Clarion's legacy browse template.



Printed May 5, 2024, 1:57 am
This article has been viewed/printed 35117 times.
Google search has resulted in 102 hits on this article since January 25, 2004.