Thanks to everyone who helped me solve this migration headache !
If it interests you, my problem was getting an error message when
connecting to the database at execution time. Picture this...
In my prebody I had this code:
Database DATA
VARIABLE g_atyp.* LIKE atyp.*
Those 2 lines declare a global variable being like a database table. The
problem arose when at run-time, the "Database DATA" was executed, thus
connecting to the database, and then, the MAIN was executed (!) This
sounds strange as I thought the MAIN block was always executed first.
Therefore, with the connection existing, and trying to connect again in
the MAIN, produced errors.
The -1801 error resulted. Briefly, to solve this error one must use the
"WITH CONCURRENT TRANSACTION" statement when connecting to the database.
(I have a Standard Engine 5 here)
Ok, here are the questions:
What is the "WITH CONCURRENT TRANSACTION" statement ? Cant seem to find
it in any manual or help files.
I have many variable declared LIKE tables. To do this, you must include
the DATABASE statement before any declarations of this type, otherwise
I'll get a compilation error (Table atyp not defined in database). Is
there a way to solve this ?
David