SYNTAX FOR REFERENCING SQL PARAMETER QUERIES

[ROBERT MELLOTT]

I am currently using VB 6.0 so I hope someone out there
can help me.
All I need is the proper syntax to reference the paramter
in a SQL query.
Here is my problem.
I created a dataenvironment called: dataenvironment1.
I then created a command called: command3
The command is a SQL query; INSERT INTO ControlTable
VALUES (?,?). The SQL builder gives the parameters the
names; param1 and param2.
Here is the problem, My freind gave me this line of code
in order to update the fields by using the parameters
referenced in the SQL query:
dataenvironment1.command3.parameters("param1").value= var1

The only problem is that this syntax does not work and I
cannot find the current usage in order for the program to
work.
At present I get an error saying that parameters is not
defined.
All I need is the current syntax to swap out the value
from var1 and insert into parameter1 (param1).
I would be greatful for any help anyone can give me.
Thank you.
Robert Mellott

 

[Armin Zingler]

I am currently using VB 6.0

This is a VB.NET group. Please turn to one of the microsoft.public.vb.*
groups.

 

[Herfried K. Wagner [MVP]]

Hello,

I am currently using VB 6.0 so I hope someone out there
can help me.

This is a VB.NET language group. Please turn to the ng mentioned below:

news://news.microsoft.com/microsoft.public.vb.database

HTH,
Herfried K. Wagner