>Hi, all
>
>I want to do a generic report for my tables, something like that,
>
>Based in table fic, generate a form only with the name field and a check box, then, if the users check box choice done, generate the report, only with the check boxes choices.
>
>Thank's in advance,
>
>Joao Batista
>(
jbinf@mail.telepac.pt)
>(Beginner VFP6.0)
I think I understand what you are saying... all you need to do is build a string of your select statement and use the & macro expansion available in VFP to run like you want...
lcSql = 'select * from table where '
lcWhere = ' x=1'
lcInto = ' into cursor genreport'
lcselect = lcSql + lcWhere + lcInto
&lcSelect
Then build your report against the genreport cursor...
HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown