How ever many counties there are in colorado that exist in your database ;)
Bill, for a good reference for SQL grab SQL in a Nutshell or any fo the beginning SQL books from O"reilly.. In fact I would love to see some MI guru(s) get togetehr and do a MI in a nutshell book. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Thoen Sent: Thursday, January 31, 2002 6:45 PM To: MapInfo-L Subject: MI-L Info on Server_Execute() results? If I use server_execute to make a SQL select, how do I find out how many records were retrieved? Is there a Server_TableInfo() function or something like it? Example: hdbc = Server_Connect ("ODBC", "fileDSN=Counties.dsn") hstmt = Server_Execute(hdbc, "select * from Counties where State = 'CO'") How many counties were retrieved? -- - 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. _______________________________________________________________________ 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.
