Table repair with ObjectPal code

[Mojster]

I know how to Table repair with menus, but I want to know how to Table repair with ObjectPal code!

 

[footpad]

Mojster,

It can be done, but it's not documented very well. What little documentation there is can be found on Corel's FTP site. After connecting to it, go to /pub/Paradox/PdoxWun/unindexed and then download tu5api.zip, which contains a .DOC file and and .RTF that contains some sample ObjectPAL code for rebuilding Paradox tables.

The information itself was based on the Paradox 5.0 version of TUTILITY, but I expect you could get it to work using a more recent version with minimal effort.

Alternatively, you can also take a look at ChimneySweep (see

http://www.sundialservices.com/products/index.htm).

They have a 30-day trial version available online for $36.00, so you can give it a spin before commiting to the full product.

Hope this helps...

-- Lance

 

[ros]

I don't use this myself but, if you feel like playing around with it the form tutil32.fdl is what the menu calls.
So to rebuild the answer.db with minimal user interface:

var
f form
endvar
f.open("c:\\program files\\borland\\paradox\\tutil32.fdl", winstylehidden)
f.fldTable = "riv:answer.db"
f.btnBrowse.moveto() ;to make rebuild button visible
f.btnrebuild.pushbutton()
f.close()

The user messages of the form are stored in tables in the riv: directory beginning with "__tu" and the user only sees "table rebuilt" message.

Warning: I just successfully tried this but I think it might be quite dangerous if you had a really screwed up table and an inexperienced user.
HTH,
Richie
ps. to get the object names from the delivered rebuild form, use:
f.enumobjectnames(arObjects)
arObjects.view()

 

[JoeNg]

Download REBLD32 from

http://www.swebug.se/sig/sig_par/index.htm

The site is in Swedish.

Be careful with this tool. Make sure you understand the codes.