Hello All,
I am trying to get a list of the table names from an SQL Server. By
using the following script:
put RevDataFromQuery("","",line 1 of fld 1,"select name from
sys.tables")
These tablenames are returned.
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values
However, this is not what I expected to see. It seems as though the
tables are one level deeper in "dbo" and then "Tables", at least this
is how Crystal Reports displays it.
I'm looking for a specific table called "Labor_Ticket". I have used
the "Database Query Builder" tool in Rev and the tables listed are
the same. How do I get another level deeper to the actual tables I'm
looking for.
Thanks for any ideas.
Rob
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution