Hi,
Using the CREATETABLE method with 12 CHAR fields returns Error 3047. However, if I remove some fields, it creates the tables fine. I'm not adding any data, just creating fields. Is there a limit with the CREATETABLE method?
P.s. this is in a loop for multiple tables. See code below.
Code:
For i = 1 To 2
db.Execute "CREATE TABLE Temp_QuoteProcs" & i & " (ID CHAR, PARTNUMBER CHAR, PROCID CHAR, PROCVERSION CHAR, RATE CHAR, TOOLING CHAR, RESOURCES CHAR, BURDEN CHAR, SETUP CHAR, TEARDOWN CHAR, INSTRUCTIONS CHAR, orderfield SINGLE);"
Next i
Thanks