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?