Join causes -61 Error

[Ruslan Zasukhin]

on 6/20/03 16:10, davidhart_home at hotmail.com at davidhart_home at hotmail.com
wrote:

> Name:      David Hart
> 
> Question regarding: v4md
> 
> I am on OS X 10.2
> 
> I am getting error -61 when I try to run this query a second time within the
> same call:

    -61   wrPermErr  Write permissions error; Not a publisher
    
It looks like your database is already opened by you try to open it second
time.

> Select ChildItemID, Name From ItemHierarchy A, Item B Where ParentItemID = 2
> AND A.ChildItemID = B.ItemID
> 
> Please note that the first call to this query gets no error.
> 
> The value of the cursor is -2147483645 when it errors.
> 
> If I take the table join out and only query a single table, I can run the
> query as many times as I want.  Is this a problem with joining tables in
> valentina?   Please let me know if you can help.

I think Error happens on join because OS X allow you open db second time,
but only as read-only. On join Valentina need to write on disk.

So you need search if you open db second time.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------