Sql query problem....

[developerno1]

I've a datareport that uses dataenviroment to fetch data
the query i use is :

SELECT  * from testsdata,patient_ID as patientid, WHERE
    patientid = ?

here testsdata id the table , patient_id is the parameter i want to use as the filter.
But even when i supply the parameter using the code:

DataEnvironment1.Commands("report").Parameters(0).Value =txtPatientID

the report doesnt filter the data.... whatz gng wrong , any suggestions

[magnadyne]

try

DataEnvironment1.Report txtPatientID

This works on my reports