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 IamaSherpa 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. oldboy

    SELECT fails if TOP 10 added to query

    Thanks for suggestion but CONTRACT_NO is correct and even replacing * with field names does not work. I have got round the problem by changing the select clause to SELECT * FROM WBS_TRANSACTIONS WHERE THIS_RECORD = 1. This removes the delay. I wonder if it is something to do with Sage's ODBC driver.
  2. oldboy

    Run time error 2147217904 "Too few parameters"

    My program works ok in office but on site fails. Problem traced back to the Data Environment Provider. Upto now I have used Microsoft Jet 4.0 OLE DB Provider with Connection "E:\Databases\JobInfo.mdb" Using this all works OK but of course on site the database has a different path. So...
  3. oldboy

    SELECT fails if TOP 10 added to query

    If I simply use SELECT * FROM WBS_TRANSACTIONS the resultset opens but as there are several thousand records it takes sometime. So as all I want to do is add a new record I tried the following SELECT TOP 10 * FROM WBS_TRANSACTIONS ORDER BY CONTRACT_NO DESC This produces an Error 40002...

Part and Inventory Search

Back
Top