Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Creating a Table from a Query Result Set?

Posted on 1998-12-12
1
171 Views
Last Modified: 2010-04-04
I would like to automatically Create a table from a Delphi Query (to produce the same result that Paradox queryvar.executeQBE("NewTableName.db") produces).
Can you help?
0
Comment
Question by:rickofkirkwood
1 Comment
 
LVL 4

Accepted Solution

by:
dwwang earned 50 total points
ID: 1350796
Since Delphi's LocalSQL does not support Select ... Into statements, you can use BatchMove:

Put a TBatchMove and a Ttable component on the form with the query, then set:

     BatchMove1.Source:=Query1;
     BatchMove1.Destination:=Table1;
     BatchMove1.Mode:=batCopy;
     Table1.TableName:='NewTable.DB';
     query1.sql.text:='Select * from employee where ...';
     query1.Open;
     BatchMove1.Execute;

Hopefully this is a easy way :)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle global variables 4 76
Error E2158 compiling with Delphi XE10 Seattle 2 112
tvirtualstringtree freeze when load too manny images 10 71
RESTRequest Parameter 4 42
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

860 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