` MySQL and True page loading in Legacy (Dan Pressnell) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

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.


Today is April 25, 2024, 11:33 am
This article has been viewed 35111 times.
Google search has resulted in 102 hits on this article since January 25, 2004.



Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password: