By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,524 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,524 IT Pros & Developers. It's quick & easy.

What is the best way to build a where clause and where to build it

P: n/a
I have a form wich on the first tab I have two list boxes one populated
with the available fields to put in where statement and when they are
duoble clicked they go into the second list box. up to nine can be
selected.

On tab two I show the fields selected, followed by a combo box where
they can select the operator, then a box for the paramter.

Now somehow I need to get this data to create a dataset for a crystal
report. Should I build the SQL statement and send it thru as
commandtext and fill a dataset, or should I pass the field, operator
and parameter to a stored procedure and bind the Crystal report to the
store procedure. Does anyone have an example?

Thanks,
Phillip Putzback

Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.