You can use the TableInfo() Function eg:
Dim intRecordCount as integer Dim strSQL as String strSQL = "Select * from TblMyTable Where Column1 = 'Blah Blah' into MyTable" intRecordCount = Int(TableInfo(MyTable, TAB_INFO_NROWS) .... and Bob's Your Uncle. Cheers. Julius. -----Original Message----- From: Mark Williamson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:32 AM To: Mingala, Julius Cc: [EMAIL PROTECTED] Subject: Re: MI-L getting back the size of result set on a db query Hi Thanks for the reply Im using MapBasic and cant find anything on Server or Fetch instructions that will tell me the sixe of the result. Any ideas ?? Mark On Thu, 16 May 2002 10:25:08 -0500 "Mingala, Julius" <[EMAIL PROTECTED]> wrote: > Hello, > > What language are you using to query the remote database ? depending on the > language, I am sure that the resultsets recordcount can be evaluated > > Cheers. > > Julius. > > Julius L Ming'ala > > SMART - GIS > Phone: 314-577-7094 > Fax : 314-765-9484 > Email : [EMAIL PROTECTED] > -- Mark Williamson Heriot-Watt University [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
