Larry,
Thanks for the input. While this in being implemented in a 7.5 app (scheduled to be converted to v8), I did test in v8 and found the same behavior. Since the COUNT = LAST does give a message that it is not supported on server tables, it could be logical that the COUNT = INSERT would likely be the same. I have implemented a MAX statement with where clause and it works well. I will give Dennis' suggestion of the TOP command. I have not used it yet, and if it is faster, it will be even better. Thanks all, -Bob ----- Original Message ----- From: "Lawrence Lustig" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, May 10, 2010 11:02:01 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - Re: Confirm Where count = INSERT << I imagine the syntax is not supported on an ODBC table like the above "LAST" clause, but it just does not return an error. >> That's entirely possible but, just to be sure, check the ODBC driver version you're using. COUNT = INSERT is a (relatively) recent addition to R:Base, if you're using an older ODBC driver it might predate the COUNT = INSERT syntax. -- Larry
