What utility / subroutine exists to report on the driver version under which a particular table was created.

I want to migrate all our 2,x & 3.x tables onto 4.x - Do you guys at Rev have a magic utility to allow the migration on a table rebuild? vs the old PICK trick?

Cheers

]What utility / subroutine exists to report on the driver version under which a particular table was created.

]I want to migrate all our 2,x & 3.x tables onto 4.x - Do you guys at Rev have a magic utility to allow the migration on a table rebuild? vs the old PICK trick?

Martin,

The Universal Driver reads tables create with both the 2.1 Service and the 3.0 Service, so I am confused by your question.

However, if you wish to know what Service version was used when the table was created, you can do this with later versions of OI. Under Database Manager, work your way to LH Table Info. It has a field called "File Version". A number two means it is from the 2.1 Service, a number 3 means it is from the Universal Driver 3.0.

Hope it helps,

Kevin

G'day Martin,

If you are using OI V7.2.1 or higher then you could use the Get_LH_Info Function. See the Whats new in V7.2.1 for more info.

Dave G

Martin,

UD 4.0 is backward compatible to both NT Service 2.1 and UD 3.0 created files. No magic, just nothing to bother with, you don't need to rebuild any files.

One note. It helps to keep all of your data tables "under" the main OI program directory. If you do this you only need one "REVPARAM" file as the engine will look there first and anything under will be applicable. If you have data tables above the main directory the system will take longer as it will have to look for the "REVPARAM".

Example:

c:\revsoft ← Main installed OI progs, dlls, exes

c:\revsoft\datatables ← contains .lk and .ov files

c:\resoft\revparam

Is better than

c:\datatables ← contains .lk and .ov files

c:\datatables\revparam

c:\revsoft ← Main installed OI progs, dlls, exes

bc

View this thread on the Works forum...