sdo2shp和shp2sdo

History of TDBF: ------------------------ Authors: - Pascal Ganaye - upto V5.002 - Micha Nelissen - from there thanks to various people helping on details ------------------------ BUGS & WARNINGS (not complete) - Multi-user support - not tested well... - use FIXED LENGTH index expressions: an expression which will always return a string which is the same length. When returning a float you don't have to worry about this of course (always fixed #bytes). String fields also return fixed length expression, complete field with spaces. - BCB4/D4 and lower: - restructure probably does not work correctly, because the field defs don't know the index of the field they have to copy from (Dbf_Fields) - BCB3/D3 compatibility: - you will NOT be able to use Int64 features: - large numeric fields with zero precision (set UseFloatFields to true) - datetime fields '@' - double fields 'O' - maybe more...look in source where Int64 is used - no codepage conversion available other than oem<->ansi - storedefs is not updated automatically when fielddefs are changed ------------------------ V6.4.1 - fixed: restructure numeric fields correctly, try to preserve data - fixed: read and write foxpro currency fieldtype (thx karelrys) - fixed: when using TDbf.Insert to add a record, current record indicator does not move to newly added record (rep by rpoverdijk) - fixed: req. of numeric field size >= 2, it can be 1 too! (rep by rpoverdijk) - fixed: forgot cursor position when disabling filter (rep by bobmitch/luchop) - fixed: initialize binary field types '0' (nullflags) and 'Y' (currency) properly (thx to karelrys) - added: _nullflags field operation support (thx karelrys) - fixed: when editing a record, then moving to another record, memo is not properly cleared if memo is null (rep by versus) - fixed: writing to a memo that also has a connected dbcontrol does not work; quite some semantical changes, may have introduced new bugs (rep by mafro) ------------------------ V6.4.0 - fixed: dBase III and IV do not have date+time fields - fixed: index search bug, not finding records (rep by peruginia) - fixed: expression bracket pair checking; caused strange expression errors - fixed: parse filter expression upon opening file (rep by mvc) - added: do not resync/reparse filter if not property unchanged - fixed: use international string functions in expressions - fixed: index deletion and update corruption while range active (rep by ralf) ------------------------ V6.3.9 - fixed: recursive loop in index first/last - fixed: index resync current record - fixed: resync range at eof - fixed: index findkey finds last, deleted key in index page - fixed: opening dbf file with numeric integer field misreads numbers - fixed: storage of foxpro binary integer field - fixed: only support 65535 length character fields for foxpro (otherwise ms excel generated files can not be read) - fixed: call CursorPosChanged whenever cursor position possibly changed - fixed: keep cursor position when index and range active as much as possible ------------------------ V6.3.8 - fixed: outdated buffer in checking found key - fixed: createtable with memorystream; tdbf.userstream (thx andrew) - fixed: garbage record when adding a record to empty table - fixed: fields settings size for integer fields - fixed: underflow buffer in GetStrFromInt when Width=0 - fixed: IndexFile.PrepareKey numeric index: encode value zero to have no digits - added: TDbf.PrepareKey for conversion of key to numeric index key format - fixed: set physicalrecno to non-existing recno corrupts table (rep by luchop) - fixed: tryexclusive/packtable/endexclusive fail because of memo (rep by sysklop) - fixed: crash when calling {un,}locktable on closed dataset (rep by sysklop) - fixed: use correct dbf version when creating table to decide field types - fixed: kylix compilation - added: multi-user and insert aware ranges (req by ralf) - chngd: made all filenames lowercase to ease usage on *nix - added: partial matching in expressions for filters - added: -, *, / operators in expressions - fixed: datetime issues with fieldtype '@' and delphi 4 and lower (nobody uses those fieldtypes? they have been horribly broken, and maybe still are) - fixed: getting recno in oncalcfields event (rep by lutz) - fixed: AV when checking empty binary fields - fixed: better foxpro header writing, fieldoffset, tabletype and headersize **Version .1: - fixed: recursive loop in setrange ------------------------ V6.3.7 - fixed: numeric index data exponent (rep by rpoverdijk) - fixed: big-endian issues in dbf_idxfile - added: spanish (thx mauricio) and brazilian portuguese translation (thx adilson) - fixed: opening memory streams; more generic implementation - fixed: querying ExactRecordCount on open table causes AV (rep by sikorsky) - added: smarter Dbf_Parser initialization (thx emled) - fixed: copy languageid and autoinc values upon restructure/pack - added: TDbf.LanguageID to set language id of new table; set before CreateTable - fixed: remember autoinc value after restructure - fixed: do not try to create foxpro currency fields if creating dbase table - speed: when reading v4 memo field, set size of stream in advance - fixed: empty field really returns empty string in parser - fixed: rewritten token parser, tree construction to be much simpler - speed: reduce number of getrecordcount calls, cache recordcount if possible ------------------------ V6.3.6 - fixed: crash when optimizing expression with constants - fixed: expression parser to use variable-length string variables for non-raw fields - added: support for opening (memory) streams as file - fixed: numeric mdx compatibility bug; bytes instead of decimals (rep by rpoverdijk) - fixed: integer fields store numerics padded with zeroes; now it uses spaces - added: use new, faster assembler SwapInt64 from arioch ------------------------ V6.3.5 - fixed: crash when finalizing Dbf_Parser unit ------------------------ V6.3.4 - fixed: improved exception handling in expression parser - fixed: remove temporary indexdefs at close, fixes CreateTable index creation - added: NULLFLAGS field recognition (foxpro field) - fixed: date field retrieval parser (rep by luchop) - fixed: BCB5 installation needs Pascal switch to link dsgnintf unit - fixed: avoid dependency on libc unit for freepascal target - fixed: index open after packtable forgot tempmode; so endexclusive did not work properly (rep by sysklop) - chang: make TDbf.GetCurrentBuffer public - chang: rename TVarType to TExpressionType - chang: remove all SmallInt constructs from parser - added: export expression functions from Dbf_Parser - added: FFieldName to TFieldVar, to prevent need for TFieldDef to exist to get name for deletion from expression words list - added: "<>", not equal, expression functions - added: reference counting for TExprWord - added: shortname functionality for each function, function can be referenced by name and shortname - fixed: memory leak in parser upon encountering unknown variable - fixed: when adding record write new autoinc value to header, to file ------------------------ V6.3.3 - fixed: compiles with freepascal, usable in lazarus - fixed: index delete record bug (deleting not-last entry in full page) - fixed: index delete record bug (deleting the only entry on a page) - fixed: lazarus registration issues - fixed: scan for $1A, not RecordSize (rep by avink) ------------------------ V6.3.2 - fixed: use default codepage if file codepage not installed - fixed: range check error using swapint - fixed: flush index header when index flushed, ie. when creating index - fixed: update TDbf.IndexDefs when index added or deleted - fixed: update internal index na