Group: microsoft.public.fox.vfp.queriessql · Group Profile
Author: Mark StantonMark Stanton Date: Sep 14, 2008 23:21
I suspect the problem is the original table was in a database and the new one
isn't.
Fox can only have 10 letter field names in free tables.
Regards
Mark
In article microsoft.com>, Patrick Tura
wrote:
> Hi!
>
> I got a sql-select command(Below this Email) to get the collection
> performance of our staff. This code is running fine actually but only
> that in the new table as a result of this query. The "contract_id" became
> "contract_i".
> I don't understand why the field is being altered into the new table
> cperformance.
>
> Is contract_id as field name is too long that VFP cannot accomodate?
>
> I can still go around but it would be nice if VFP is more accurate
> specially in field names.
>
> Anyone can help also go around this inaccuracy?
|