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 dencom 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: rbyrne1
  • Content: Threads
  • Order by date
  1. rbyrne1

    ODBC Error Message

    I am using VB.2005 to access a Pervasive SQL 9.5 database and I'm getting the following error: ERROR [42S02] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]No such table or object. ERROR [HY000] [Pervasive][ODBC Client...
  2. rbyrne1

    Pull from Two Tables

    I have two tables as follows: CUSTOMERS customernum customername ORDERS ordernum customernum partnum "SELECT customers.customernum, customername, ordernum FROM customers, orders WHERE partnum=123 and customers.customernum=orders.customernum" I'm trying to pull a recordset of all customers...
  3. rbyrne1

    Insert New Row and Retuning IDENTITY Value

    I am attempting to write code that should perform the following: - insert a new data row into the ORDERS table - obtain the new IDENTITY field value (the field name is actually "ordernum" but it is an identity field type) from the ORDERS table - insert data row(s) into the ORDERSDET table with...

Part and Inventory Search

Back
Top