Display SQL results

[EscapeUK]

This is in VB. I have a a text box where I get the user to enter a SQL statement. I would then like to execute this and display the results in another text box.

 

[edderic]

???

Text2.Text = Text1.Text Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX.

Download Demo version on my Site:
Promotions before 02/28/2001 (free source codebook),visite my site

http://www.createsoftware2000.com

 

[EscapeUK]

how does that work?. All that does is display the SQL line that was type by the user.

I would like to run the line of SQL typed by the user and place the results in another text box

EG

Text1.text = Select * from Mytable

then in textbox2 i get results eg

fred bloggs 25, a new road
Paul Jones 33, a new street
Lucy smith, 21, a old road

 

[Guest_imported]

Forgot to say the it could be just about any SQL statement link to any table