Results 1 to 4 of 4

Thread: Sql adjustment for user input

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509

    Resolved 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:
    1. 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????????
    Last edited by snipered; Nov 21st, 2004 at 06:13 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width