I am trying to write a sql statement that shows the active files for a
client. I can not find the field in the list of tables to use. Can anyone
help? Thank you in advance.
Eddie Jones
770-953-1959 ext.2824
The greatest lesson in life is to know that even fools are right
sometimes.
- Sir
See the BACKUPS table.
You should find the answer to your question by querying the COLUMNS table
for information about the fields in the BACKUPS table:
select * from columns where tabname='BACKUPS'
or, more briefly,
select colname, remarks from columns where tabname='BACKUPS'
Regards,
