Hello, I have been using VFP for years but this is the first time I have had to access data from an SQL server.
I have the connection made and I can pull a query successfully. Here is my question: The date fields are coming over as character in 2013-10-16 format. Is there a way to get date fields or do I have to convert them ? Also there are many character fields that instead of being blank have .NULL. Do I need to convert these also ? What is the best way to convert the data or is there a way to tell SQL server to send it better ? This is probably very basic for most of you ... Any help is appreciated, Thanks, Kent _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
