I'm not sure that I understand what you mean with 'UpdateSQL statement'. In
my TIB_Query mostly a 'select * from Table_xy', maybe in some queries with a
'where...' for filtering, is working. I know there is an UPDATE statement,
but when should I use it? Or is it only one more possibility to do it?

Or is that what IBO is doing implicit for me in the background?

Ulrich

""Jason Wharton"" <jwharton@...> schrieb im Newsbeitrag
news:025c01c260c0$5e214060$dc756a41@CX170673E...

> If you set RequestLive to true then the query should figure out how to

make

> it live for you. This is false by default. It is also possible to put in
> your own UpdateSQL statement that will automatically make the dataset
> editable. So, either set RequestLive to true or provide your own UpdateSQL
> statement and it should work fine.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: <ulrich.groffy@...>
> To: "IBObjects Newsgroup" <IBObjects@yahoogroups.com>
> Sent: Tuesday, September 17, 2002 4:34 AM
> Subject: [IBO] Set a TIB_Query into dssEdit mode
>
>
> > Hm, I'm not shure what kind of problem it is, but I try to describe :
> >
> > My app is working as a MDI application with one central TIB_DataBase
> > component. I placed TIB_Querys and TIBDataSources on the MDI-Child

forms.

> Up
> > to now I have no Master-Detail relations between any TIB_Querys.
> >
> > There are no foreign keys in the database definition. (might be
> important?)
> >
> > It's working fine, but during my programming and testing I noticed that

I

> > can not edit the data values in only some forms! All TIB_Querys are set

to

> >
> > requestLive=true
> >
> > and then TIB_DataSources to
> >
> > AutoEdit=true
> > AutoInsert=true
> >
> > I checked the TIB_DataSource.state and when the tables are opened they

are

> > in "dssBrowse" state
> >
> > When I try to force the "dssEdit" mode there is a message "Cannot edit
> > current row"
> >
> > What worries me is, that in some forms all is fine and in some not.....
> >
> > best regards - Ulrich
>
>
>
>
>

___________________________________________________________________________

> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>