--- In IBObjects@y..., Helen Borrie <helebor@d...> wrote:
> At 11:06 AM 11-10-01 +0000, you wrote:
> >I have the simple query(s)
> >
> >update salenum
> >set customernum = 1 + (select customernum
> > from salenum);
> >select customernum
> >from salenum
> >
> >This work 100% in the interbase interactive sql.
> >It does not work in TIBOTable.SQL. I assume this is because I cant
> >have 2 SQL statements per tIBOTable.
>
> You can't have any SQL statements in a TIBOTable. It does not
surface a SQL property. This component is like the native VCL TTable -
it is a SELECT * FROM ATABLE and selects all columns, all rows from
the table assigned to its Tablename property.
>
> >update salenum
> >set customernum = 1 + (select customernum
> > from salenum);
>
> This is (a) not a valid SQL statement and (b) it is not a SELECT
statement. What exactly do you want to do here?
>
> >select customernum
> >from salenum
>
> This is a select statement that, in a TIBOQuery, would return a
dataset consisting of all of the customernum values in the table
salenum. It has no applicability to a TIBOTable, though.
>
> Can you explain what you are trying to do?
>
> regards,
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________