R&R 10.1.001 and MySQL

[Jose_R_Gonzalez_(Guest)]

Hi:____ I have been using R&R Xbase for many years and recently updated to the combined Xbase/SQL program. I am porting a program to SQL and have spent many months learning MySQL. Since all my previous reports are in R&R, I was hoping to convert them to SQL and use them with MySQL. Using MyODBC 3.51 I can make an SQL Report but I can^t run it. Although the various fields are there to insert, when the program runs, it keeps accesing the database without stopping. This happens with auto-sql as well as user-sql. Is there anything I can do to correct this?____Jose

[kfleming]

What happens if you try Database->Limit Result?____Kathleen__R&R Support

[Jose_R_Gonzalez_(Guest)]

Hi Kathy:__ Using limit makes no difference, either with auto or placing it in the query with user. I also tried converting to SQL but using the dbf data connect with *.dbf files and this works. It seems to be a specific problem with MyODBC and MySQL. I was wondering whether there is anyone that has gotten it to work, and, if so, how they did it. My other question is if there is a workaround for the join command with databases that have no field link. In the XBASE R&R, a calculated field was created with a value of 1 in the controlling table, and this served as a link.____Thanks,____Jose__

[kfleming]

You can do a USER SQL report where you write the SELECT to do that kind of join or you can choose a calculation that R&R determines to be available for evaluation by the database engine.__These calculations will display an (x) on the status bar when selected in the report.______Kathleen__R&R Support