connect to MS SQL Server via ODBC

mfstuart mfstuart at cox.net
Thu Oct 4 11:45:24 EDT 2007


Hi Robert,
Typically when requesting 'user' table information from MS SQL Server, you
want define the SELECT statement as:
SELECT * FROM sysobjects WHERE (xtype = 'U')
Look at the 'syscolumns' table for the column names and their "properties" -
length, type, etc.
Mark Stuart



Robert Eppich wrote:
> 
> 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: http://www.nabble.com/connect-to-MS-SQL-Server-via-ODBC-tf4564371.html#a13042798
Sent from the Revolution - User mailing list archive at Nabble.com.




More information about the use-livecode mailing list