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
_______________________________________________________