I'm trying to extract just the structure of a table from SQL server in the form of an empty table, but when I an SQL query like "Select * from Cities where 1 = 2" I don't get an empty table like I would in MapInfo; I get nothing at all.
Then I tried "exec sp_help 'Cities'" but that produces two tables and MapBasic's Server Link statement chokes on that. I'm hoping there's an easier way than stepping through sysobjects and syscolumns. -- - Bill Thoen ------------------------------------------------------------ GISnet, 1401 Walnut St., Suite C, Boulder, CO 80302 tel: 303-786-9961, fax: 303-443-4856 mailto:[EMAIL PROTECTED], http://www.gisnet.com/ ------------------------------------------------------------ _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
