Subject pretty much says it all. I have a form that keeps displaying 12/31/1899 for empty dates. Long story short, I ruled out hidden code in the form, custom classes, etc, and finally narrowed it down to a view.
If I do this in the command box: Select * from claims where claimno = '123', I see the date field as empty. If I open it with the remote view, which is this: select * from claims claims where claims.claimno = ( ? vpclaimno) The dates show up as 12/31/1899. I'm using vfp9 (sp1 on that particular machine) and this is a remote view on local vfp data (don't ask, and no, I can't change that) I did check the view properties for the field, nothing odd there. Any ideas? -- Vince Teachout Caracal Software www.caracal.net 518-733-9411 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
