Search results for query: *

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...

Is the new table to be part of the form's data model? If so, then open the form in design mode but use the "Change Table" button on the open dialog box. Select the new table from there before opening the form. Then save the design. Other than that, the only other change is...

In the interim, if only indices are being corrupted, use a reIndexAll() method to rebuild. Much faster than Table Repair. See ObjectPal Help for an example.

I don't have any suggestion as to what the problem may be. However, just in case the report is getting corrupted, why don't you mark it as read only at file system level - find the report in Windows Explorer, right click and tick the Read Only box. HTH PAdraig

*.lck and *.net files are used by Paradox to control locking of records in tables. Once nobody is using the Paradox/BDE application, it is safe to delete these files - Paradox will re-create the necessary files next time it is started. I use a small (home-brew) Delphi utility in the startup of...

I don't use auto-increment lots of reasons, but to answer your question, the only way I know is: 1. Copy your table (ORIG.DB) to say COPY.DB 2. Empty ORIG.DB (you did check that the copy worked!) 3. Restructure ORIG.DB and set the min value (e.g. 70) 4. Add COPY.DB to ORIG.DB NB: ALL the...