Newbie issue - Posting data...
Posted: Sat 04 Apr 2009 12:48
Hi All!
I was creating my first program with C++ Builder 2009 and I have installed trial versions of IBDAC components. I use Firebird version 2.1 and I can get data from my test database.
Basically I created very basic application only by adding TDBGrid, TDBNavigator, IBCCOnnection, IBCQuery and TDataSource into my project. I filled SQL as "select * from TEST". I can get data from database into TDBGrid, but problem is that I can't add anything trough my application.
So I have not being written any lines of code, just working with TDBNavigator. I use Builder 2009 Pro and I don't have Delphi, so I can not open demo applications.
In my TEST table, there is three columns, id, name, address. id is set as auto increment, what seem to be working. After I compile & run my applications and press TDBNavigator insert button, new row appears with auto increment id number, but after I fill other two varchar fields and press post button, I will get error message
saying:
Project FirebirdTest.exe raised exception class EIBCError with message '
Dynamic SQL Error
SQL error code -206
Column unknown
NAME
At line 2, column 8'.
Would someone please tell for newbie how to insert data from my application, it would be nice feature to have
Thank you for all in advanced!
J.S
I was creating my first program with C++ Builder 2009 and I have installed trial versions of IBDAC components. I use Firebird version 2.1 and I can get data from my test database.
Basically I created very basic application only by adding TDBGrid, TDBNavigator, IBCCOnnection, IBCQuery and TDataSource into my project. I filled SQL as "select * from TEST". I can get data from database into TDBGrid, but problem is that I can't add anything trough my application.
So I have not being written any lines of code, just working with TDBNavigator. I use Builder 2009 Pro and I don't have Delphi, so I can not open demo applications.
In my TEST table, there is three columns, id, name, address. id is set as auto increment, what seem to be working. After I compile & run my applications and press TDBNavigator insert button, new row appears with auto increment id number, but after I fill other two varchar fields and press post button, I will get error message
saying:
Project FirebirdTest.exe raised exception class EIBCError with message '
Dynamic SQL Error
SQL error code -206
Column unknown
NAME
At line 2, column 8'.
Would someone please tell for newbie how to insert data from my application, it would be nice feature to have

Thank you for all in advanced!
J.S