Dayle, Use CREATE INDEX indexname ON tablename (columnname)
Jan -----Original Message----- From: "Coxen, Dayle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 8 Dec 2010 15:30:16 -0500 Subject: [RBASE-L] - BUILD Command Unsupported I am converting from 6.5++ to 7.6. During a trace of a 6.5 command file, I get the message: Break in file testdebug.app at line 379 for -ERROR- This command is currently unsupported. (1120) Line 379 is the "BUILD KEY FOR compsite IN prod1a" below. INSERT INTO prod1a SELECT * FROM tmp1 INSERT INTO prod1a SELECT * FROM tmp2 DELETE ROWS FROM prod1a WHERE compsite IS NULL DROP tempwrk PROJECT tempwrk FROM workneed USING site compsite county SECTION subsect BMP emp jobcode wp area bridge# finproj DROP ckprod BUILD KEY FOR compsite IN prod1a BUILD KEY FOR compsite IN tempwrk UNION prod1a WITH tempwrk FORMING ckprod Any suggestions how to best re-work this code replacing the BUILD command? Thanks in advance. Dayle Coxen Florida DOT
