SELECT COUNT(*) INTO vtest FROM SYS_TABLES WHERE SYS_TABLE_NAME = .vtablename
Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Matthew Burke Sent: Tuesday, March 16, 2010 14:54 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
