Database Creating

[OuTCasT]

Hi all.

I want to ask if its possible if we could have a form that would require user input in textboxes and with that information create the dbName and dbTables ?

for example these were required to fill in [ ] = textbox :

Company Name: [dbName]

Earnings: [dbEarningsTable]

Bonus: [dbEarningsTable].[dbEarningTableC olumn]
Salary: [dbEarningsTable].[dbEearningsTabl eColumn]

is something like this possible.

each time they create a NEW COMPANY a new database is created with that name being the new company name and then they got to populate it with there own details? ??

[ck9663]

Is it possible? Yes.

Is that form possible in MS-SQL Server, No.

You have to create the form using a front-end tool and use the info supplied on that form to create your DB and tables.

-- CK

[OuTCasT]

Is it possible? Yes.

Is that form possible in MS-SQL Server, No.

You have to create the form using a front-end tool and use the info supplied on that form to create your DB and tables.

-- CK

Ok so ive created like a couple of screens that will act as a wizard at creation of company etc.

the sql statement would be structured how ?

[CODE=sql]Create Table ' " & txtCompanyName. text & " ' [/CODE]

[ck9663]

Ok so ive created like a couple of screens that will act as a wizard at creation of company etc.

the sql statement would be structured how ?

[CODE=sql]Create Table ' " & txtCompanyName. text & " ' [/CODE]

Looks like you're using VB/ASP/.net apps. But you're in the right direction. You just have to place that entire string into a variable that you can pass to your connection object.

-- CK