Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NotAllThere

    Automate Export Table Specifications

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

    Automate Export Table Specifications

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

    changing table password

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

    Dynamic Lists

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

    Error when importing file

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

    Sorting a keyed table

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

    Eliminating duplicates based on blank field

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

    Delayed network updates

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

    Moving to top of tableframe after edit

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

    Secondary Index Size

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

    ObjectPal Create (a table) command

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

    printing in pdox10 from a button

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

    Modifying Passwords with a script

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

    Sloooowwwww find

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

    Pdox 9 - sendkeys

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

    alias directory

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

    Indexs corrupted daily after moving from Novell to Win2K Server

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

    Report becomes blank

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

    To Footpad:

    *.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...
  20. NotAllThere

    Reset an autoincrement value

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

Part and Inventory Search

Back
Top