Simplicty and flexibility!

Started by George Washington
You will need to Sign In to be able to add or comment on the forum!

Hi there,

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 ;

  list records

    ID ;

    Name ;

    Age .


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:17 DataEase for Windows 7.x