| View previous topic :: View next topic |
| Author |
Message |
Barak zabari Guest
|
Posted: Tue Apr 12, 2005 12:47 am Post subject: Table create script |
|
|
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?
thanks
Barak
|
|
| Back to top |
|
 |
Mike Shkolnik Guest
|
Posted: Tue Apr 12, 2005 7:57 am Post subject: Re: Table create script |
|
|
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm
You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote
| Quote: | D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?
thanks
Barak
|
|
|
| Back to top |
|
 |
Mike Shkolnik Guest
|
Posted: Tue Apr 12, 2005 9:45 am Post subject: Re: Table create script |
|
|
Sorry - I sent an incorrect link:
http://www.scalabium.com/download/smcmpnt.zip
There is the SQLGen.pas unit where is the required component
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote
| Quote: | Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm
You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?
thanks
Barak
|
|
|
| Back to top |
|
 |
Mike Shkolnik Guest
|
Posted: Tue Apr 12, 2005 9:46 am Post subject: Re: Table create script |
|
|
See my another post with correct link
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote
| Quote: | Thanks Mike but from what i see this component does not create a new
script
but process an existing one.
What i am looking for is something that will create a table script like
you
can get when you run the MSSQL Query analyzer.
For some reason i am pretty sure there is a way to do it an i just can't
remember what it is.
"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote in message
news:425b7f5f (AT) newsgroups (DOT) borland.com...
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm
You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?
thanks
Barak
|
|
|
| Back to top |
|
 |
Barak zabari Guest
|
Posted: Tue Apr 12, 2005 10:31 am Post subject: Re: Table create script |
|
|
Thanks Mike but from what i see this component does not create a new script
but process an existing one.
What i am looking for is something that will create a table script like you
can get when you run the MSSQL Query analyzer.
For some reason i am pretty sure there is a way to do it an i just can't
remember what it is.
"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote
| Quote: | Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm
You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?
thanks
Barak
|
|
|
| Back to top |
|
 |
Barak zabari Guest
|
Posted: Sat Apr 16, 2005 2:54 pm Post subject: Re: Table create script |
|
|
Thanks it helped alot.
"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote
| Quote: | Sorry - I sent an incorrect link:
http://www.scalabium.com/download/smcmpnt.zip
There is the SQLGen.pas unit where is the required component
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote in message
news:425b7f5f (AT) newsgroups (DOT) borland.com...
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm
You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements
--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com
"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?
thanks
Barak
|
|
|
| Back to top |
|
 |
|