I use to use characters strings as my primary keys, but now I would like to use integer keys. With characters strings as my PKs, I was able to set up a parameterized view that would let me select either one record or all records from a table. If I wanted one record, I would set my view paramter like this:
lcJob_ID = "00001"
before I required the view. If I wanted all records, I would set the paramter like this:
lcJob_ID = SPACE(0)
Can I do the same thing if I use integer PKs?
BTW, the US Women's soccer team rocks!
Chris McCandless
Red Sky Software