Hello,
I have this SQL-statement:
select ref_plaatsid, ref_plaats, ref_plaats1 from persoon
When I execute this, I'm getting in the result these column-names:
persoon.ref_plaatsid
persoon.ref_plaats
ref_plaats1
I didn't expect "persoon.". here. Is this normal?
With kind regards,
Remco Schoen
|
>select ref_plaatsid, ref_plaats, ref_plaats1 from persoon
Because old Xbase format allow at most 10 character as column name so that HXTT DBF consider too much about it. What's your Xbase version (dbase, foxpro, VFP, or Clipper)?
|
Checked. That was resulted by VFP provides long column name support on Xbase format. In fact, ref_plaatsid column has a ref_plaats shorter standard name which is confused with the long ref_plaats column name. HXTT DBF supports to use long column name or short standard name to quote column. The latest package will be availabe after about 2 hours.
|