Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: Query Tool

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    8,376

    Default Query Tool

    A customer of mine uses a systems guy who prefers that no one use commercial database tools on any server, development, test or production. This put a severe limitation on all of the users in that we were limited to using dbExplor for any ad hoc reporting with the data. Not that dbExplor is limited, just that reporting data in SQL is much easier in most instances by using SQL tools. To get around this problem, SQLQueries was created and the customer has kindly provided permission to pass this along to the DataFlex community.

    What does it do? Only SQL queries. You cannot do inserts, updates, deletes or alter the database itself in any way. Often used queries can be saved and reused and query output can be exported.

    The original version was written strictly for the customer’s Postgres database. It has now been expanded to work with both the DAW and Mertech drivers. Several different databases can be used with it, MSSQL, ODBC, MySQL and the original Postgres. Others will be added as the need arises.

    This tool is available here on vdf-guidance.

    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  2. #2

    Default Re: Query Tool

    Added a link to Query Tool from DataFlex.wiki - Development Tools page.

  3. #3

    Default Re: Query Tool

    Absolutely fantastic tool Bob!

    Somehow I have a feeling that we are going to see more of this tool.

    --
    Wil
    Last edited by wila; 14-Sep-2020 at 07:46 AM. Reason: removed teaser, his tool is already great without that

  4. #4
    Join Date
    Feb 2009
    Location
    Boxtel, The Netherlands
    Posts
    1,007

    Default Re: Query Tool

    Thanks for making this available Bob!
    Kind regards,

    Hans van de Laar
    www.datascore.nl

    “You will only fail to learn if you do not learn from failing.” – Stella Adler

  5. #5
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    8,376

    Default Re: Query Tool

    We've got a new version of the Query tool available on vdf-guidance.

    Wil has graciously updated the SQL editor by replacing the cTextEdit object with the Scintilla editor. This makes a big difference in the look and feel because he's added syntax coloring and bracket matching, both very useful additions. He's also suggested (not promised ) that additional goodies with the editor might be forthcoming.

    In addition I've fixed a minor installation bug and modified the editor so that it directly shows any syntax or other errors coming from the back end instead of masking them with a meaningless DF error.

    Click image for larger version. 

Name:	scintilla.jpg 
Views:	61 
Size:	25.0 KB 
ID:	13958
    Last edited by Bob Worsley; 21-Sep-2020 at 02:23 PM. Reason: clarification
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  6. #6
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia, Down under
    Posts
    2,476

    Default Re: Query Tool

    Thanks Bob & Wil

    Nice work!
    A next killer feature would be: Export to DataFlex reports RDS code
    - A json of the query structure, and perhaps 50 rows for designing the report
    - A class for retrieving the data from SQL into the Runtime data source Variant[][]

    Obviously its an advanced feature, but it would be a great timesaver for developers themselves, but also for end-user created queries, to be quickly converted to a DF report.

    Cheers
    Marco
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    Adelaide, South Australia
    www.28it.com.au

  7. #7
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    10,066

    Default Re: Query Tool

    Now if I'd suggested that, Bob would reply "Thanks for volunteering to do it Garret!"

    Garret

    I ordered a chicken and an egg from Amazon.

    I'll let you know...

  8. #8
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    8,376

    Default Re: Query Tool

    you know me too well...
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  9. #9
    Join Date
    Feb 2009
    Posts
    1,938

    Default Re: Query Tool

    Hi Marco
    You may have forgotten but I gave out a utility out at DAPCON 2 years ago that does exactly that.

    Let me see if it can be merged or tidied up and put here for all

  10. #10
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia, Down under
    Posts
    2,476

    Default Re: Query Tool

    Hi Garret

    I realised I took a risk, with the suggestion. But at the moment I can’t do it while did not want to stop for making the suggestion.

    I was quietly hoping someone right now in the middle or creating a bunch of DR’s would have an immediate ROI and would pick up the idea.
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    Adelaide, South Australia
    www.28it.com.au

Posting Permissions

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