Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tchristo

    re-add to an array from listbox

    Hi all, I've been able to get an array populated with a listbox in a form. But what I want to do is to keep adding to this array once the user has added more items to the listbox and clicked the "Add to Array" button again. I can't figure out how to store/remember the 1st set of items so that...
  2. tchristo

    select countries appearing in at least 3 of 5 tables

    Thanks, I've never used a union query before...that worked great!
  3. tchristo

    select countries appearing in at least 3 of 5 tables

    Hi folks, I would like to select countries that appear in at least 3 of 5 tables. These tables show the bottom 25 countries for different statistics (e.g. %poverty,%malnourished, etc.). The purpose is to find "the worst of the worst" countries. I can easily make a query that shows only those...
  4. tchristo

    inner join query problem

    Hello all, I've been trying to get hectares (ha) used in a calculation but first it has to be created from a square meters(shape_area) field. I've tried two options: 1.create ha calculation in initial select statement 2.create ha calculation within an inner join Neither options work. The first...
  5. tchristo

    slow connection speed on FIRST try

    Thanks for the suggestions. I'll take a look at the indexing and see if that will help. I've just begun experimenting with DB2 actually but the maintenance gets complicated because these are spatial databases that I'm working on. I'll test out the speeds on it though and see if there is a big...
  6. tchristo

    slow connection speed on FIRST try

    Thanks for the ?'s Sheco. It is a very big database (actually a GIS geodatabase) so it contains thousand of records for each query. Still, if I query one county the first time it will take a while (1min+). But then I can change the county name so it will be looking up different records and...
  7. tchristo

    slow connection speed on FIRST try

    Hello all, I've been reading all the info on the site about increasing the speed for displaying query results. Testing speeds AFTER the first time accessing a DB for all 3 connection types (listed below) seem about the same for speed. Also, the recordset.open versus recordset.execute seem about...
  8. tchristo

    for each rec: replace val in 1 field w/ val from other field

    Tony, Your first example worked great! Thanks a bunch, Treg
  9. tchristo

    for each rec: replace val in 1 field w/ val from other field

    Hi, I have a field with the same string value.... (a hyperlink actually, with this as the string: &quot;<a href= ../asp/query_cover.asp?WSD_size=6&WSD_code=020503 target=_blank><b>Run Query/View Chart</b></a>&quot;) ....copied to each record. For each record, I need to replace the part...

Part and Inventory Search

Back
Top