R&R ver 10.1.003 and MyODBC,MYSQL

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Jose_R_Gonzalez_(Guest)
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

R&R ver 10.1.003 and MyODBC,MYSQL

Post by Jose_R_Gonzalez_(Guest) » Thu Apr 01, 2004 10:56 am

Hi:__ I have not been able to find out if R&R 10.1.003 can work with MyOdbc 3.51 and MySQL. I have tried everything I can think of and always get the same result. When asking for a result set, the dialgog that is presented just scans records without stopping. In print preview, pages are printed without stopping. No database related information is printed, only pageno, written text, etc.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> R&R ver 10.1.003 and MyODBC,MYSQL

Post by kfleming » Mon Apr 05, 2004 4:07 am

What data types are the fields in the report?____Kathleen__R&R Support

Jose_R_Gonzalez_(Guest)
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

==> R&R ver 10.1.003 and MyODBC,MYSQL

Post by Jose_R_Gonzalez_(Guest) » Mon Apr 05, 2004 2:23 pm

Hi Kathleen:____ I use a blank report, user SQL, add a title and a page number. In the record band I add a numeric field, the row_id that MySQL uses for record number (int11), and a character field, the last name of an individual. The query is : "Select row_id, last from record for row_id <^30^". The result keeps counting records without stopping. The print preview also keeps counting pages. The title can be seen, as well as the page number. The row_id^s are all zeroes, and the last names are all blank. The table record has about 13,000 rows, and I let the search go on for well over 100,000 rows. It^s as if R&R is querying the database for something it cannot find.

Post Reply