Search:

Type: Posts; User: Jim Mulenos

Page 1 of 14 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    332

    Re: 1 workspace w/2 sets of INT files

    Exactly, PITA. We’ve been solving that with separate classes of SQL code and using a global property to call the appropriate methods. With that I believe that pointing to separate folders of INT...
  2. Replies
    4
    Views
    332

    1 workspace w/2 sets of INT files

    Currently on Vdf 19 using native drivers and Pervasive 11.3 in back.
    Moving soon to Vdf 19 using Mertech drivers and MySQL in back.
    Too much work keeping multiple workspaces parallel as we test...
  3. Replies
    21
    Views
    744

    Re: Best way in DF to Zip files?

    7-Zip has worked perfectly with BTR files for years for us - about 10 Gig every night
  4. Replies
    29
    Views
    3,246

    Re: MS Word Automation.

    We have been using the VDF (now ver 19) with the MS Word COM object, and Word 2007 for years to produce (literally) thousands of pages of legal documents per day, all from an unattended vdf-based...
  5. Replies
    18
    Views
    919

    Re: Error 12289

    The OLD W3ODBCCI.DLL PERVASIVE ODBC INTERFACE was 11.30.51.00 dated 1/8/2013
    The current W3ODBCCI.DLL PERVASIVE ODBC INTERFACE is 11.31.70.00 dated 5/27/2016

    The program is INSERTING records from...
  6. Replies
    18
    Views
    919

    Re: Error 12289

    I just spent a few days dealing with ODBC drivers and Error 12289 and here's what I found out that may help others with this. In this case we are INSERTing records from about 2000 separate Pervasive...
  7. Re: Use SQL to copy records to non-identical database

    Thanks for your assistance. Here's some code that may help the next developer that wants to do this. Doing this relational has turned a 10+ hour (formerly transactional) process into about 90...
  8. Re: Use SQL to copy records to non-identical database

    Michael & Martin, I agree this is the solution, thank you. I was looking for some way (like LOOPing with FIELDINDEX) to not have to hard code (up to 148) selected field names.
  9. Use SQL to copy records to non-identical database

    PervasiveSQL 11.3 and VDF19

    OLD.BTR has 120 fields
    NEW.BTR is exact same filedef as OLD except there is a pre-pended new field 1 totaling 121 fields
    Task is to copy all records from OLD to NEW,...
  10. Replies
    3
    Views
    238

    Re: Sqlstmtattrib_rowcount

    Dang it, did I just find the answer?

    Send SQLExecDirect of hStatement ("select COUNT(*) from " + sFile + " where MASTER_CLIENT=" + (String(piMasterClient(Self))) )
    Get SQLFetch of...
  11. Replies
    3
    Views
    238

    Sqlstmtattrib_rowcount

    I've read a lot of related forum posts, and, with VDF19 and Pervasive 11.3 the iClientRecordCount in the following code still comes back as -1

    Send SQLExecDirect of hStatement ("select count(*)...
  12. Re: FIND LT: DAW Pervasive vs Mertech MySQL driver

    Thanks all. I'm not hearing consistency and I'm still looking for the deeper understanding: On a simple numeric 1-segment unique numeric index...... after [F5] clear with the focus on the indexed...
  13. FIND LT: DAW Pervasive vs Mertech MySQL driver

    We've been working with the great people at Mertech for a few months in a desire to move a VDF19 application back-end from Pervasive to MySQL using the Mertech MySQL driver. The conversion works...
  14. DF_FILE_RECORD_LENGTH returning incorrect value

    We have a Pervasive 11.3 BTR file that clearly shows on the Parameters tab that both the RECORD LENGTH and RecLen Used is 2960. The DEF file newly created agrees. However Get_Attribute...
  15. Replies
    18
    Views
    1,015

    Re: Does the file exist?

    So there's LOTS of ways to check if a file exists. I'm curious: What's the BEST way?
    Most efficient...
    Fastest...
    Least resource usage....
    etc...
  16. Replies
    1
    Views
    271

    Vertical ScrollBar object

    When I browse the object tree of a LIST object (I know, obsolete!) I do not see the VERTICAL SCROLLBAR listed as an object. When I trace clicking on this it appears to to list as get_object_id...
  17. Replies
    15
    Views
    877

    Re: Pervasive Standard Compression

    Stephen and Sam, I also totally agree..... that rebuilding files will always decrease physical file size. My suggestion is that when designating Pervasive file format in DBB that the Compression...
  18. Replies
    15
    Views
    877

    Re: Pervasive Standard Compression

    Thanks for the great discussion. I want to qualify that all files are being created with DBB and all (20M) records are written through VDF.

    That said, take a look at the attached two files...
  19. Replies
    15
    Views
    877

    Re: Pervasive Standard Compression

    Thanks Sam, I agree with most everything you have said about setting Pervasive compression at the engine level, except that it's binary. Pervasive Rebuild has TWO compression options - Page & Record...
  20. Replies
    15
    Views
    877

    Re: Pervasive Standard Compression

    Stephen, in Pervasive Rebuild we are setting Page Compression ON and leaving Record Compression at the default KEEP EXISTING. I agree with the possibility that creating the file in DBB with Standard...
  21. Replies
    15
    Views
    877

    Pervasive Standard Compression

    When we create a new file with VDF 19 and Pervasive 11.3 using Standard Compression and dump 20M records into it it ends up at about 3GB. If we use Pervasive REBUILD setting Page Compression ON,...
  22. Replies
    7
    Views
    476

    Re: Checking directory exists

    //--------------------------------------------------
    // this function checks existence of a folder (tries upto 3 times)
    //--------------------------------------------------
    Function CheckDirExists...
  23. Re: Better way to count records in a constrained DD

    Here's the answer, at least with Pervasive, and it's fast enough:

    Send SQLExecDirect of hStatement "select COUNT(*) from vRWS where MASTER_CLIENT='3462'"
    Get SQLFetch of hStatement to...
  24. Re: Better way to count records in a constrained DD

    Great info, thanks. I'm curious.... if this RowCount property of this cDbCjGrid class truly returns the qty of records in the entire DD and not just those fetched, why would this DD-based capability...
  25. Re: File Access Violation - Observations will be greatly appreciated.

    We had some VERY similar issues with the early Windows 10 version 1803. There are some threads in this forum that will help. It had/has to do with some bad choice MS made with Windows Defender. ...
Results 1 to 25 of 339
Page 1 of 14 1 2 3 4