I have a problem with reading data from memo fields:
Database structure is:
KEY CHARACTER 17
MODELID CHARACTER 8
SIGNAT MEMO
DAMAGE MEMO
File type 0xF5 (list of files: PHOTOS.DBF,PHOTOS.DDD,PHOTOS.DDM,PHOTOS.DDX,PHOTOS.FPT,PHOTOS.MDX)
my java code:
PreparedStatement ps4=conn.prepareStatement("select MODELID,SIGNAT,DAMAGE from PHOTOS where KEY=?");
ps4.setString(1,"123");
ResultSet rs=ps4.executeQuery();
while(rs.next()){
byte bdata[]=rs.getBytes(2);
byte bdata2[]=rs.getBytes(3);
//.....
}
I have 2 record in the DBF file with both memo fields filled.
But bdata and bdata2 always null.
Please help me. It' very urgent.
P.s. I'll send to you actual DBF files if you need it.
Thanks,
Vadym Osadchuk
|
Don't worry. You can zip and upload your database sample into:
ftp site: ftp.hxtt.com
ftp user: anonymous@hxtt.com
ftp password: (empty)
login mode: normal (not anonymous)
ftp port:21
upload directory: incoming
transer mode: binary (not ASCII)
After upload, you can't see that upload file, but it has been upload.
Then we will check and fix that invalid lob information for you.
You can also choose to zip and email your (PHOTOS.DBF and PHOTOS.FPT) files to webmaster.hxtt@gmail.com .
|