🚀 go-pugleaf

WillR wrote:
> 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.
> 
> 

Forgot to mention -- set the Generator property in the widget to point 
to the correct generator...


-- 
Will R
PMC Consulting