| ivanDBU 2005-05-07, 7:23 am |
|
accessing PB 6 application via ODBC to a MySQL database
I have converted an SQL Anywhere 7 db to become a MySQL db. I succeeded
to connect a Powerbuilder 6.5 application via MySQL ODBC but when
executing datawindow queries I receive an error message complaining
about not using the right syntax. See below:
/*** Retrieve - dw_main TimeStamp: 07/05/05 12:25:07:78 ***/
SELECT art.db_art_id , art.db_lev_id ,
art.db_art_naam , art.db_art_lev_ref ,
art.db_art_inkoop_prijs , art.db_art_winst ,
art.db_art_netto_prijs , art.db_art_bruto_prijs ,
art. db_art_laatste_prijs
, art.db_art_kommentaar ,
art. db_art_kreatie_datum
, art.db_art_btw_kode ,
art.db_art_netto_euro , art.db_art_bruto_euro ,
art.db_art_druk , art.db_art_inkoop_euro FROM art
WHERE ( "art"."db_art_id" = ? )
/*** DBError - dw_main(0) TimeStamp: 07/05/05 12:25:07:82 ***/
/*** Database error code: 1064
Database error message: Select error: SQLSTATE = 23000
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near
'."db_art_id" = '0000112' )' at line 1 ***/
Can anyone help me sorting this out please ?
thx
Ivan
|