Charles,
Could be a data type problem with a leftover %1 variable.
Try 3 things:
1) surround X:\rbase\waterapp\water with your quotation character
2) in your new.app file, before the reference to %1, define the datatype,
and test for null:
SET VAR %1 TEXT
set v vdatab text = .%1
IF vdatab is null or vdatab = ' ' then
-- deal with the error
ENDIF
3) use the & macro-substitution form of the variable in your CONN
command. In general, do this any time that you want to put a variable
value into a command where a dotted variable is not normally
expected. (Look at the syntax diagram to see whether a dotted variable
would normally fall at that place.)
CONNECT &vdatab
Bill
On Tue, 19 Jun 2001 17:25:40 -0500, [EMAIL PROTECTED] wrote:
>Running RBW6.5++ on NT 4.0 wkstation. Database is on NT 4.0
server.
>
>Executing water.dat with following code:
>-----------------------------------------
>set scratch c:\ben
>run NEW.APP usi X:\rbase\waterapp\water
>exit
>
>NEW.APP contains the following lines:
>-------------------------------------
> set v vdatab text = .%1
> CONNECT .vdatab
>
>This results in the message "Unable to connect to database".
>
>However, if I type "CON .vdatab" at the R:>, it connects!
>
>I initially thought it was a permissions issue until I tried the "CON
>.vdatab" at the R:> and it worked...
>
>Thanks!
>
>Charley
>
>Charles Sikora
>Senior Gas Supply Specialist
>Manlove Field
>Peoples Energy Corporation
>
>----------------------------------------------------------------
>The information transmitted is intended only for the person
>or entity to which it is addressed and may contain confidential
>and/or privileged material. Any review, retransmission,
>dissemination or other use of, or taking of any action in reliance
>upon, this information by persons or entities other than the
>intended recipient is prohibited. If you received this in error,
>please contact the sender and delete the material from any computer.
>