Search the web
Sign In
New User? Sign Up
magicu-l · uniPaaS (Magic) Software Users Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Knowing Database/Table Availability   Message List  
Reply | Forward Message #144598 of 148675 |
RE: [magicu-l] Knowing Database/Table Availability

Joel,



You could always issue a FileExist (IOExist in v9 or prior) and give it the
name of one of the Pervasive files. That way you can see if it's there
before opening it as a database table.

Note: this will only work if you have folder level access to the files and
in the newer versions of Pervasive, the network admin does not need to issue
this (but most still do)



Keith



From: magicu-l@yahoogroups.com [mailto:magicu-l@yahoogroups.com] On Behalf
Of jccapellan
Sent: Wednesday, July 15, 2009 11:36 PM
To: magicu-l@yahoogroups.com
Subject: [magicu-l] Knowing Database/Table Availability





Hello everyone!

First of all, I want to thank everyone for making this group alive and
helpful specially for those who have shared their experiences and knowledge
in this group.

I want to ask from the group tips or tricks where in my eDeveloper program
can determine that the table or the Btrieve database is not accessible or
can not be opened so than an alternative way can be chosen. I understand
that when table can not be opened, e.g. the server is offline, the Magic
engine issues a "Failed to open lock file, table: <table name>" message but
I was unable to create a program to trap it.

I've tried to use the eDeveloper handler using Error Event type and set
Event to Any, Locked Row, or Unmapped errors but it seems to have no use in
this case.

Is there someone in the group who have an idea?

Joel





[Non-text portions of this message have been removed]




Thu Jul 16, 2009 3:45 am

kbcanniff
Offline Offline
Send Email Send Email

Forward
Message #144598 of 148675 |
Expand Messages Author Sort by Date

Hello everyone! First of all, I want to thank everyone for making this group alive and helpful specially for those who have shared their experiences and...
jccapellan
Offline Send Email
Jul 16, 2009
3:36 am

Joel, You could always issue a FileExist (IOExist in v9 or prior) and give it the name of one of the Pervasive files. That way you can see if it's there before...
Keith Canniff
kbcanniff
Offline Send Email
Jul 16, 2009
3:46 am

I've done something similar, using a command like DBRecs(). Thisgives 0 if the file is empty, but it also throws an error if there is a problem with the file...
Heidi Schuppenhauer
heidis13
Offline Send Email
Jul 16, 2009
3:58 am

Ah yeah, thanks Keith. I guess, I just need the group to remind me of that function :)...
jccapellan
Offline Send Email
Jul 16, 2009
4:01 am

Joel, I can think of only one really sure-fire way to detect the availability of an MKDE running on a specific computer, and that would be to use Call/Invoke...
Steven G. Blank
blanstev
Offline Send Email
Jul 16, 2009
1:22 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help