Re: Access BETWEEN statement seems faulty in VB.NET

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Cor,
You mention that it is best to use parameters, do you mean parameter
queries? If so could you explain why that is so?
I tend to create SQL strings and execute them, that way there is nothing in
the database itself that a user might delete and thus break the program
(note: I am building single user applications on non networked PCs so they
are just running a local copy of an MS Access database and a VB.NET
application) so that the setup is easy. All the users of the application
are completely non-technical so ease of setup is paramount.

--
Siv
Martley, Near Worcester, UK.
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:Ou8x9hqwFHA.3692@xxxxxxxxxxxxxxxxxxxxxxx
> Siv,
>
> In addition to the others,
>
> SQL statements are not a part of VB.Net itself.
>
> It is just given to the database to execute conform its standards and
> return a resultset.
>
> By the way, the method in Adonet is to use parameters.
>
> http://www.windowsformsdatagridhelp.com/default.aspx
>
> I hope this helps,
>
> Cor
>


.

Relevant Pages