set var vCount integer = null select count(*) into vCount from UnknownTable
will give you the number of rows if the table exists or an error message if it doesn't and the var will remain null. Regards, Alastair. From: Matthew Burke Sent: Tuesday, March 16, 2010 6:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - CHKTABLE? Hello everyone, Is there a command anyone is aware of similar to CHKFILE, CHKVAR, or CHKCUR that I can use to check if a table name already exists or not? If there is not a command available, does anyone have a method they could suggest to accomplish this? Thanks for any help with this. J Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 575-627-4415 Office 575-624-3389 E-Fax [email protected] 3000 N Main Roswell NM 88201 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.790 / Virus Database: 271.1.1/2750 - Release Date: 03/16/10 07:33:00
