newbie questions

• • Reply

  19 years ago

  by UltimateWilliam

  UltimateWilliam

  , United States

  Joined 19 years ago

  hi all!
  

  
  how would i check if recordsets returned is empty or has no record?
  

  
  how would i search a particular record with a primary key in recordsets? (the search value will come from a variable or any value entered by the user on  a text box or any control. . .)
  

  
  how would i  know if the search is successful?
  

  
  any equivalent inlist() function in vb? e.g. if inlist(country,"Japan","Australia","US")
  

  
  in some programming language, i can do this in a case statement. . .
  

  
  do case
  case color="brown"
   ...
   ...
  case number="999"
   ...
   ...
  case name="Maria"
   ...
   ...
  endcase
  

  
  if any would come true then execute the succeding code. is this possible with the select case of vb?
  

  
  thanks a lot!

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  To check if a recordset is empty (or you have reached the end of it after calling .MoveNext), simply check the EOF property:
  Set objRS = objConn.Execute(theSQL)
  If objRS.EOF Then
    'no results
  End If
  

  
  for inlist(country,"Japan","Australia","US") , you have to loop through all the items in an array, and then check if the strings match. If you mean to check if a string is within another, use the Instr statement
  

  
  > if any would come true then execute the succeding code. is this possible with the select case of vb?
  I presume you mean that in, for example C++, if you omit break;, it will execute the next case statement. In VB it is not possible to replicate this behavour, unless you use a Goto statement (very ugly!)

  Report abuse
• • Reply

  19 years ago

  by CodeWarrior76

  CodeWarrior

  Calgary, CA, United States

  Joined 19 years ago

  VB Web said:
  

  Quote:

  do case
  case color="brown"
  ...
  ...
  case number="999"
  ...
  ...
  case name="Maria"
  ...
  ...
  endcase

  
  

  
  Actually using this Select case you can come close
  

  
  select case true
  case color is "brown"
  ...
  ...
  case number is 999
  ...
  ...
  case name is "Maria"
  ...
  ...
  end select
  it just evaluates the statements to see if they are true.

  Report abuse
• • Reply

  19 years ago

  by UltimateWilliam

  UltimateWilliam

  , United States

  Joined 19 years ago

  got them all except for the array thing. . . storing the values on an array before comparing a string variable if it exists in that array would be a tedious job to do.
  

  
  in visual foxpro: inlist(strCountry,"America","Japan","Australia") returns true (.T.) if it finds the expression in the set of expressions. i hope vb has this kind of function or any similar function that would work like this. . .
  

  
  thank you all!

  Report abuse
• • Reply

  19 years ago

  by CodeWarrior76

  CodeWarrior

  Calgary, CA, United States

  Joined 19 years ago

  To my knowledge, I don't believe VB has a function like that.

  Report abuse
• • Reply

  19 years ago

  by UltimateWilliam

  UltimateWilliam

  , United States

  Joined 19 years ago

  then i'll use instr()....
  

  
  thanks.

  Report abuse