I.T. Discussion Community!
-Collapse +Expand
Delphi
Search Delphi Group:

Advanced
-Collapse +Expand Delphi To/From
To/FromCODEGuides
-Collapse +Expand Delphi Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► KBProgrammingDelphi for W...Using Data   Print This     
  From the November 2011 Issue of Prestwood eMag
 
Delphi Using Data:
Valid SQL Insert Query for the Database Desktop
 
Posted 17 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.

KB100029



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.


    Comments

    0 Comments.
    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 = P1204A1
    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 play-drums.com 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
    8681
    Since 4/2/2008
  • -
       Contact Us!
     
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    2,050 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...


    ©1995-2019 PrestwoodBoards  [Security & Privacy]
    Professional IT Services: Coding | Websites | Computer Tech