Subject Re: [IBO] Using IBOQuery with DBGrid to modify data
Author Hans Hoogstraat
You still have to maintain an uniquekey.

Or use an after insert trigger with
if (New.UniqueKey is null) then New.UniqueKey = GenId(MyGenerator);

Then set TIBOQuery.BufferSynchroFlags = bsAfterInsert to see this
UniqueKey update.

I'll email you an working example

----- Original Message -----
From: "abedna2000" <bluehorse@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, November 07, 2004 12:48 PM
Subject: Re: [IBO] Using IBOQuery with DBGrid to modify data


|
|
| --- In IBObjects@yahoogroups.com, Hans Hoogstraat <hhoogstraat@s...>
| wrote:
| > Maybe ....
| >
| > Create Table Family (UniqueKey Integer, FName varchar(12), LName
| varchar(20,
| > Primary Key (UniqueKey))
| >
| > TIBOQuery.SQL = 'select FName,LName' .. rows can not be updated
| in Grid
| >
|
| Ok, good to know.
|
| > Check TIBOQuery.RequestLive flag
| >
|
| Well, setting it to True makes the DBGrid behave as if the data were
| edited, that's some progress, but I found out I don't know how to
| commit the changes. Might a IBOQuery.Post call before IBOQuery.Close
| be a solution?
|
| Thanks
| A.B.
|
|
|
|
|
|
|
|
|
|
___________________________________________________________________________
| IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
| without the need for BDE, ODBC or any other layer.
|
___________________________________________________________________________
| http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
| keyword-searchable FAQ, community code contributions and more !
| Yahoo! Groups Links
|
|
|
|
|
|
|