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 to share photos of your group with the world? 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 #144597 of 148710 |
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




Thu Jul 16, 2009 3:36 am

jccapellan
Offline Offline
Send Email Send Email

Forward
Message #144597 of 148710 |
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