>I'm running a simple stored procedure on an SQL7 server from VFP 6. The data type for the field in the SQL table is varchar and the result set I get in VFP is composed of memo fields. How do I get them to return as a string, or preferably integer, value since the data items are numbers? Thanks for any help...
I don't know SQL7 syntax, but after getting records from SQL server into a cursor, you can run a SELECT - SQL command, converting fields with val() (a VFP function).
Regards, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)