strange errors 15 with [mysql] connection

[Thomas Bock]

We encounter strange errors 15 with [mysql] connections when rewinding the record pointer.

Code: [Select]

-}?tcb(32)
 16
-}open(1)"data/ab/A0FP01"
-}?pth(1)
[MYSQL]koss;mw01_form_para
-}read record(1,key=$$,kno=0)r$
Error #11: Record not found or Duplicate key on write
Last IO to [MYSQL]koss;mw01_form_para, channel 1
-}? key(1,kno=0)
Error #15: Operating system command failed
Last IO to [MYSQL]koss;mw01_form_para, channel 1
MYSQL:0:
-}?ken(1)
SELECT `formular`,`b_menge`,`l_menge`,`r_menge`,`mg_maske`,`me_x`,`art_nr`,`e_preis`,`ep_maske`,
`pe`,`waehrung`, ..., `use_overlay`,`archivdauer` FROM mw01_form_para WHERE `formular` > '' ORDER BY `formular`

Indeed there is no error 15, because the MySQL log files show no errors. The KEY() function works in the expected way with many other tables. But some tables show this error.
As far as I can do some try and error tests there seems to be a dependency to the option NONUMADJ. If set to "N" everything is fine, but if set to "Y" the errors occur. We need to work with "NONUMADJ=Y".

[dlocke]

Hi Thomas

Can you explain how you got this command to open a MYSQL table ?   

open(1)"data/ab/A0FP01"

I 'm looking through the manual and can't find anything on how to do this. 


Don Locke.

[Thomas Bock]

Hi Don

At that time we did some experiments with the Database Conversion Utility. This tool maintains a prefix file.
Take a look at the prefix directive format #4. It enables your programs to work with a SQL-table without changing your existing program code.

[dlocke]

Thanks Thomas

Got it to work thanks for your  help.

Don Locke.