Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Creating Table Dynamically using CreateTable

Posted on 2003-03-20
Medium Priority
Last Modified: 2010-04-04
I have tried to create a table using the TTable.CreateTable procedure but it does not work. Everytime I try I can the error message this function is not supported.

Can you help
Question by:malaland

Expert Comment

ID: 8174440
Database? (ms sql sever, paradox, dbase.. ?)
Driver type? BDE, ODBC?
LVL 27

Accepted Solution

kretzschmar earned 500 total points
ID: 8175413
use a tquery and a sql-statement like

create table tablename (
   FieldName FieldType,
   NextFieldName OtherFieldType

about the correct syntax refere your database-manual,
because its database dependend

use then execSQL method
to create the table

meikl ;-)

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Integration Management Part 2
Loops Section Overview
Suggested Courses
Course of the Month15 days, 23 hours left to enroll

580 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