setgenfilter or setrange not working

[JBirdieH]

I have a table indexed on job# and a timestamp. When trying to call a second form from the first and limiting the view of that second form to records on the first form (job/timestamp) neither setgenfilter or setrange will work for me when I include the timestamp. I've tried every format possible. Do you need double backslashes? After every number? I then tried to circumvent the problem and setgenfilter on an job/address line (say field 5). This didn't work either! What is preventing this from working?

 

[Langley]

It is very likely that the issue is the fomatting of the timestamp. Paradox is very particular about timestamps and you have to match them exactly (include seconds, and AM/PM). Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[NotAllThere]

To help figure out where the problem lies, are you able to mimic the required filtered data by (temporarily) setting the filters in the form's data model? This should allow you to identify the exact filter data formats.

Padraig

 

[JBirdieH]

No, I am not able to set the filter interactively and have it work either. I've tried wildcards as well. The only thing that works is the date portion i.e.(2/1/01..) I've looked at the format in the table, exported it to look, changed the interactive format settings. Even tried a query with military time and I just can't get it.