Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: DFQ.flx & PSQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Dallas, TX USA
    Posts
    1,533

    Default DFQ.flx & PSQL

    A long time client still running Character Mode uses DFQ all the time. Years ago when we converted them to PSQL, I believe the recommendation was not move query.dat to query.btr (convert it). query.dat has gotten corrupt indexes several times lately so I converted to PSQL, and query.dat converted fine. However, DFQ.flx doesn't appear to be using the converted data file but still using the .DAT file. can dfq.flx be setup to use query.btr?

    Thanks
    Mark

  2. #2
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia
    Posts
    2,863

    Default Re: DFQ.flx & PSQL

    Did come across a similar issue a couple of years back. Dfq. Does not look at connectivity tables.
    Their setup, was a DF program before and after calling dfq, that creates a .dat on startup (from the sql ‘master’) and copied changes back into the master after.
    The fact they went through so much trouble probably means there was no other way...
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    DataFlex Channel Partner for Australia and Pacific region
    Adelaide, South Australia
    www.28it.com.au

  3. #3
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: DFQ.flx & PSQL

    Mark,

    It has been a long time ago that I created DFQ (1996 or so) but since it is a true DataFlex application it should like DFRUNCON applications be able to access the foreign databases. I've certainly tested with MSSQL and Oracle, don't know for sure about Pervasive. Haven't tested it recently but if your environment can handle Pervasive.SQL tables DFQ should be able to do this too.

    As alternative; take a look at DataFlex Reports as DataFlex 3.x is not really a alive-and-kicking environment. Latest development is about 20 years back, from the time of Windows NT I think.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  4. #4
    Join Date
    Feb 2009
    Location
    Copenhagen, Denmark
    Posts
    2,006

    Default Re: DFQ.flx & PSQL

    Hi Vincent,

    Perhaps you open it "as"?

    -Sture

  5. #5
    Join Date
    Feb 2009
    Location
    Dallas, TX USA
    Posts
    1,533

    Default Re: DFQ.flx & PSQL

    Thanks Vincent. I've got the latest DFQ and running with DFRUNCON, but DFQ is not opening the QUERY.BTR file looking at the PSQL monitor. In addition, when saving a query, the QUERY.DAT file is getting updated and not the QUERY.BTR file. The conversion from .DAT to .BTR went fine and the .BTR file can be looked at with no issues using dbexplorer (or even dfbrowse for that matter). Very long standing client with everything still running in character mode, tried to talk them into converting, but he's 80 and very happy with what he has.

    Thanks
    Mark

  6. #6
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: DFQ.flx & PSQL

    Mark,

    Aha the reserved table name "Query" is what you try to open...

    This table is - as Sture suggested - opened via OPEN AS. That is done as the table does not appear in everyones/the filelist.

    Now.. is your query.btr the same as the query.dat but move to PSQL or did you happen to have a table name QUERY? If it is the same I can probably create a new DFQ.FLX that does a OPEN-AS via an .INT file. If it is different there is no way to go as DFQUERY as well as DFQ need to be able to store and read about kept queries.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  7. #7
    Join Date
    Feb 2009
    Location
    Dallas, TX USA
    Posts
    1,533

    Default Re: DFQ.flx & PSQL

    It's the same. Query is in the file list under file #48.
    Mark

  8. #8
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia
    Posts
    2,863

    Default DFQ.flx & PSQL

    Hi Vincent
    My customer would also be very happy if DFQ could open the query.int.
    Yes it is in the file list as query.int and yes it is the DFQ one, just converted to sql like all tables (simplify backup as only one of the reasons).
    Perhaps DFQ could check if query is in the file list, if it is, then open just via the file list, if not then continue the open as.
    That would be fantastic!!!
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    DataFlex Channel Partner for Australia and Pacific region
    Adelaide, South Australia
    www.28it.com.au

  9. #9
    Join Date
    Feb 2009
    Location
    Dallas, TX USA
    Posts
    1,533

    Default Re: DFQ.flx & PSQL

    I believe that would work well for us also Marco.
    Mark

  10. #10
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: DFQ.flx & PSQL

    Mark, Marco, Others,

    I've decided to take a look at the code that I hadn't touched for about 10 years and changed the way the open of the Query table works. You can download version 1.064 from https://www.dataaccess.eu using your Data Access ID.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •