i had a problem in retrieving new records into vb6's datareport from a foxpro database when i didn't use requery. so, i tested requery with a simple command which didn't need any parameters. the code was
Set DataReport1.DataSource = DataEnvironment1
DataEnvironment1.rsCommand1.Requery
DataReport1.Show
it worked correctly.
but, in my real application, i need to pass parameters to the command in dataenvironment. i'm not being able to use requery in that case. the code i use is
DataEnvironment1.Connection1.Open
DataEnvironment1.rvcommand_Grouping str1, str2
datareport1.Show
here, i'm not being able to use the requery. i tried to insert it as
DataEnvironment1.Connection1.Open
DataEnvironment1.rvcommand_Grouping str1, str2
dataenvironment1.rsrvcommand_grouping.requery
report1.Show
but, it's giving error. can anyone tell me how to use requery correctly with a command that needs parameters.