1/ You cannot create temporary tables in Oracle. This can be quite a
shock to someone moving from, say, Sybase. However, most times, a little
more analysis work can replace a temporary table with a proberly built
select statement.
2/ You may perform all the auditing you wish using triggers.
3/ This seems easy enough. Just mainipulate the properties of the
DBEditFields/DBGrid columns. Or am I missing something???
4/ No. You must drop the sequence and recreate it. Or you can allow the
sequence to recycle so that when it reaches the maximum value, it wraps
around to the starting value again.
5/ If you are runnig 7.2 or higher, you have cursor variables which should
be able to do what I think you are trying to do here.
Tomm Carr
In giving freedom to the slave we assure freedom to the free,
honorable alike in what we give and what we preserve.
---- Abraham ByGod Lincoln
Received on Thu Jul 10 1997 - 00:00:00 CDT
