Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  Buy Now
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Memo Field Conflict
Omar Cornejo
2006-06-29 12:06:56.0
I have to withdraw the value of a memo field in my app, and then insert that value in another record. In certain records, the info that i withdraw ir corrupt. It contains the real data of the memo field, and then a \u001a character followed by scrambled info of another recognizable (but no existence justificable) memo fields in the table. How can i obtain correctly the info of all my memo fields?
Re:Memo Field Conflict
HXTT Support
2006-06-29 18:13:28.0
Yeah. A normal DBT memo data should end with 0x1a 0x1a flag, but it seems that some data is abnormal with only one 0x1a flag. What's the original data source for invalid memo data? You can use indexOf('\u001a') and substring to fix those data.
Re:Re:Memo Field Conflict
Omar Cornejo
2006-06-30 08:15:55.0
I've already used that solution (indexOf). And works well, but my question was about avoiding this method, maybe changing some property or configuration of the library.

As I told you, i have to "move" the info from a table to another, to later modify that info in the second table. I'm afraid that if the library detects only de "0x1a 0x1a" flag and not the "0x1a" flag, my data would become corrupt, because the data to be written have to be modified by a clipper app.

May I'd be worried about it? or it does not cause any additional troubles?
Re:Re:Re:Memo Field Conflict
HXTT Support
2006-06-30 08:46:25.0
>I'm afraid that if the library detects only de "0x1a 0x1a" flag and not the "0x1a" flag
Yeah because Only 0x1a 0x1a flag is normal.

If your data is modified by Clipper application at the same time, you should use lockType=CLIPPER to avoid the possible 0x1a.

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap