🚀 go-pugleaf

dkeene wrote:
> Hi, Folks
> I have used interbase with delphi for a while and I am stuck trying to 
> insert a record in a table. MyTable contains a field MID which is a unique 
> identifier generated by an appropriate trigger and generator. I am trying to 
> insert a blank record using a TIBDataset. I have set the InsertSQL statement 
> to
>    INSERT INTO MyTable (MID) VALUES (GEN_ID(MyTable_GENERATOR, 1))
> 
> Then I open the dataset
>    MyDataset.Open;
>    MyDataset.Insert;
>    MyDataset.Post;
> 
> I get the error "Field MID must have a value"
> 
> Can anyone suggest the proper way to insert a new record and link the 
> Generated number to the field?
> 
> Thank you
> 
> Doug 

insert ibdataset widget on datamodule form (I recommend a dm)
(Name it dm1 for now)

set Database to appropriate db -- presume you have one
set transaction to appropriate transaction -- presume you have one.

Set select (push 3 dots) by SelectSQL property --  just pick a table you 
know and use form that pops up to do a "select * from mytable" (change 
later if you like...


right click on "mydataset" widget...
(if you get an error message save the datamodule -- sometime it desn't 
pick up that you chose a table and set SQL immediately ...)

Choose the dataset editor...

next...
click select primary keys button
click "generate SQL"

click ok

(NOW you can go back and check sql that was automatically generated...

then...

dm1.ib
mydataset.insert
dm1.mydataset.fieldbyname('...').asString; (integer or whatever...)
.
.
.

dm1.mydataset.post



And of course use a transaction to make sure record becomes visible...

There are papers on transactions -- and you _must_ know how to handle them


Look in the examples -- and maybe you should get a Marco Cantu book for 
your particular delphi.


-- 
Will R
PMC Consulting