Never mind. I found it really helps to start the transaction before
you try to use it.


--- In firebird-support@yahoogroups.com, "edcurren" <ecurren@a...>
wrote:

> Hello all,
> I am running into an error (below) in my code (also below) when

it

> attempts to execute the isc_dsql_prepare function. When I connect

to

> the database via ISQL I am able to run the query without a

problem.

> Thank you all for any help you may be able to provide.
>
> *** Error ***
> Dynamic SQL Error
> SQL error code = -204
> Table unknown
> ADDRESSES
> At line 1, column 15.
>
> *** Code ***
> ISC_STATUS status_vector[20];
> isc_db_handle db;
> isc_tr_handle trans;
> isc_stmt_handle stmt; /* Declare a statement handle. */
> ISC_STATUS *pStatus = status_vector;
>
> db = 0L;
> trans = 0L;
> stmt = NULL; /* Set handle to NULL before allocation. */
>
> const char *username = "SYSDBA";
> const char *password = "masterkey";
>
> char dpb_buffer[256], *dpb;
> short dpb_length;
>
> /* Construct the database parameter buffer. */
> dpb = dpb_buffer;
> *dpb++ = isc_dpb_version1;
> *dpb++ = isc_dpb_num_buffers;
> *dpb++ = 1;
> *dpb++ = 90;
>
> // Set the db user name
> *dpb++ = isc_dpb_user_name;
> *dpb++ = strlen(username);
> strcpy(dpb, username);
> dpb += strlen(username);
>
> // set the db password
> *dpb++ = isc_dpb_password;
> *dpb++ = strlen(password);
> strcpy(dpb, password);
> dpb += strlen(password);
>
> dpb_length = dpb - dpb_buffer;
>
> isc_attach_database(status_vector, strlen("db.fdb"), "db.fdb", &db,
> dpb_length, dpb_buffer);
> if (status_vector[0] == 1 && status_vector[1] > 0)
> {
> char outmsg[1024];
> char msg[512];
> isc_sql_interprete(isc_sqlcode(status_vector), msg, 512);
> strcpy(outmsg, msg);
> while( isc_interprete(msg, &pStatus) )
> {
> strcat(outmsg, msg);
> strcat(outmsg, "\n");
> }
> }
>
> char str[1024];
> sprintf(str, "SELECT * FROM ADDRESSES");
> XSQLDA *out_sqlda;
>
> out_sqlda = (XSQLDA *)malloc(XSQLDA_LENGTH(2));
> out_sqlda->version = SQLDA_VERSION1;
> out_sqlda->sqln = 2;
>
> isc_dsql_allocate_statement(status_vector, &db, &stmt);
> if (status_vector[0] == 1 && status_vector[1] > 0)
> {
> char outmsg[1024];
> char msg[512];
> isc_sql_interprete(isc_sqlcode(status_vector), msg, 512);
> strcpy(outmsg, msg);
> while( isc_interprete(msg, &pStatus) )
> {
> strcat(outmsg, msg);
> strcat(outmsg, "\n");
> }
> }
>
> isc_dsql_prepare(status_vector, &trans, &stmt, 0, str, 3, NULL);
> if (status_vector[0] == 1 && status_vector[1] > 0)
> {
> char outmsg[1024];
> char msg[512];
> isc_sql_interprete(isc_sqlcode(status_vector), msg, 512);
> strcpy(outmsg, msg);
> strcpy(outmsg, "\n");
> while( isc_interprete(msg, &pStatus) )
> {
> strcat(outmsg, msg);
> strcat(outmsg, "\n");
> }
>
> FILE *f = fopen("C:\\Temp\\Dump.sql.out", "w+r");
> fwrite(outmsg, 1, strlen(outmsg), f);
> fclose(f);
> }
>
> isc_dsql_execute(status_vector, &trans, &stmt, 1, NULL);
> if (status_vector[0] == 1 && status_vector[1] > 0)
> {
> long SQLCODE;
> char msg[512];
> SQLCODE = isc_sqlcode(status_vector);
> isc_sql_interprete(SQLCODE, msg, 512);
> }
>
> isc_dsql_describe(status_vector, &stmt, 1, out_sqlda);
> if (status_vector[0] == 1 && status_vector[1] > 0)
> {
> char outmsg[1024];
> char msg[512];
> isc_sql_interprete(isc_sqlcode(status_vector), msg, 512);
> strcpy(outmsg, msg);
> while( isc_interprete(msg, &pStatus) )
> {
> strcat(outmsg, msg);
> strcat(outmsg, "\n");
> }
> }