Main Board > ODBC

UPdtae table send me message column not found

(1/2) > >>

eldonfsr:
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"

EVa:
It works here when I replace " with ' :

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'

eldonfsr:
Yes looks is working but if you check the information on table is not show up as must be some information from column is put into other column spread the information
UPDATE  AR1_CustomerMaster  SET  CustomerName=''California Metal Services Inc'' ,AddressLine1=''1428 W Mission Road'',AddressLine2=''1430 '',AddressLine3='' '',City=''CARLSBAD'' ,State=''CA'' ,CountryCode=''USA'', ZipCode=''92008''  where   Division=''00'' and CustomerNumber=''CMS''

you see countrycode is now as in sql ... some put in conactcode and other countrycode

some strange on sqlodbc...
 

EVa:
Doesn't happen here, but I don't have your dictionary information.  When my table has this data:

1:dump
ADDRESSLINE1$="addressline #1"
ADDRESSLINE2$="addressline #2"
ADDRESSLINE3$="addressline #3"
CITY$="City"
COUNTRYCODE$="USA"
CUSTOMERNAME$="Customer CMS00"
CUSTOMERNUMBER$="CMS"
DIVISION$="00"
STATE$="NY"

and I execute this update:  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'

the table then has this data:

1:dump
ADDRESSLINE1$="1428 W Mission Road "
ADDRESSLINE2$="1430 "
ADDRESSLINE3$=" "
CITY$="ESCONDIDO "
COUNTRYCODE$="SA "
CUSTOMERNAME$="California Metal Services Inc "
CUSTOMERNUMBER$="CMS"
DIVISION$="00"
STATE$="CA "

which is correct.  If this doesn't work for you, I would suspect that the dictionary information isn't correct.

eldonfsr:
Thanks for you time and help me here image of my test and file definition... some look is take country as length of 2 but is 3 characters string..

Navigation

[0] Message Index

[#] Next page