User created SQL queries

:wave:Hello fellowVBites:wave:

I am working with VB 6:rolleyes:

This is a very general query for me as I am quite new to it all:rolleyes:

Is there a way that sql queries can be user constructed ?
Is there a way that the user (unknowingly) creates the sql query at run time,as opposed to then just initiating a pre-written sql query .
I will try and explain as clearly as possible,so please dont run off into the mountains:D:D:D


The idea is that the user clicks into the menu in a ListBox,from this an sql statement is created,the relevent tables and fields are scanned and extracted and the result is placed onto a grid.

Lets say I have a small access database that gives me a table with the following fields used to gather info about marathon runs.
date
title
location
marathon title
number of entrants
distance
winner
second

I would then set up a series of ListBoxes to allow the user to query the database
I suppose the question I am asking is whether it is possible for the user(via some input mechanism like a list box) to be able to construct the sql query "on the fly".i.e a fresh sql query instituted into code everytime a series of requests were made by the user.

Is this possible??? or am I barking up the wrong tree:check::thumb::confused:
Kind Regards
Tommy:duck:

It certainly is possible - an SQL statement is just a string, so all you need to do is write code which builds the string as apt.

There is an example of how to do that in the "Further Steps" article of the FAQs (direct link in my signature), within the "Search" section.