I use excel vba to creat a sql query and get data from Teradata database. Recently the changed a field into alphanumeric and I can't use my query as I get error when passin the customer_id
here are some of the parts:
(I have this in a userform)
Dim clientnr As String Dim thisql As String Dim uiValue As Stri clientnr = UserForm3.uiValue.Text 'code where I pass the sql: thisSql = "CUSTOMER_ID " & _ "FROM myDataBase.CUSTOMER " & _ "Where ((CUSTOMER_ID)= " & clientnr & ")"
the CUSTOMER_ID is set Varchar(50) and is alphanumeric
this really drives me crazy.