Discussion Locked

SQL (RDC)

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello Everyone!!

I was just wondering if someody can help me!!!!!!

I want to know how can i transfer a textbox value to an SQL sentence on the Report Designer Component(RDC).

What i want is to get infromation from a table with a value typedin a text box.

Any help will be preciated
Thanks in advanced for all your help

5 replies

by bcgumbert

John,
Could you please email me a little more detail on your problem. It is a little to vague to determine what your problem is exactly. I am assuming you are trying to pass a variable to and SQL statement. What programming language are you using, what database backend and is this a n-tier application.
If you are refering to the data report in Visual Basic 6. It is for getting data out of a database not putting it into one. If you want to pass variables to a SQL string doing that from a form text box is relatively simple. The only question would be are you using stored procedures or embedded sql statements. The passing of variable is a little different in each case.
I may be able to help if I had a little more information to work with. please email me at bgumbert@woh.rr.com or repost the question with more information.

by kirkk

Here is how you would build the query string:

strSQL = "Select " & Request.Form("Textfield") & " from Table where..."

This appears on the "action=" page after submitting the form.

This discussion is closed to new replies.