Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MySQL and Memo Fields
Message
De
11/09/2005 18:08:59
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01048555
Message ID:
01048562
Vues:
24
I'm perplexed:

I created a field in MySQL called 'Notes' and made it a 'Text' type field. I added a record, and populated the 'Notes' field of that record with 400 characters.

I then edited the prg filein VFP to add the following two lines to my CURSORSETPROP lines:

cursorsetprop("UseMemoSize",100)
cursorsetprop("FetchMemo",.T.)

I am assuming from these lines that any 'charcter' field that I bring in that is greater than 100 characters in length will be shown in my browse window in VFP as a memo string. The string, however, shows up as simply characters (400? 256? I didn't count...) in the browse window. I tried changing the MySQL field to a VARCHAR(400) type; the browse window then displayed a 'Gen(eral)' type field. When I double clicked on it, I got an error message saying that the OLE file was either invalid or corrupted.

C
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform