Ed,
I'm pretty sure it's possible to connect to a MySQL database using 4GL because they provide an adaptation guide for MySQL (http://www.4js.com.au/docs/odi/odiagmys.htm). However, we have never done it before.. we're curently using Oracle and Informix databases but want to try out MySQL...
Update
I decided to compile and run a program I found in $FGLDIR/src called testbase.4gl. This program failed at the attempt of creating a database and displayed the following error message:
status error nr -6365:
Database driver not connected yet.
I tried looking up the error number for more...
Hey,
I'm trying to refer to a MySQL database in a 4GL program with no success. This is the error I get when I try to compile my program:
DATABASE statusdb
| Can not open Database dictionary 'statusdb'. Run fglschema database.
| See error number -6601.
So I try fglschema statusdb and:
ERROR...
I continued experimenting and I found out how to use dbFailOnError. I should be able to find out why it's not working now. Sorry about the last post.
Samy
I'm having a similar problem (Insert Into statement works but the tables are still empty). However, I don't have any keys on my tables because I don't really need them. I tried using the debugger to find out what the SQL statement looks like it and it looks fine. Everything runs without errors...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.