search

FirebirdSQL / firebird

Firebird server, client and tools
https://firebirdsql.org
1.26k stars 217 forks source link

column does not belong to referenced table firebird example [CORE3850] #4191

Open firebird-automations opened 12 years ago

firebird-automations commented 12 years ago

Submitted by: pankdev (pankdev22)

I am facing a problem with Firebird,

i m using Interbase SDK(API) for Firebird and Interbse to create and insert the data in Database file

char *create_tbl = "CREATE TABLE tm_1(C1 TIME)"; insert_data = "INSERT INTO tm_1(C1)VALUES('01:03:07')";

if (isc_dsql_execute_immediate(status, &handle, &trans, 0, insert_data, 1, NULL)) { char msg[512]; memset(msg,0,sizeof(msg)); long errorCode=0; if (status[0] == 1 && status[1] > 0) { errorCode=isc_sqlcode(status); isc_sql_interprete(errorCode,msg, 512); int y=90; } } isc_commit_transaction(status, &trans);

this shown following error: column does not belong to referenced table firebird example

what will i do for this.

firebird-automations commented 12 years ago

Commented by: @AlexPeshkoff

With fresh build of 2.5 it's not reproduced in isql: fbs2 bin #⁠ ./isql employee Database: employee SQL> CREATE TABLE tm_1(C1 TIME); SQL> INSERT INTO tm_1(C1)VALUES('01:03:07'); SQL> commit; SQL>

So I suggest you: 1. Try with fresh build of 2.5. Checking both 2.5.1 and current snapshot will be good idea. 2. If does not help - add FULL COMPILABLE test case to your ticket.