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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FindNext

Status
Not open for further replies.
SweetDot

SweetDot

Technical User
Jan 19, 2004
65
US
Hi
I'm trying to search for a record using the findnext method...
and here is my code
strSearch = "FLIGHT_NUMBER='0002' and AIRLINE_ID='ACA' AND BOUND='A' AND CITY_CODE1='YVR'"
TerRec.FindFirst strSearch

somehow the noMatch property is always true even though I know that the record exists...
i've tried to break it down and add in one search element at a time...and so far the flight number, airline_id and bound work...but as soon as i add in city code, it doesn't work anymore...
does anyone know what's wrong with that search string?

thanks in advance
 
Sort by date Sort by votes
This appears to be an ADO question, not a direct SQL Server question.

You'll have more luck asking in the VB forum.

Cheyney
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top