How do i make a query being executed via one click

Posted on 2009-04-27
Last Modified: 2013-12-12
I have a single db paradox file and i want to execute some querys every midnight..
I don't have any much knowledge about delphi or c++.
SQL is not installed on the system (and i rather keep it that way ) as the only purpose of the DB file is to keep some records (like address, mail,phone etc)..

I managed to make and apply my querys with  TUTI - Table Utilities

However i need to implement the code to a single exe or bat or anything that will import or export data with a single click since i have to deal with some ancient people.
*Examples of querys i need to apply







SET Address='Athinas 67', City='Athens'



Open in new window

Question by:Freeboss
    LVL 17

    Assisted Solution

    Make the click (assuming this is a click on a link, otherwise, never mind!) take you to the page, or keep you on the same page like this:

    <a href ="">Click here</a>

    then on the page you send them to, say:

    if ($_GET['whatever'] == "update")
          do some query here;

    Author Comment

    SO you say i need to connect the db file to a php server and apply the query with some html/php code..

    I gonna do some search and try some things however i remind u that the only purpose of the db file is to being accessed via a simple program who imports and exports some fields..

    It would be much simpler if i could add the query into some kind of code(ex.delphi)..

    Anyway i will try the php thing and come and post later...
    ANy further help or ideas would be much appreciated.
    Thank you
    LVL 17

    Expert Comment

    What I mean is that you always need a connection string when you query a database, maybe you already know that. I have learned that on this website, you can't make any assumptions about what the person asking the questions knows. Sometimes they are very knowledgeable (in fact know more than I do!) and sometimes don't know anything.
    LVL 19

    Expert Comment


    SET Address='Athinas 67', City='Athens'

    Open in new window

    LVL 19

    Accepted Solution

    Better yet you may be able to import from paradox to mySQL using a program. Then you could create cron job to run php code for the queries.

    The select SQL does nothing but select data.

    These are the only two queries you are running?

    Otherwise, RECLASSIFY the zone of this question do get better results.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now