🚀 go-pugleaf

Hi James,

I am using BCB6 Ent. SP4, MS-SQL2K SP3a. I created a table as you described:

create Table Data (
   [RecNumber]            [int] IDENTITY(1,1),
   ItemNumber             Char(30),
   ItemDescription        Char(60)
   Primary key(RecNumber)
);

I then created a button with the following OnClick:

ADOCommand1->CommandText = "insert into data(ItemNumber, 
ItemDescription) values ('I101', 'First Item')";
ADOCommand1->Execute();

The connection string for my ADOCommand1 is:

Provider=SQLOLEDB.1;Password=SomePassword;Persist Security 
Info=True;User ID=SomeUsername;Initial Catalog=TestDB;Data Source=127.0.0.1

This works.

Regards,
Syd.




James Peterson wrote:
> Project convert.exe raised exception class EOleException with message
> '[Microsoft][ODBC SQL Server Driver] Optional feature not implimented'. when
> i run the program using
> 
> ADOCommand1->CommandText"insert into data(fields)values(data)";
> ADOCommand1->Execute();
> 
> I do have an AutoIncrementing field.
> create Table Data (
> [RecNumber] [int] IDENTITY(1,1),
> ItemNumber Char(30),
> ItemDescription Char(60)
> ..
> ..
> ..
> Primary key(RecNumber))
> 
> I am guessing ADOCommand is crashing on the AutoInc field. how can I correct
> this?
> 
> 
>