Subject embedded SQL with gpre
Author Klaus-Dieter.Opitz@ESE.de
Hi,

I have a problem with using CONNECT DATABASE.
I had wrote two functions with the same C-Code. I had preprocessed the
C-Code with the Statement
gpre -c <file>.e <file>.c -m -u <user> -p <password>
All database handles and variables after that, are in the first
function!!!!! Why?
I want programming CONNECT, FETCH, DISCONNECT in every function with the
same database.
example:
in function 1 connect employee.gdb, fetch the result from table1, disconnect
in function 2 connect employee.gdb, fetch the result from table2, disconnect
and so one.
Is this a problem for Intebase?

best regards from

Klaus-Dieter Opitz (mailto:Klaus-Dieter.Opitz@...)

ESE GmbH
Jasperallee 21
38102 Braunschweig
Germany

(http://www.ESE.de)