Richard Kaye wrote: > IIRC when VFP builds the result cursor, the SQL engine uses the values in the > first row it finds to determine the data structure. This can result in > truncated information.
Yes, I'm pretty familiar with that, but I've only seen that where you're selecting from a field. With a VFP back-end, if you specify the length with a literal, it respects the length. This is what actually bit my colleague. This was code originally written by someone else for a VFP back-end, years ago, and it started to fail when the same SQL command was ported over to SQL Server. _______________________________________________ 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.
