SYNTAX FOR REFERENCING SQL PARAMETER QUERIES

  • Thread starter Thread starter ROBERT MELLOTT
  • Start date Start date
R

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
 
Hello,

ROBERT MELLOTT said:
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
 
Back
Top