data report runtime code

[KAMALAKAR]

I HAVE A FOXPRO DATABASE,AS IN FOXPRO WE GENERATE REPORT BY TAKING DIRECT INPUT FROM THE USER.NOW,I WOULD LIKE TO DO THE SAME IN VB6.I WOULD TAKE INPUT FROM THE USER(Eg:empno = 99999) and want to generate report using datareport which is already created

[samvb]

I HAVE A FOXPRO DATABASE,AS IN FOXPRO WE GENERATE REPORT BY TAKING DIRECT INPUT FROM THE USER.NOW,I WOULD LIKE TO DO THE SAME IN VB6.I WOULD TAKE INPUT FROM THE USER(Eg:empno = 99999) and want to generate report using datareport which is already created

do this: have a command under connection1 for eg. the cmd src be sql:
select id,name from members where (memid= ?)

in the parameters tab, make the name of the parameter (Default name is ? which is invalid) to something like mymemberid.

From your vb from pass memid to the cmd like this
dataenvrionment name.cmdname memberid
datareport.show


hope that helps u out.

sam

[KAMALAKAR]

thank you ,i have got it.still an error "rowset cannot be ..." is popping up. i'll handle it .thank you