Hmm... I guess I'm looking for independent confirmation from
anyone. So I'm including a complete C++ program that works with FB
1.0 and does not work with FB 1.5. Again, the problem is with the
PREPARE statement.

At this point, I assert that the isc_embed_dsql_prepare(...) function
has been broken from FB 1.0 to FB 1.5. Can someone show me what I am
doing wrong? Should I submit this a bug? Perhaps I'm the only one
who uses embedded SQL and GPRE anymore.


Eric


Sample Program ================================
#include <stdio.h>
#include <stdlib.h>
#include <string.h>

char db_name[128];

// For FB 1.0 use employee.gdb, and link with gds32_ms.lib.
// for FB 1.5 use employee.fdb, and link with fbclient_ms.lib.

DATABASE DB = COMPILETIME "C:\Program
Files\Firebird\examples\employee.fdb"
RUNTIME db_name;

EXEC SQL
INCLUDE SQLCA;

int main(int argc, char** argv)
{
char sqlString[256];
XSQLDA* sqlda;

// Set database name.
strcpy(db_name, "C:\\Program
Files\\Firebird\\examples\\employee.fdb");

// Open database and start tansaction.
EXEC SQL
CONNECT DB USER 'SYSDBA' PASSWORD 'masterkey';

gds_trans = (isc_tr_handle) 0;
EXEC SQL
SET TRANSACTION NAME gds_trans;

// Set up SQLDA for SELECTs, allow up to 150 fields to be selected.
sqlda = (XSQLDA*) malloc(XSQLDA_LENGTH(150));
sqlda->version = SQLDA_VERSION1;
sqlda->sqln = 150;

// Prepare a query.
strcpy(sqlString, "SELECT * FROM COUNTRY");
EXEC SQL
PREPARE TRANSACTION gds_trans Q1 INTO sqlda FROM :sqlString;

EXEC SQL
COMMIT TRANSACTION gds_trans RELEASE;

return 0;
}
End of sample program ===================================