Subject | Re: GPRE/API Different with FB 1.5? |
---|---|
Author | Eric Boyajian |
Post date | 2004-02-27T18:41:35Z |
--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov"
<SD@t...> wrote:
select * from country
I'm using the employee.fdb as a test database.
I am running the FB 1.5 server on WinXP as a service, and I'm
developing using MSVC 6.0.
Let me mention that I use the following command to create the .cxx
file from the .exx source code file:
"C:\Program Files\Firebird\bin\gpre.exe" -e -m -sql_dialect 3 -user
SYSDBA -password masterkey full_no_echo.exx
This is where I installed the system, and firebird.msg is in this
folder.
I also have a copy of firebird.msg in the working directory where my
program executes (C:\Program Files\Firebird\examples). Is there
another location that a copy of firebird.msg must exist?
Eric
<SD@t...> wrote:
>> however, there seems to be a difference between FB 1.0 and 1.5Do you mean the local variable :string? This is:
>> that is causing giving me a problem.
>
> Yes, FB 1.5 is more strict for SQL syntax.
>
>>EXEC SQL
>> PREPARE TRANSACTION gds_trans Q1 INTO sqlda FROM :string;
>
> Show us Q1.
select * from country
I'm using the employee.fdb as a test database.
I am running the FB 1.5 server on WinXP as a service, and I'm
developing using MSVC 6.0.
Let me mention that I use the following command to create the .cxx
file from the .exx source code file:
"C:\Program Files\Firebird\bin\gpre.exe" -e -m -sql_dialect 3 -user
SYSDBA -password masterkey full_no_echo.exx
> Make sure that you have firebird.msg from FB1.5 everywhereMy INTERBASE environment variable is "C:\Program Files\Firebird".
> because it has been changed since FB1
This is where I installed the system, and firebird.msg is in this
folder.
I also have a copy of firebird.msg in the working directory where my
program executes (C:\Program Files\Firebird\examples). Is there
another location that a copy of firebird.msg must exist?
Eric