Subject Re: [IBO] Set a TIB_Query into dssEdit mode
Author Jason Wharton
In IBO you can set RequestLive to true which tells IBO to figure out what
UPDATE statement to use automatically. If you want to take control of what
SQL statement is used to process an update then you plug it into the
UpdateSQL property. By doing so, it allows the dataset to go into edit
state.

If you haven't put in your own UpdateSQL property value with your UPDATE
statement or set RequestLive to true then your dataset will not allow you to
go into edit state. You will simply get an error.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --


"Ulrich Groffy" <ulrich.groffy@...> wrote in message
news:amgns3$bki$1@......
> 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