Subject | TIBOTable.SQL |
---|---|
Author | rod@myiafrica.com |
Post date | 2001-10-11T11:06:19Z |
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.
Is this true, or is there someting I must set ?
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.
Is this true, or is there someting I must set ?