I may need some help/advice for the following issue,
I have a database table with all kinds of sqlstatement in it, in order to show data from the database.
When I use any of the statements by clicking of them, and the executing needs a date then I always have to edit the statement.
I'll tryed to get a parameter in the staement bud always get an error.
PARAMETERS Begin Date; SELECT * FROM Customers WHERE DateMemberShip > # & Begin & #
this won't work, I almost explored the internet all day, found many items bud nothing specific for VB6, I have read my books, can't find a solution, this is driving me crazy.
Can someone please give me an example or a hint how to solve this
I'll try to acces an Access database using an ADO connection.
Thanks in advance
0 · ·