Page 1 of 1

Newbie issue - Posting data...

Posted: Sat 04 Apr 2009 12:48
by jyresaa
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 :D

Thank you for all in advanced!

J.S

Posted: Thu 09 Apr 2009 08:34
by Plash
We could not reproduce the problem. Please send to ibdac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Fixed...

Posted: Fri 10 Apr 2009 06:32
by jyresaa
Seems that my problem disappeared immediately after I created new database with IBExpert GUI tool. New database was at the start much more bigger than my first one, what I created via command line. It was my very first database and to be honest, I don't even remember how I created that one. Anyway, now I'm able to post data and learn more about IBDAC.

Thank you anyway!

- J.S