we are evaluating your product, we found a different behavior in boolean fields , in VFP . During our tests when we query a table with boolean fields,in legacy system we have mantain Interoperability, a new table(in VFP) had a default boolean value as false, but quering the same table with HXTT has returned boolean fields as null. When we update the values in boolean fields the result are the same in both VPF and HXTT .
What we should do to achieve the same result in VFP and HXTT, there is some connection propeties?
> fields,in legacy system we have maintain Interoperability
You need lockType=VFP connection property, otherwise HXTT DBF and VFP can't see each other.
> a new table(in VFP) had a default boolean value as false, but
> querying the same table with HXTT has returned boolean fields as null.
Yeah. Because HXTT DBF need to support multi version of Xbase, it will use null value as default value for inserting new data row.