getDataSetByQuery

i am using getDataSetByQuery to restrict what records all pulled from the main table of the form by using my own MS SQL statement. I am then using controller.loadRecords(pkdataset) to get the records from within my onLoad method. Is there any reason why more records are returned then what I specify in my SQL statement as based on my where clause?

are you sure that you see suddenly more records then what you should see?

Are you really seeing records that shouldn’t be seen based on youre query?