Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Borrow table structure

Status
Not open for further replies.
JoeNg

JoeNg

Programmer
Apr 17, 2001
174
US
Can I create a table by borrowing the table structure from another table?

Thanks

Joe
 
Sort by date Sort by votes
Try posting on a different forum: e.g.

Microsoft: SQL Server
or
ANSI SQL
 
Upvote 0 Downvote
Hi Joe

Just an example

Table1.Active:=true;
Table1.FieldDefs.Update;
Table1.IndexDefs.Update;

Table2.TableName:='Table.db';
Table2.DatabaseName:='c:\Folder';
Table2.FieldDefs.Assign(Table1.FieldDefs);
Table2.IndexDefs.Assign(Table1.IndexDefs);

Table2.CreateTable;
 
Upvote 0 Downvote
Hi, BTecho

I suspected it has to do with fieldDefs, just not sure the syntax.

Thank you!


Joe
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lenkost
  • Locked
  • Question
TImageContainer data structure
Replies
0
Views
62
lenkost
lenkost
MLNorton
  • Locked
  • Question
Create a Table of Dates
Replies
2
Views
68
imex
imex
Griffyn
  • Locked
  • Question
Help with table locking 1
Replies
6
Views
77
Griffyn
Griffyn
msgopala
  • Locked
  • Question
OnCalcfields event for virtual table
Replies
6
Views
143
msgopala
msgopala
pierrotsc
  • Locked
  • Question
Tchart and Table help? 1
Replies
4
Views
49
majlumbo
majlumbo

Part and Inventory Search

Sponsor

Back
Top