Alaska Software Inc. - Truncated field
Username: Password:
AuthorTopic: Truncated field
Davide MauriTruncated field
on Tue, 30 Mar 2010 23:47:45 +0200
Te following code:

oCn:=ActiveXObject():Create("ADODB.Connection")
oCn:Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=AT_Acc.mdb")
oRs:=ActiveXObject():create("ADODB.Recordset")
oRs:Open("SELECT * FROM t_CORM",oCn,0)
oRs:Fields("CORM_Note"):Value

return:
"extra contributo di 25.000"

but field contain:
"extra contributo di 25.000? per attivit web"

Why?
Thank's.
Davide MauriRe: Truncated field
on Thu, 01 Apr 2010 09:33:26 +0200
Sorry, the string "extra contributo di 25.000? per attivit web" is wrong.
Instead of "?" there is an Euro Symbol.
My problem is that all field containing Euro Symbol are truncated before 
that character.

Can someone help me?
Thank's


"Davide Mauri" <davide@novae.it> ha scritto nel messaggio 
news:21c2450f$5f01f949$52295@news.alaska-software.com...
> Te following code:
>
> oCn:=ActiveXObject():Create("ADODB.Connection")
> oCn:Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=AT_Acc.mdb")
> oRs:=ActiveXObject():create("ADODB.Recordset")
> oRs:Open("SELECT * FROM t_CORM",oCn,0)
> oRs:Fields("CORM_Note"):Value
>
> return:
> "extra contributo di 25.000"
>
> but field contain:
> "extra contributo di 25.000? per attivit web"
>
> Why?
> Thank's.
>