Keith:
Victory...
The "F.ICC" argument was from an open statement...
Open 'INV.CLASS.CODE' to F.ICC else null
When the command was changed from
"SELECT F.ICC...
To
Execute "SELECT INV.CLASS.CODE..."
The pesky "SQL+" prompt went away.
Thanks very much indeed for the help. I appreciate it.
Regards,
--Bill
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson
[DATACOM]
Sent: Sunday, July 31, 2011 5:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] UniBasic SELECT
The problem may be in the use of program variables in the executed code.
Using Universe, if I have code:
VERB = 'SELECT VOC LIKE A...'
EXECUTE VERB
CRT @SELECTED
CLEARSELECT
I get the result
237 record(s) selected to SELECT list #0.
237
If I change the filename to something that doesn't exit, like VVOC
VERB = 'SELECT vVOC LIKE A...'
EXECUTE VERB
CRT @SELECTED
CLEARSELECT
I get the result
SQL+
Where I have to press <Return> to get past this and then get
UniVerse/SQL: syntax error. Unexpected verb. Token was "SELECT".
Scanned command was SELECT
-1
Is "F.ICC" the name of the file in VOC or only internal to the program?
Regards, Keith.
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
