I have a Clipper database that has memo fields in FlexFile3 format.
When I try to select a memo field:
String sql = "select memo_field from my_table where id=1";
ResultSet rs = statement.executeQuery(sql);
rs.getObject(1); returns funny characters: ??‡???ðâ
Which I think is the pointer to the contents of memo_field in the FlexFile3 file.
What is the correct SQL to select and update a memo field in Clipper (FlexFile3)?
Our HXTT DBF Package support the FlexFile3 file,so, maybe your Flex file is an unknown file format.Please send firstname.lastname@example.org a sample FleFile3 format file.