I everyoneim trying to create Sql table with column came from a variableSo im try this line but i doesnt work... even if i dont have a error message from DBmy variable call b and it contains concanate version of my listbox column with commaand it appear like this in a messagebox " Name,Phone,Email "

App.OrdersDB.SQLExecute "Create Table test ((Str(b)) Varchar)"

in fact i need help to insert variable in sql in CREATE table...INSERT data and SELECT statementthanks

But it apply varchar only on the last column...is there a way to apply Varchar to all added column.Do i have to insert it in my concatenate function?And i try to apply same logic to insert... where can i find examplebecause

But it apply varchar only on the last column...is there a way to apply Varchar to all added column.Do i have to insert it in my concatenate function?

Most likely.

Quote:

And i try to apply same logic to insert... where can i find examplebecause

sql = "Insert into test ("+ b + Values ('Winnie','Sales','3500')")

Doesnt work either

You're missing a quote mark. Check the string in the debugger and adjust until you get what you want. Writing one language (sql) inside another language (RB) is always a challenge. But the debugger is your friend.