🚀 go-pugleaf

> is it possible to make table name a variable in a s.proc like below ?
>
> SELECT * FROM : MYTABLE
> WHERE ODATE>=(SELECT MAX(ODATE) FROM : MYTABLE) -15

This would be cool and possible wish list for the future but at the moment i
do not think it can be done.

> if it is not possible how can i select just last 25 records in a table ?

Use an order desc clause and keep a counter.  Suspend only when the counter
is <= 25


joseph



"Serra" <nomail@nomail.com> wrote in message
news:46b81945$1@newsgroups.borland.com...
> IB 6,02
>
> I have 8 tables and i open them with same syntax
> all tables have same date field ( ODATE )
> i dont want to create 8 different s.proc.
> is it possible to make table name a variable in a s.proc like below ?
>
> SELECT * FROM : MYTABLE
> WHERE ODATE>=(SELECT MAX(ODATE) FROM : MYTABLE) -15
>
> if it is not possible how can i select just last 25 records in a table ?
>
> Thank you.
>
>