Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Java/HTML saving to VFP Memo Field
Message
De
07/08/2002 08:26:30
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
07/08/2002 04:07:52
Edward See
Magicalogic Consultancy System
Quezon, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00686913
Message ID:
00686969
Vues:
45
>to anybody:
>
>i cannot save a long html textbox string value to a VFP DBF memo field.
>it is being truncated
>i am using ODBC
>what is the OBJECT TYPE OF VFP MEMO FIELD ?
>in java, saving is
>
>PreparedStatement stmt = conn.prepareStatement(sqlFieldDescription);
>stmt.setString(1,memoString);
>stmt.executeUpdate();
>
>appreciate any help

In VFP, you save to a memo field with:
replace MyMemo with MyValue
The size is almost unlimited (the entire FPT file can't have more than 2 GB).

The type is compatible with Character, but character fields are limited to 254 bytes. Character variables can be much longer.

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform