Now I really show my inexperience with R:Base... When I replace the Build commands with Create (Below) I get: -ERROR- Duplicate indexes are not allowed
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 CREATE INDEX site1 ON prod1a (compsite) CREATE INDEX site2 ON tempwrk (compsite) UNION prod1a WITH tempwrk FORMING ckprod Dayle Coxen Florida DOT -----Original Message----- From: Coxen, Dayle Sent: Wednesday, December 08, 2010 3:30 PM To: '[email protected]' Subject: 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
