Dynamic Tables? Is this possible?

[TonyU]

I was wondering if one could create tabbles and in turn sql statements on the fly (dynamically) if an option is selected on a previous page.

Example:
We are developing an internal systems that tracks our job progress for all our clients for billing purposes. An on one of our pages there will be either a radio button or check box that IF checked will load a specficic client form to upload data into, if not checked the'll never see that form at all.

So again, can a table be created if this option is clicked?? and If SO, I would also like to know how to dynamically create a select statement from this freshly creqted table.

I'm a web\database developer in training, so please, bear with me.

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[TonyU]

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[Ladyhawk]

The Select statement for a recordset is just a string. This means that you can dynamically build up the string based on values that on a form. For example:

sql = "SELECT * FROM myTable WHERE myField = '" & Request.Form("myTextBox&quot & "'"

Hope that helps.
Ladyhawk.

 

[Jonax]

You can CREATE a TABLE on the fly as well...

Are we talking SQL-Server or Access or ? This is not a bug - it's an undocumented feature...
;-)

 

[TonyU]

We will be using SQL 2000. Thanks

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[Jonax]

Look in SQL-Server Books Online for CREATE TABLE (in the T-SQL Refernece...) This is not a bug - it's an undocumented feature...
;-)

 

[TonyU]

LOL.

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[Jonax]

This is not a bug - it's an undocumented feature...
;-)