>Hello All
>I have created a cross tab query and wana show the result in the report, but each time the query runs that creats a cursor columns with the different name , so it is not possible to bound the text box in report, can it be possible in vfp 5.0, if so how ???
>
>waiting for reply
You may apply ALTER TABLE command against the result cursor, e.g.
alter table mycursor rename column column1 to mycolumn1
You may do it looping through FCOUNT() FIELD() loop:
For n=1 to fcount()
cFieldname=field(n)
cNewfieldname="mycolumn"+allt(str(n))
alter table mycursor rename column &cFieldname. to &cNewfieldname.
Endfor
Edward Pikman
Independent Consultant