Hi Boris,

Try to convert you data to unicode

... + STRCONV(ALLTRIM(m.usern),5) + ...

>I use SQLEXEC to update ome fields in SQL Server Table (VFP8 SP1). Here my code:
>
>

>SQLEXEC(sqlh, "UPDATE InOut SET UserName = '"+ALLTRIM(m.usern)+"' WHERE InOut.KeyNum = "+cKeyNum)
>

>but when I SELECT back that field into cursor I see as username "?????????????", field type of UserName is nVarChar and
>SET COLLATE TO "MACHINE"
>I try to change the first code with using CA but no difference in the username.
>
>
>
>In other place in my application I update other table different way:
>

> csql = SQLEXEC(sqlh, "SELECT * FROM Staff_New WHERE OutNom = ?mid","cStaff")
> SELECT cStaff
> CursorSetProp('KeyFieldList','OutNom'   ,'cStaff')
> CursorSetProp('WhereType'   ,          2,'cStaff')
> CursorSetProp('Tables'      ,'Staff_New','cStaff')
> CursorSetProp("UpdateNameList", ;
>                "OutNom    Staff_New.OutNom,"+;
>                "Ime       Staff_New.Ime,"+;
>                "Dlj       Staff_New.Dlj,"+;
>                "Egn       Staff_New.Egn,"+;
>                "Zweno     Staff_New.Zweno","cStaff")
>CursorSetProp('UpdatableFieldList','OutNom,Ime,Photo,Dlj,Egn,Zweno','cStaff')
>CursorSetProp('SendUpdates',.T.,'cStaff')
>CursorSetProp('Buffering',    5,'cStaff')
>INSERT INTO cStaff (OutNom,     Ime,       Dlj,     Egn,       Zweno) VALUES;
>                   (mid   , Rab.Ime, N_Dl.Name, Rab.Egn, Struct.Text)
>Tableupdate(2,.T.,'cStaff')
>

>and Here is no problem with Cyrilic, field Ime is again nVarChar and SET COLLATE TO "MACHINE".
>
>So what I' doing wrong?