Issue Details (XML | Word | Printable)

Key: CORE-3850
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: pankdev
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

column does not belong to referenced table firebird example

Created: 21/May/12 04:58 AM   Updated: 21/May/12 07:12 AM
Component/s: API / Client Library
Affects Version/s: 2.5.0
Fix Version/s: None

Environment: MFC vc++


 Description  « Hide
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.



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 21/May/12 07:12 AM
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.