Hello well juts testing to run sql look message i follow documentation and examples to write sql statement correct
just on first column the values must be on single '' or bouble "" , if i put on single '' don't send error but all information is mixed on fields , so put "" and send this error...what i doing wrong..
SQL Error: [ProvideX][ODBC Driver]Column not found: California Metal Services Inc
Code: -2147467259 SQL: UPDATE AR1_CustomerMaster SET CustomerName="California Metal Services Inc " ,
AddressLine1= "1428 W Mission Road ",
AddressLine2= "1430 ",
AddressLine3= " ",
City= "ESCONDIDO " ,
State= "CA " ,
CountryCode= "SA "
where Division="00"
and CustomerNumber="CMS"