I have a small question here regarding data type mappings when extracting data from M$ SQL Server 2005/2008 which is bugging me.
For the first time ever I have specified a datatype on the server as BIGINT as opposed to INT. The reason for this is the amount of data that will blow the "int" datatype Primary key out of range. The data when extracted via STP comes back as a character field length 20. Anyone know how to do similar to in MySQL in being able to map Bigint to INT via a parameter in the connection string so the data arrives back in VFP as an integer or failing that a real number with 0 DP's. I know I can run a Cast function to do the convert but this is messy and easily forgotten. Dave Crozier _______________________________________________ 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/cee164a870c1463b990cb831da0d4...@develop ** 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.
