I have a small table that contains the counties of California and Nevada.
The data will be used in a dropdown list. I intend to use the "State"
dropdown to trigger the setting of the where clause of the dropdown for the
counties.
My question what are your thoughts on the best way to filter the cursor based
on the selected state.
I see two ways. One using the dataset - something like
datasetCursor.execute ("select * from dataset where state = '%s'" %
(self.statecontID.Value))
Or I could set the where clause.
self.BizObj.setWhereClause("state = '%s'" %(self.statecontID.Value))
Your recommendations would be very helpful.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]