UPdtae table send me message column not found

Started by eldonfsr, February 26, 2024, 03:52:35 PM

Previous topic - Next topic

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..

eldonfsr

The dictionary is of mas90 countrycode is string 3  and look only accept 2...

EVa

I can't help you with that - you need to contact whoever created the file/dictionary entry as it looks like these do not match.

eldonfsr

Thanks so much for your replay  i appreciate this.
 
there a way from command line run utility to fix that problem... because i don't have nomads  for 32 bits...the version i have is 64 bits and don't know could affect all information on table.