Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems converting memo fields to binary
Message
 
 
À
09/04/2007 15:58:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01213612
Message ID:
01213714
Vues:
17
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform