connecting to a FoxPro database exlusively

[dendog]

hey all;
I have a two part question:

Part1:
When accessing a FoxPro database from a JSP that i wrote how do I express that I want the foxpro table files to be opened exlusively???

Part2:
The reason I am asking is because when i try to use the pack statement to physically remove deleted items in a table it throws an SQLException saying that the file must be opened exclusively. My second question is what would be the syntax to physically remove deleted records from a table named dowload_inv and a Statement named stmt using the pack command in a JSP.

Thank you very much for taking the time to answer my questions.

DENNIS

 

[topgunf25]

You must do an exclusive open to any Foxpro table to do a "Pack" command. I don't know what JSP is but, that is the rules in foxpro.

 

[DSummZZZ]

This article may help you out:

HOWTO: Pack a Table Through the Visual FoxPro ODBC Driver (VFPODBC.dll) (Q234756)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q234756

Dave S.