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