Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Brian and Gregor, Thanks SO much for your suggestions. I checked the VOC entries and found that the FROM entry was indeed missing in our development account. I added it back and was able to perform the command. I really appreciate everyone's help with this. Cheers! Eric :ELE VOC File name = VOC. Record name = FROM New record. : I 0001= K 0002= FROM 0003= : FI FROM filed in file VOC :COPY FROM APPROVALS RECORD1, RECORD2 1 records copied ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniQuery COPY FROM syntax error - Weird behavior
I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Actually, the statement I am using is copying a record with an old key to a new key in the same file (basically just changing the primary key keeping everything else identical). It is syntactically correct and works in other environments but the command interpreter is throwing an error in this one environment. Just tried the lower case copy and received the same error. Grrr... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users