Re: Using SQL to create user defined table & column names

Very sorry - somehow my postings have been attached to your thread. Julian

"Instrat" <Instrat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83619361-A772-4FC1-8599-F7D0E5E7536B@xxxxxxxxxxxxxxxx
> New to this and need some help
> I want to alter tables in an existing Access database from VB6.
> 1. I want to be able to select the table from a combobox in the VB6 form.
> The combobox should therefore display the table names from the database
> 2. Once the table is selected then another combobox should display the
> column names.
> 3. on selecting the appropriate column name how does one edit this i.e
> rename it if needed using SQL
> 4. Alternatively how does one add a new column to the selected table using
> names defined at runtime?
>
> I have been able to do this using standard SQL statements
>
> db.execute " CREATE TABLE" & txtTable.text & "([col_name1] Text(50),
> [col_name2] Long)"
>
> The column names ( col_name1 & col_name2) is however hard coded. I would
> like to be able set the names and select the characteristics from the VB6
> form
>
> I am aware that using the
>
> db-execute " ALTER TABLE Table_name ADD Column_name datatype "
>
> code one can add a new column but again the table name and column name and
> datatype has to be hardcoded. Can someone help me get around this?
>
> Your help would be highly appreciated


.

Relevant Pages