I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report based on a MySQL table. This is my DQL script:
for customers ;
Customers is either the MySQL table name and the name of the DataEase form I have created over it. ID, name and age are form's fields and there are corresponding column with the same name in the MySQL table. Customers table has about 2.500 rows. The script works as expected, but is awfully slow. I also created a script using cursors to browse through the table, but I do not know how to send the output to the screen. So my questions are:
1. Is there a way to speed up my script?
2. How can I send to a report the data extracted by a SQL cursor?
3. In general, what is the best / more efficient / more fast way to create a report based on an external SQL table?
Thanks a lot.
Written by George Washington 11/04/14 at 08:26:17DataEase for Windows 7.x