Hi,

I have found a problem when I do this :

I Have two Database :
- Database 1 : BIBLE_ESTIM
- Database 2 : AFFAIRE_ESSAI AJOUT 1_ESTIM

I do this first query in the database BIBLE_ESTIM   

UPDATE Per SET
Montant = (SELECT SUM(VALEUR) AS SomV FROM "AFFAIRE_ESSAI AJOUT 1_ESTIM".ListePerso
WHERE (CODE = 'A.') OR (CODE = 'B.') OR (CODE = 'C.'))
WHERE (Projet = 'ESSAI AJOUT 1')

This query is working good

Now, I want to execute this second query in the database AFFAIRE_ESSAI AJOUT 1_ESTIM

CREATE VIEW Vue1 AS SELECT CODE
FROM ListePerso
WHERE (CODE LIKE 'A.11%') AND (Etat = 'SF')

When I execute the query, I have this error message :

ElevateDB Error #300 Cannot lock the catalog AFFAIRE_ESSAI AJOUT 1_ESTIM in the database AFFAIRE_ESSAI AJOUT 1_ESTIM for write access


What's happened ? This problem doesn't exist with the version 2.03 of ElevateDB

Thanks for your help

Bruno

Bruno,

Please don't send us email and then post in the support forums also.

Per email:

What version/build are you seeing this problem in ?  There was a similar
problem already fixed already in 2.04 B2:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.04&incident=3302

--
Tim Young
Elevate Software
www.elevatesoft.com

I use the 2.04 B2

I see that a similar problem was fixed with the 2.04 B2, but it's not exactly the same problem. In that case, the problem appear when I want to udpate a table from a table in an other Database.

Greetings,

Bruno Riviere

Bruno,

<< I see that a similar problem was fixed with the 2.04 B2, but it's not
exactly the same problem. In that case, the problem appear when I want to
udpate a table from a table in an other Database. >>

I'll see what I can find out, but there isn't any issues with doing this
that I'm aware of - general statements (SELECT, INSERT, UPDATE, and DELETE)
handle multiple databases just fine.

--
Tim Young
Elevate Software
www.elevatesoft.com

Bruno,

Okay, I found the problem and it's fixed.   The problem was caused by the
changes to the UPDATE statement to accommodate row value constructors.

I probably won't be able to issue a new build for at least a week or so,
though.  I have to get some issues straightened out with our build/test
system first (due to the server hard drive crash).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Can you tell me when the new build is available ? I'm waiting for it.

Regards,

Bruno RIVIERE

Bruno,

<< Can you tell me when the new build is available ? I'm waiting for it. >>

I understand.  However, due to a recent hard drive crash, I'm having to
recreate a lot of the tests in our test framework for EDB, and I can't do
any new builds until that time.

As always, an email will be sent out when the new build is available.

--
Tim Young
Elevate Software
www.elevatesoft.com

Ok Tim, I understand

Have you an idea how long that will take your tests ? A week ? A month ?

Bruno

Bruno,

<< Have you an idea how long that will take your tests ? A week ? A month ?
>>

I'm recreating them as fast as I can.   I'm almost done with 2008's tests
right now, and that leaves about 100 more to go.  I'm estimating it will
take about one more week to finish the tests, and then I can do a new build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>I'm recreating them as fast as I can. I'm almost done with 2008's tests
>right now, and that leaves about 100 more to go. I'm estimating it will
>take about one more week to finish the tests, and then I can do a new build.

Isn't there a test for tests to build as well

Roy Lambert