Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Driver for IBI FOCUS

Driver for IBI FOCUS

Driver for IBI FOCUS

I was given the task to select information from a FOCUS database but do not have the FOCUS program.  Is there a driver that allows one to use SQL statements to read the data?  The company no longer has the FOCUS program but apparently created a backup of the FOCUS databases and Masters before they changed systems.

RE: Driver for IBI FOCUS

I think you are SOL. Focus is not an SQL based application, and there is no third party product that I know of which reads Focus databases. Too bad your company dropped it. It is a very powerful language.

RE: Driver for IBI FOCUS

That's incredible - someone would be so stupid to back something up in a format they can't read.

Focus is stored in a relatively simple page format (try 4 or 8k page size). The first page (or perhaps the first half) is catalogue information and the heads of the data lists. Then each page (as I remember) will be all of one entity type. The data is just held as a sequence of data in your native OS format, with addresses and pointers to the next item in the list. If you look at file with a hex editor you should be able to see the pattern. The master is just a text file so that will give you the pattern the data will be in - as I said, assume each page (after the first) has only one entity type on it. You'll need to work out which data field marks a record as deleted, although if the data was re-orged prior to being backed-up, there will be no deleted items. Then you need a bit of simple programming to pull the data out into external format. Stick it into Access and you're away.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close