Recent content by NotAllThere

I'm still not clear as to what you are trying to achieve. I understand that you are able to use exportAsciiFixed to export a Paradox table. I understand that the exportAsciiFixed method requires a spec table to describe the structure of the export data. What I thought you were asking for was...

You can use exportSpreadsheet to export the specification table to a spreadsheet, or exportAsciiVar to export it to a text document.

If you need to implement good security for Paradox tables then have a look at Px3P - practically uncrackable, if a little dated. It allows the use of indices, etc as normal, but if the Px3p dll and the correct password are not present, cracking Paradox tables only yields encoded (garbled) record...

Binding fields in a tableframe 'on the fly' can be achieved easily enough, but to get the table frame looking right, it may be necessary to adjust field and table properties (column with, text alignment and format, etc) since these often reset on a bind. Overall, possibly a lot of code and...

Is this in ObjectPal? - if so please post the line of code doing the import. Also, can you import successfully interactively (i.e. through the menu)? There is a problem interactively importing .csv files in Paradox 8 but that gives a different error - renaming .csv file extension to .txt works...

You can't sort the table differently without removing keys, but you can view the table through a form with records ordered differently. Restructure table and create a secondary, maintained, index on the required sort field(s). This index can be composite on a number of fields if you need this...

Your requirement could be executed a lot slicker with OPal, but if you want a query then try process below. You may want to first try with a smaller selection of records to prove the result is what you want. 1. Backup your table. 2. Also make a copy of the table to TBL_COPY.DB in the same...

John, You don't say what version of Paradox you're using, but in P8, go to Tools-->Settings-->Preferences, Database tab (on the client). You can set the Refresh Rate and Retry Period from there. If I remember correctly, a refresh rate of 0 seconds means no refresh at all. Low refresh rates...

mtastad, You could home the tableframe. If the tableframe object for the temp table is called MYTEMPTABLE then after the endEdit or postRecord, simply add: MYTEMPTABLE.home(). (To get the tableframe object name, select the tableframe and read the name in the status line at the bottom of the...

JBirdieH, In addition to the advice Lance gives, try a reIndexAll on the table. Sample below is from V8 Help: ; reindexAllCust::pushButton method pushButton(var eventInfo Event) var tblVar Table pdoxTbl String endVar pdoxTbl = "Customer.db" tblVar.attach(pdoxTbl) if...

Lynn, To use Struct you must first generate a table that describes the table structure. You do this by first using enumFieldStruct(). Similar logic applies to indexStruct. Try this: method pushButton(var eventInfo Event) var NewTbl Table OldTbl Table endVar...

Jay, When V9 was many print problems were reported. These were addressed and V10 is considerably better. However, during the couse of the evolution, some of the default settings changed, and I'm guessing this may be part of your problem. What type is prnOptions (printerOptionInfo or...

Tables can be password protected and unprotected using the table methods: protect(const password String) unProtect(const password String) These methods set/remove master passwords. Auxiliary passwords may be added using the restructure() method with the setStruct parameter. See also...

Have you checked that the table (or table index) is not corrupt? Although not the best tool, check the table with the Table Repair Tool.

Sendkeys?.. should ..umm..in my opinion.. only be used as a last resort. One of the reasons is that it is difficult to guarantee that the 'keystrokes' always get sent to the required application. There may also be an issue re time delays. You can improve the success rate with small things...