Field Selection in Query

[dzdncnfsd]

How do I select all but one or two fields from a table without having to write out "Select loan_num, name, payment from loans"? I have a table with a lot of fields and I want all but two of them included in my query. (VFP 5.0)
Thanks,
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[Walid]

Hi my friend
Try this..

lcMySelectedItems = MYSELECT()
SELECT &lcMySelectedItems FROM REMBATCH

FUNCTION MYSELECT
*// This function will return a string of all the fields *// you want to include in your query.
lcReturnVal=""
FOR X=1 to FCOUNT()
  IF FIELD(x)="CADD_USER" &&/* The field you don't want */
    LOOP
  ENDIF
  lcReturnVal=lcReturnVal+FIELD(x)+IIF(X=FCOUNT(),"",",")
ENDFOR
RETURN lcReturnVa

 

[dzdncnfsd]

Thanks, Walid. I will try your method. Today, though, I took the easy way out and pulled all fields into a cursor then copied out to an Excel spreadsheet to get rid of the memo fields which is what I wanted to do in the first place. Since that won't work in every case, it is good to have another way to exclude unwanted fields.
Have a great day!!
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com