Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving unicode data
Message
From
26/12/2011 12:39:41
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01531693
Message ID:
01531695
Views:
71
You might look at this http://www.west-wind.com/presentations/foxunicode/foxunicode.asp



>Hi everybody,
>
>I am using MS Forms 2 Textbox control. I found that I can select cast(nvarcharField as varbinary(max)) and directly assign to the text property and it works.
>
>Now, I am wondering how can I save the values? I tried assigning the text property directly to the field and then
>
>
> UPDATE dbo.prefs_sl 
>     SET defltlang = ?prefs_sl.DefltLang,
>     language00 = cast(?prefs_sl.language00 as nvarchar(100)),
>     lngimage00 = ?prefs_sl.lngimage00,
>     language01 = cast(?prefs_sl.language01 as nvarchar(100)),
>     lngimage01 = ?prefs_sl.lngimage01,
>     language02 = cast(?prefs_sl.language02 as nvarchar(100)),
>     lngimage02 = ?prefs_sl.lngimage02,
>     language03 = cast(?prefs_sl.language03 as nvarchar(100)),
>     lngimage03 = ?prefs_sl.lngimage03,
>     language04 = cast(?prefs_sl.language04 as nvarchar(100)),
>     lngimage04 = ?prefs_sl.lngimage04,
>     language05 = cast(?prefs_sl.language05 as nvarchar(100)),
>     lngimage05 = ?prefs_sl.lngimage05,
>     language06 = cast(?prefs_sl.language06 as nvarchar(100)),
>     lngimage06 = ?prefs_sl.lngimage06,
>     language07 = cast(?prefs_sl.language07 as nvarchar(100)),
>     lngimage07 = ?prefs_sl.lngimage07,
>     language08 = cast(?prefs_sl.language08 as nvarchar(100)),
>     lngimage08 = ?prefs_sl.lngimage08,
>     language09 = cast(?prefs_sl.language09 as nvarchar(100)),
>     lngimage09 = ?prefs_sl.lngimage09,
>     language10 = cast(?prefs_sl.language10 as nvarchar(100)),
>     lngimage10 = ?prefs_sl.lngimage10
>
>However, this doesn't seem to work as the field get converted to something else.
>
>I am wondering, if there is a step missing here. Say, may be I need to do something when assigning text property of the ActiveX back to cursor's memo field.
>
>Does anyone here have experience displaying and saving unicode data in VFP form?
>
>Thanks in advance.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform