not supported functions  
Author Message
weedaviemolescroft





PostPosted: Tue Sep 23 11:00:27 CDT 2003 Top

Visual Basic >> not supported functions

What functions not supported in a SQL Query ?
I found the ReverseStr() and InstrRev().

Visual Studio2  
 
 
Al





PostPosted: Tue Sep 23 11:00:27 CDT 2003 Top

Visual Basic >> not supported functions Other than those functions described in ANSI SQL92/99, it will depend on the specific database and/or data provider you are using.

Al Reid


> What functions not supported in a SQL Query ?
> I found the ReverseStr() and InstrRev().
>
>


 
 
Bob





PostPosted: Tue Sep 23 10:57:00 CDT 2003 Top

Visual Basic >> not supported functions

> What functions not supported in a SQL Query ?
> I found the ReverseStr() and InstrRev().

Most VB functions are not supported; SQL queries are executed by the
particular backend database that is processing the query so Jet (Access) has
one set of functions, SQL Server has another, Oracle has another, etc.


 
 
Paul





PostPosted: Tue Sep 23 13:25:30 CDT 2003 Top

Visual Basic >> not supported functions

¤ What functions not supported in a SQL Query ?
¤ I found the ReverseStr() and InstrRev().
¤

If you're referring to an Access database, see the following:

Microsoft Jet 4.0 Expression Can Execute Unsafe Visual Basic for Applications Functions
http://support.microsoft.com/default.aspx?scid=kb;en-us;294698&Product=acc



Microsoft MVP (Visual Basic)