Good day,
I am trying to use your program (gixpp) on Debian 12 64Bit, by console.
I build it, and, I think, it works.
When I try to run a compiled gnu-cobol (3.2.1) program accessing to MY-SQL database and I try to "INSERT INTO..." I got the error
ERR - INSERT : -0000001054
ERR - INSERT : Unknown column '$1' in 'field list'
But if I use the full SQL sentence (INSERT INTO NUMERI(NUMERO) VALUES('PROVA')) it works perfectly.
I have the same error when I try to run TSQL037A-MYSQL.cbl
The database server is MY-SQL 8.4.3 for Linux on x86_64 (MySQL Community Server - GPL)
I am not a professional, I am simply an amateur, I like to "play" with COBOL an Databases, just for fun and relax.
Thank you in advance for the help you could offer me.
(we can speak in italian, if you want.)
/-------------------/
I could check a Windows .cbsql file, and I noted that in the define of the SQL sentence (INSERT INTO table (field) VALUES ('values')) there is a '?' and not a '$1'.. so... I changed in the linux source, builded and works.
Linux
GIXSQL 02 FILLER PIC X(0039) VALUE "INSERT INTO NUMERI(VALORE) VA"
GIXSQL & "LUES ( $1 )".
GIXSQL 02 FILLER PIC X(1) VALUE X"00".
Windows
GIXSQL 02 FILLER PIC X(0039) VALUE "INSERT INTO NUMERI(VALORE) VA"
GIXSQL & "LUES ( ? )".
GIXSQL 02 FILLER PIC X(1) VALUE X"00".
Good day, I am trying to use your program (gixpp) on Debian 12 64Bit, by console. I build it, and, I think, it works. When I try to run a compiled gnu-cobol (3.2.1) program accessing to MY-SQL database and I try to "INSERT INTO..." I got the error ERR - INSERT : -0000001054 ERR - INSERT : Unknown column '$1' in 'field list' But if I use the full SQL sentence (INSERT INTO NUMERI(NUMERO) VALUES('PROVA')) it works perfectly. I have the same error when I try to run TSQL037A-MYSQL.cbl
The database server is MY-SQL 8.4.3 for Linux on x86_64 (MySQL Community Server - GPL)
I am not a professional, I am simply an amateur, I like to "play" with COBOL an Databases, just for fun and relax. Thank you in advance for the help you could offer me. (we can speak in italian, if you want.) /-------------------/ I could check a Windows .cbsql file, and I noted that in the define of the SQL sentence (INSERT INTO table (field) VALUES ('values')) there is a '?' and not a '$1'.. so... I changed in the linux source, builded and works. Linux
GIXSQL 02 FILLER PIC X(0039) VALUE "INSERT INTO NUMERI(VALORE) VA" GIXSQL & "LUES ( $1 )". GIXSQL 02 FILLER PIC X(1) VALUE X"00".
Windows
GIXSQL 02 FILLER PIC X(0039) VALUE "INSERT INTO NUMERI(VALORE) VA" GIXSQL & "LUES ( ? )". GIXSQL 02 FILLER PIC X(1) VALUE X"00".