[Info-vax] Rdb question

[Arne Vajhøj]

On 7/22/2022 3:35 AM, Jan-Erik Söderholm wrote:
> Den 2022-07-22 kl. 01:29, skrev Arne Vajhøj:
>> I am not good at Rdb.
>>
>> CONNECT TO 'ATTACH FILENAME disk4:[rdb]test'
>>
>> should connect to that database.
>>
>> But it fails with alias already in use.
> 
> Yes, you probably already have an active attach
> which uses the "default connection", and since you
> did not specify a new "alias", it tried to use the
> same default connection.

Yes. I just doesn't know where that connection comes from.

>> CONNECT TO 'ATTACH ALIAS test FILENAME disk4:[rdb]test'
>>
>> works fine, but I have to prefix all table names with "test." and
>> I do not like that.
>>
>> What is the correct syntax for:
>>
>> CONNECT TO 'ATTACH JUSTOVERWRITETHEDEFAULTALIAS FILENAME disk4:[rdb]test'
> 
> If you want a new default connection you need to DISCONNECT the open one.

DISCONNECT did not help.

>  From where are you doing that? Rdb interactive SQL?

Program using SQL Services.

> Do you need multiple connections? If not, just use
> a default connection and only use ATTACH.

That works!

:-)

Arne