If I use the RequestLive, Everything seems to work fine. I was under the
impression that you shouldnt use RequestLive to be true client server
compliant, so Ive been trying to write the app to work with
RequestLive:=False. Maybe this is part of my trouble? I just noticed that
the contact manager demo has RequestLive set to true..

Gordon Hamm

----- Original Message -----
From: "Lucas Franzen" <luc@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 18, 2001 6:05 PM
Subject: Re: [IBO] Params


>
>
> Gordon,
>
> Gordon Hamm schrieb:
> >
> > Ok, so maybe Im dealing with this in the wrong way..Im using ONE
TIBOQuery
> > component to do my View (using my SQL property)
> > Then use the Edit method with the EditSQL, then Delete method with
DeleteSQL
> > etc. All using the same instance of TIOBQuery..
> > This is also the instance that my data aware components are looking to.
> >
> > Should I be using two different instances , one for the data aware, and
> > another for Add, Edit Delete using the SQL propery to do ALL of these
> > actions?
>
>
> No.
>
> 1. if you just to make a "plain" query (just select .. from ONE Table)
> insertable/updatable then you don't need these properties!
> It's enough to set the RequestLive property to TRUE (as with TQueries)
> You can also achieve this by adding FOR UPDATE to your SQL-statement
> (SELECT * FROM CUSTOMER [WHERE ... ] FOR UPDATE)
>
> 2. If you want to make a join :
> SELECT *
> FROM CUSTOMER C
> LEFT JOIN ADRESS A ON C.ADRESS_ID = A.ADRESS_ID
> FOR UPDATE
> updatable (on the customer side) then open the QueryEditor (Click the
> property SQLEditor).
>
> Go to the SQL-UpdateSQL page and click on the GENERATE FOR TABLE button.
> Select CUSTOMER then by double-clicking it.
> he table now by selecting and double clicking it.
>
> When doing so there will be entered automatically:
>
> in EditSQL:
> UPDATE CUSTOMER SET
> CUST_ID = :CUST_ID,
> ...
>
> in InsertSQL:
> INSERT INTO CUSTOMER(
> CUST_ID,
> ...
> )
> VALUES (
> :CUST_ID,
> ...
> );
>
> in DeleteSQL:
> DELETE FROM CUSTOMER
> WHERE
> CUST_ID = :OLD_CUST_ID
>
> By doing so all your data aware controls that will be part of the
> insert/update statement will be editable now (if you'd omit the CUST_ID
> in the EditSQL for example you copuld enter a value in the appropriate
> control when INSERTING a new record but NOT when editing it).
>
> I could carry on like this for hours, but once again: look at the
> GettingStarted Guide AND the samples to see how powerfuzl IBO is.
>
> IBO can't be explained by a shiny helpfile, IBO hast to be
> experienced...
>
> Regards
> Luc.
>
>
> >
> > Gordon Hamm
> >
> > ----- Original Message -----
> > From: "Jason Wharton" <jwharton@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, July 18, 2001 4:55 PM
> > Subject: Re: [IBO] Params
> >
> > > You only have access to the params in your editsql at the time the
record
> > is
> > > posting. Then, it only looks at the fields of the dataset being posted
to
> > > get its values. It would be an interesting feature to have it also try
and
> > > get a value from an input parameter.
> > >
> > > Jason Wharton
> > > CPS - Mesa AZ
> > > http://www.ibobjects.com
> > >
> > >
> > > ----- Original Message -----
> > > From: "Gordon Hamm" <vds@...>
> > > To: <IBObjects@yahoogroups.com>
> > > Sent: Wednesday, July 18, 2001 2:50 PM
> > > Subject: [IBO] Params
> > >
> > >
> > > > Hi,
> > > > I am inserting several parms into the params list on a TIBOuery
> > component.
> > > >
> > > > Then, putting some SQL code into my EDITSQL.
> > > >
> > > > Then when doing an edit, I am calling the
> > > > parambyname('myparameter').asstring := Newvalue
> > > >
> > > > It returns an error saying that my parameter doesnt exist. In
looking at
> > > the
> > > > object inspector, its clearly there. Am I missing something basic?
> > > >
> > > > Gordon
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>