>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)