Checking to see if another program has your database open

[william humphrey]

Thanks for your prompt answer JB.

I searched the database of old strings and I cannot find any answer for how
to check if the database is being used by another program. The only answers
I found were:


1. Don't do that ):  -- figured that one out myself as it results in instant
crash on Mac OS. I believe that on windows other bad things happen.


2. Use excellent multi-user server version of Valentina.


Both of those are excellent answers but I'm still looking for a way to check
if the database is open by another program from within RunRev. There must be
a way to do this.


PS - When I post to the RunRev mailing list I get a German reply that says
something about my post not being accepted.

On 9/12/08, -= JB =- <sundown at pacifier.com> wrote:
>
>
> On Sep 12, 2008, at 7:47 AM, william humphrey wrote:
>
>  Someone gave me this excellent check routine to see if a Valentina
>> database
>> is open in RunRev:
>>
>> *
>> *
>>
>> *function* CheckDatabase
>>
>>   *put* Valentina_CacheSize() into var
>>
>>   *if* var<1 *then*
>>
>>     *put* false into tOpen
>>
>>   *else*
>>
>>      *put* true into tOpen
>>
>>   *end* *if*
>>
>>   *return* tOpen
>>
>> *end* CheckDatabase
>>
>>
>> But how do I check to see if Valentina Studio (or another program) has the
>> database open? When running the database client side if Valentina Studio
>> has
>> it open and then you try to open it with RunRev you get an instant
>> catastrophic crash so I need a routine to check in RunRev first to see if
>> another program has like valentina studio has the same database open
>> before
>> I open it with RunRev. The above routine does not work for that.
>>
>>
>> Can anyone please suggest something?  By the way I reported this in Mantis
>> for Valentina but I've given up reporting bugs in Bugzilla at least until
>> there is an easier way to do it (similar to Mantis or RevZilla -- I
>> haven't
>> checked has RevZilla been updated to work with the new system?)
>> _______________________________________________
>>
>
> Hi William,
>
> On January 16, 2008 I asked a question about how to determine if a database
> is open.  The question is listed below.  There were answers and question
> that
> I asked about the answers.  Look at the thread carefully.  I believe it
> includes
> the answer but after that I focused on other parts of Valentina so I still
> need to
> do to.
>
> It would be nice if they included a function with Valentina to give a
> simple true
> or false if a database is open instead of looking at the list.  I don't
> think they
> understand how important this would be for Rev users so they probably will
> not make the function.
>
> -=>JB<=-
>
>
>
> --------------------------------------------------------------------------------
>
> I am trying to check if a database is open or not.
>
> I use the following:
>
> on mouseUp
>  answer file "Select DB:"
>  put it into dbPath
>  if dbPath is empty then exit mouseUp
>  put VDataBase_IsOpen(dbPath) into var
>  put var
> end mouseUp
>
> I have checked and dbPath contains the proper
> path for the database I select.
>
> If the database is open this should put True into
> the message box but all it does is show an empty
> message box.
>
> Anyone know what I am doing wrong or how to
> check for the open status of a database?
>
> thanks,
> -=>JB<=-
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.bluewatermaritime.com