Parameter Queries / Data Enviroment window 
Author Message
 Parameter Queries / Data Enviroment window

Help!!!!!!!!

I am trying to use the new data environment to build queries to SELECT
information from some ORACLE database tables. Here is my problem when I
build my SQL statement, either by hand or with the sql builder I get an
error.

This is my statement and parLastName is the parameter I want to
substitute for.
SELECT FIRST_NAME
FROM USERS
WHERE (LAST_NAME = [parLastName])

The error
The provider cannot derive parameter info and SetParameterInfo has not
been called.

What do I do? I have exhausted the books online and documentation about
parameter queries and cannot find the answer.

Please respond to my email as well as the groups.

Thanks in advance,
Bart Ross



Mon, 09 Apr 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Parameter Queries / Data Enviroment window

2. How to Query on Data Enviroment based data form

3. Passing Parameters to stored parameter queries using VB 5's Data Controls

4. Editing data in a parameter query in Data Environment

5. Editing Data in a Parameter query built in the Data Environment

6. calling parameter query from a parameter query

7. VB6 Data Enviroment, Link 2 MDB data.

8. VB6 Data Enviroments to Data Reports w/ SP's

9. I can't add a Data Report or a Data Enviroment or DHTML

10. VB6 Data Enviroment, Link 2 MDB data.

11. Help - VB Data Report and Data Enviroment

12. data enviroment and data report

 

 
Powered by phpBB® Forum Software