Here is the code:
querystring = "Create Table " & workweekwafer & " (stepno int(5))"
Set RS = Conn.Execute(querystring)
workweekwafer = 0304-102
I get this error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.13-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0304-102(StepNo int(5), StepName varchar(50))' at line 1
I tried using
querystring = "Create Table [" & workweekwafer & "] (stepno int(5))"
but it still give me the same error
If I change the hypen (-) to and underscore (_), it has no problems creating the table. What is the VBSCRIPT command to type a hyphen, like I know for a quote mark it is char(34). Maybe that will work.
Well, I have a problem that it creates the table in the DB and I guess it tries again and give me an error that the table already exists when it should move on to another page, but that is a different problem for a different thread.
Any help is extremely appreciated.
querystring = "Create Table " & workweekwafer & " (stepno int(5))"
Set RS = Conn.Execute(querystring)
workweekwafer = 0304-102
I get this error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.13-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0304-102(StepNo int(5), StepName varchar(50))' at line 1
I tried using
querystring = "Create Table [" & workweekwafer & "] (stepno int(5))"
but it still give me the same error
If I change the hypen (-) to and underscore (_), it has no problems creating the table. What is the VBSCRIPT command to type a hyphen, like I know for a quote mark it is char(34). Maybe that will work.
Well, I have a problem that it creates the table in the DB and I guess it tries again and give me an error that the table already exists when it should move on to another page, but that is a different problem for a different thread.
Any help is extremely appreciated.