Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems converting memo fields to binary
Message
 
 
To
09/04/2007 15:58:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01213612
Message ID:
01213714
Views:
15
For backward compability the image/binary/varbinary data type mapping in VFP9 is the same as in previous versions. To map to new Blob and Varbinary VFP data types you have to change default mapping as shown below. See CURSORSETPROP() function help for details.
* Map SQL Server Image to VFP Blob, Binart and VArbinary to Varbinary or Blob.
= CURSORSETPROP("MapBinary", .T., 0)
* In addition you can allow SQL Server varchar to map to VFP varchar
= CURSORSETPROP("MapVarchar", .T., 0)
If

>I want that they help me with this please I am changing platform of vfp dbf to sql.
>
>I am in the final process,passing the information but I have the following problem in one of the new tables have a binary field and when makes a selec * to the table it(he,she) is comes as Memo fields.
>
>Then when I try to update the table by a procedure of cursortors I have problems, which I can do
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform