Your full service technology partner! 
-Collapse +Expand
Search Delphi Group:

-Collapse +Expand Delphi To/From
-Collapse +Expand Delphi Store

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► KBProgrammingDelphi for W...Using Data   Print This     
Next Random Article Next Random Tidbit || Change Topic Random From All
  From the November 2011 Issue of Prestwood eMag
Delphi Using Data:
Valid SQL Insert Query for the Database Desktop
Posted 18 years ago on 10/9/2002 and updated 3/18/2003
Take Away: The Database Desktop IS Paradox. It's just a stripped down version. The SQL editor in the Database Desktop (and in Paradox) allows you to execute one SQL statement at a time.


The SQL editor in the Database Desktop (and Paradox), does not allow executing of multiple SQL statements. Also, when executing against local Paradox, dBASE, etc. tables, the Local SQL engine is used which is limited.

Here's an example of a valid insert statement:

INSERT INTO ":dbdemos:employee.db" (EmpNo, LastName, FirstName) 
VALUES (1, "Prestwood", "Mike");

A few options:

  • You can open the table and edit the data directly.
  • You can try adding the records using the Tools | Utilities | Add menu option.
  • You can do a QBE Insert query. Look in the help file for more information on executing an QBE insert query.

    Just for background: The Database Desktop IS Paradox. It's just a stripped down version. It's kind of a weird combination of the runtime and full version of Paradox. It allows you to open and edit tables, QBEs, and SQL statements, but not forms, reports, etc. Most of the menu options have been removed, but it does have the Utilities menu.


    Share a thought or comment...
    Write a Comment...
    Sign in...

    If you are a member, Sign In. Or, you can Create a Free account now.

    Anonymous Post (text-only, no HTML):

    Enter your name and security key.

    Your Name:
    Security key = P1304A1
    Enter key:
    KB Post Contributed By Mike Prestwood:

    Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

    Visit Profile

     KB Article #100029 Counter
    Since 4/2/2008
  • Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

    ©1995-2020 Prestwood IT Solutions.   [Security & Privacy]