Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Java/HTML saving to VFP Memo Field
Message
From
07/08/2002 08:26:30
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
07/08/2002 04:07:52
Edward See
Magicalogic Consultancy System
Quezon, Philippines
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00686913
Message ID:
00686969
Views:
42
>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform