>I am creating a work cursor using SQL Select on .DBF Tables with readwrite. I would like to add an intiger field that will be used later to hold some stuff.
>
>There are two ways that I know of:
>
>1. Create a one record cursor with an intiger field before I call the SQL Sel and reference it like we always have to create memo fields.
>
>2. Include "000000000 as myint" in the Select.
>
>The problem, of course, is that #2 actually creates a numeric field.
>I was wondering if there is any new way in VFP 8.0 or 9.0 that I haven't found???
>TIA
In VFP8 only 1. will create integer field. In VFP9 there's new CAST() function
..., CAST(0 AS int) AS myint, ...
--sb--