> 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?
>
> Thanks a lot.
>
> Patrick Tura
>
>
>
> SET ENGINEBEHAVIOR 70 && VFP 8.0 adjustment to run SQL-Select with
> grouping without problem
> set safety off
> set century on
> set exclusive off
> open database c:\kffmaindbf\client shared
>
> SET DATE ANSI
> local gdstart,gdend
> gdstart=date()
> gdend=date()
> gdStart = Date( Year(Date()), Month(Date()), 1 )
> gdEnd = GoMonth(m.gdStart,1)
>
> *Collection Performance 2008.02.24
>
> select kffstaff.gname,kffstaff.fname,book.staff_id,DATUM,KTO,sum(INN),TEXT
> ;
> from book,biodata,kffstaff ;
> nowait ;
> where book.client_id = biodata.client_id ;
> and biodata.B = "B" ;
> AND book.staff_id=kffstaff.staff_id ;
> and KTO='Cust';
> AND text= 'Payment' ;
> AND datum >=gdstart ;
> AND datum <=gdend ;
> AND kffstaff.position='Collector' ;
> group by book.staff_id ;
> ORDER BY book.inn descending INTO table c:\checker_dbf\cperformance