Hi to all.
I’m new here and am coming to you from Melbourne Australia.
So a big
HELLO 2 ALL.
Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at home.
My problem is that it’s driving me NUTS NUTS NUTS.
I am connected to a data connection within my computer that accesses tables & views from a MS Access file.
I have achieved the connection and can run the SQL builder without problems.
My problem is that I CAN NOT, NOT, NOT! Create parameter queries within the SQL builder environment contained in VB.
I should say that I am most comfortable & qualified as a developer in MS Office applications namely Access & Excel and have some VB qualifications as well.
In Access a parameter query is fundamental & easy to achieve.
When I create a parameter query in SQL builder & try to use a placeholder as an unnamed parameter I get this message saying something like this.
“Unable to derive parameter info from provider!”
I have used the help files extensively. I follow the steps but still receive this message.
I am aware of creating parameter characters in the criteria column & indeed the help files recommend using the “[ and ]” characters as parameter placeholders.
But regardless of what characters I use as place holders I can run a parameter query in the SQL builder of VB!
I can successfully run hard coded queries like searching for surnames Where surname like ‘[b]’%
This returns all records within the criteria of surnames starting with b or B.
But when I try to do what even the help files recommend, syntax like
Where surname =?
I get PROBLEMS.
Can anyone PLEASE HELP.
Thanx heaps.
:confused:
I’m new here and am coming to you from Melbourne Australia.
So a big
HELLO 2 ALL.
Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at home.
My problem is that it’s driving me NUTS NUTS NUTS.
I am connected to a data connection within my computer that accesses tables & views from a MS Access file.
I have achieved the connection and can run the SQL builder without problems.
My problem is that I CAN NOT, NOT, NOT! Create parameter queries within the SQL builder environment contained in VB.
I should say that I am most comfortable & qualified as a developer in MS Office applications namely Access & Excel and have some VB qualifications as well.
In Access a parameter query is fundamental & easy to achieve.
When I create a parameter query in SQL builder & try to use a placeholder as an unnamed parameter I get this message saying something like this.
“Unable to derive parameter info from provider!”
I have used the help files extensively. I follow the steps but still receive this message.
I am aware of creating parameter characters in the criteria column & indeed the help files recommend using the “[ and ]” characters as parameter placeholders.
But regardless of what characters I use as place holders I can run a parameter query in the SQL builder of VB!
I can successfully run hard coded queries like searching for surnames Where surname like ‘[b]’%
This returns all records within the criteria of surnames starting with b or B.
But when I try to do what even the help files recommend, syntax like
Where surname =?
I get PROBLEMS.
Can anyone PLEASE HELP.
Thanx heaps.
:confused: