Sql adjustment for user input

Printable View

Nov 21st, 2004, 05:57 PM
snipered

Sql adjustment for user input
I am trying to allow the user to pick what they want to show from a database.

I use:
VB Code:
```
strsql = "Select '" & txtitems.Text & "' from Invoice;"
```
txtitems.text will actually equal * (all).

This brings up just on colomn in the ms flex grid field header expr1000 then it has many rows all with * in them.

When i replace the txtitems.text with *, it shows everything just as it should.

Is there a way that i can allow for the user to select the fields without giving me undesired effects????????
Nov 21st, 2004, 06:06 PM
David.Poundall
You need to drop the parenthasis. Use this
VB Code:
```
strsql = "Select " & txtitems.Text & " from Invoice;"
```
Nov 21st, 2004, 06:13 PM
snipered

thank you very much for a quick answer and a right one.
Nov 21st, 2004, 06:16 PM
David.Poundall

Personally I think SQL syntax sucks. I am always getting it round my neck as well. From many mistakes comes wisdom - or so they say. If that were true I would be a religious icon :bigyello: