Subject | Re: [IBO] Using IBOQuery with DBGrid to modify data |
---|---|
Author | Hans Hoogstraat |
Post date | 2004-11-07T18:33:32Z |
Maybe ....
Create Table Family (UniqueKey Integer, FName varchar(12), LName varchar(20,
Primary Key (UniqueKey))
TIBOQuery.SQL = 'select * from Family' .. rows can be updated (UniqueKey
Info retrieved)
TIBOQuery.SQL = 'select FName,LName' .. rows can not be updated in Grid
Check TIBOQuery.RequestLive flag
Create Table Family (UniqueKey Integer, FName varchar(12), LName varchar(20,
Primary Key (UniqueKey))
TIBOQuery.SQL = 'select * from Family' .. rows can be updated (UniqueKey
Info retrieved)
TIBOQuery.SQL = 'select FName,LName' .. rows can not be updated in Grid
Check TIBOQuery.RequestLive flag
----- Original Message -----
From: "abedna2000" <bluehorse@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, November 07, 2004 10:40 AM
Subject: Re: [IBO] Using IBOQuery with DBGrid to modify data
|
|
| --- In IBObjects@yahoogroups.com, Hans Hoogstraat <hhoogstraat@s...>
| wrote:
| > Is it possible your table is missing an unique index for each row
| of
| > information ?
| >
|
|
| Well.. the Query contains result of a SQL statement, so it depends on
| which columns were selected...? In the database every record has an
| unique key.
|
| And maybe, that I'm not setting the KeyLinks property of the
| IBOQuery, because the result varies of course, if that would be an
| issue, but I have a good experience with how IBO sets KeyLinks
| automatically...
|
| Any comments?
| 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
|
|
|
|
|
|
|