Search results for query: *

DISTINCT!!! That's it! Thank you.

Macleod: I would do this but I do not know how to set it up in code. I've seen examples of a stored procedure, but I don't know how to code it in VB Ron: Thanks for the links, but the NOCOUNT statement does not work in Pervasive SQL. Man, why did they have to use Pervasive??? I've seen so...

UH - NEVERMIND!!! Silly me. I was connecting to the wrong database :) Sure wish you could retract posts.

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

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

Sorry guys, but I've been out of the country for a while. PSQL is my acronym for Pervasive SQL, version 9.5. Anyway, I tried to set up the transaction but the select command doesn't fire until the transaction is committed, then it's too late for me to include the insertion of the detail...

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