Hmmm. Now I'm scratching my head.
Also, in the 'Advanced' tab what is the call syntax?
Could this be your error?
> The last line is the one that bombs. I'm sure the variables are
> 'Grab Index number picked by the operator
> Merge_Index = DataEnvironment1.rsMergeTable.Fields
> 'All other values as entered by operator
> Reference_No = CInt(TxtReferenceNo.Text)
> DataEnvironment1.testinsert (Merge_Index, Reference_No )
> I've tried to explicitly enter variables, ie;.....
> DataEnvironment1.testinsert ("4", "12345")
> and tried without parenthesis. It just doesn't make sense.
> The SQL looks like this;.....
> INSERT INTO Package(Merge_Index, Reference_No) VALUES (?, ?)
> The parameter properties are correct, in the DataEnvironment. I can
> either one, but like I said earlier, when more than one parameter is
> it bombs.
> > The compile error tells me something else is going on. Can we see
> > exact line that is failing? Perhaps you are using a reserved word
> > some invalid way.
> > > I can insert (1) parameter and it works fine, but when there are
> > or more
> > > I get a VB Dialog when the cursor rolls off the line of code;
> > > Compile Error
> > > Expected: =
> > > This works....
> > > DataEnvironment1.MyNewRecord(Variable1)
> > > but this does not...
> > > DataEnvironment1.MyNewRecord(Variable1, Variable2)
> > > Yes, intellisense prompts me.
> > > > You are close, very close..
> > > > Did you try something like..
> > > > DataEnvironment1.MyNewRecord("Mike", "Council", 1999)
> > > > The VB intellisense should have been prompting you as well.
> > > > But maybe something else is going on here..
> > > > > I have set up an insert query with parameters via the Data
> > Environment
> > > > > designer and despite my best efforts can't seem to find any
> > (concise)
> > > > > documentation on how to pass data into the parameters on the
> > side
> > > > and
> > > > > update the DB record.
> > > > > Command name is MyNewRecord
> > > > > INSERT INTO MyTable(Field1, Field2, Field3) VALUES (?, ?, ?)
> > > > > Parameter names : Param1, Param2, Param3
> > > > > VB stuff: DataEnvironment1.MyNewRecord()
> > > > > Where do you go from here?
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Sent via Deja.com http://www.deja.com/
Before you buy.