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!

Search results for query: *

  • Users: allanhicks
  • Content: Threads
  • Order by date
  1. allanhicks

    Select record with nearest value

    I have a table with fields FA & FD where FA is a key field and FD is a date. I want to know how to select, via sql, one record for each available key where the date is closest to but not more than a specified date. eg if the table looked like: FA, FD 1, 01/01/2000 1, 30/03/2001 1, 21/09/2001...
  2. allanhicks

    DB2 Host Variables in Visual Basic

    Hi, Can anyone tell me if it is possible to use DB2 host variables in Visual Basic. I have searched the documentation but can only find examples for C++ & COBOL. If it is possible could you provide a code sample on how to utilise them. I have asked this in the DB2 forum but have received no...
  3. allanhicks

    DB@ host varaibles in Visual Basic

    Hi, Can anyone tell me if it is possible to use DB2 host variables in Visual Basic. I have searched the documentation but can only find examples for C++ & COBOL. If it is possible could you provide a code sample on how to utilise them. Thanks, Allan Hicks

Part and Inventory Search

Back
Top