nchar(1)

[yazzy]

Hi

I am getting the following error 'Invalid character value for cast specification' when the query below is excuted in Clarion but it runs in SQL

Opportunity{PROP:SQL} = 'Select CONVERT(CHAR(1),oppo_psappr) from opportunity '

Loop
Next(Opportunity)
Case Errorcode()
Of Badrecerr
Break
Of Noerror
Cycle
Else Stop(fileerror() & ' ** file error code')
End
End

Could anyone in the Clarion6.1 community help please?

thanks in advance

 

[ShankarJ]

Hi,

Possibly a mismatch in the data type of the first column of the Oppurtunity Table definition. It must be a STRING/CSTRING to receive a CHAR.

Regards