L
lgbjr
Hi All,
I need some advice. I have a table in MSDE2000 with about 3 million records.
It's a city database. What I want to do is have 3 comboboxes on a form. The
first would be to select a country, second, to select a region (state,
province, etc) in that country, and the third would be a list of cities in
the selected region.
I don't want 3 million records in my dataset, but I can't figure out how to
set things up so that I'm only getting the records I need. The table has
several columns: Index, CountryCode, Country, RegionCountry, Region, City
(example: 1, US, United States, PA, US, PA, Philadelphia)
I'm using VB 2005 (for now) and I can't figure out how to setup a set or
queries that will give me the data I want without loading all of the records
into the record set first. If I setup queries in the DB, they need to be
parameterized, and I also can't figure out how to do that, but I think
that's the only way that I can keep from having all the records in the table
loaded into my dataset.
Can someone provide me with a bit of guidance?
thanks!
Lee
I need some advice. I have a table in MSDE2000 with about 3 million records.
It's a city database. What I want to do is have 3 comboboxes on a form. The
first would be to select a country, second, to select a region (state,
province, etc) in that country, and the third would be a list of cities in
the selected region.
I don't want 3 million records in my dataset, but I can't figure out how to
set things up so that I'm only getting the records I need. The table has
several columns: Index, CountryCode, Country, RegionCountry, Region, City
(example: 1, US, United States, PA, US, PA, Philadelphia)
I'm using VB 2005 (for now) and I can't figure out how to setup a set or
queries that will give me the data I want without loading all of the records
into the record set first. If I setup queries in the DB, they need to be
parameterized, and I also can't figure out how to do that, but I think
that's the only way that I can keep from having all the records in the table
loaded into my dataset.
Can someone provide me with a bit of guidance?
thanks!
Lee