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!

  • Congratulations gkittelson 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. ainsley

    Using a recordset to update when the source is more than once table

    Pete, The query runs and returns data in Query Analyzer. In the case above, it returns 1 record. Thanks for your suggestion though. The error is: Microsoft OLE DB Provider for ODBC Drivers error '80004005' When I looked this up under microsoft's help, it says that the solution is to use a...
  2. ainsley

    Using a recordset to update when the source is more than once table

    I am using SQL Server 7.0. I'm using inline sql to create the recordset and it doesn't have a group by clause, it is as follows: select sp.number, p.subCategory_Number, p.reference_Code, p.price, sp.graphic, sp.position, sp.page, sp.date_last_modified from tblSpecials sp inner join...
  3. ainsley

    Using a recordset to update when the source is more than once table

    Hi, I am trying to use ODBC and ASP with a recordset to update a record. The sql statement I used to create the recordset spans across two tables, that have a one to one relationship (this is created by the foreign key having a unique constraint). They are connected through an inner join in...

Part and Inventory Search

Back
Top