Thanks a lot, David. So, my experimenal conclusion was correct. Rare occurrance <g>
Ed Rauh would say "Read the fine manual"...
Thanks again.
>Yes, I just tried it in VFP8 and it didn't work -- then I checked help for VFP8 CursorSchema and it didn't show DEFAULT. Then checked "What's new" in VFP9 and found this:
>
>
DEFAULT and CHECK Constraints Respected
>In Visual FoxPro 9.0, DEFAULT values and table and field level CHECK constraints are supported for XML, Native, ADO and ODBC data sources. In Visual FoxPro 8.0, DEFAULT values and table and field level CHECK constraints are only supported for an XML data source. For the DEFAULT values and CHECK constraints to be applied to a cursor, call the CursorFill Method with the lUseSchema parameter set to True (.T.). For more information, see CursorSchema Property.>
>So DEFAULT is good in VFP8 only for XML data source.
If it's not broken, fix it until it is.
My Blog