Return Home Members Area Experts Area The best AskMe alternative!Answerway.com - You Have Questions? We have Answers! Answerway Information Contact Us Online Help
 Thursday 8th January 2009 12:47:10 PM


 

Username:

Password:

or
Join Now!

  

Home/Computing Technology/Programming/Visual Basic
Forum Ask A Question   Question Board   FAQs Search
Return to Question Board

Question Details Asked By Asked On
"like" in sql statement, VB Meezan 08/09/04
    hi guys!

    I am using datagrid and a text field (as an LOV in oracle) for displaying multiple records. I am trying to filter the datagrid (bound with ADODC object) at run time under key press function of the text field. Here is the statement which gives error.

    Adodc3.RecordSource = "select * from item_info where item_name like " & "'" & sitem_name.Text & "'" & " % " & " order by item_name"

    Help.

    A quick response will be highly appretiated. If you are reading this question after a month of its posting, please dont bother cause by that time i would probably know the answer.

    Cheers,

    Ali

Summary of Answers Received Answered On Answered By Average Rating
1. Try it this way: Adodc3.RecordSource = "select * from it...
 08/10/04 ScottGemExcellent or Above Average Answer
Your Options
    Additional Options are only visible when you login! !

vq/Vi   © Copyright 2002-2008 Answerway.org. All rights reserved. User Guidelines. Expert Guidelines.
Privacy Policy. Terms of Use.   Make Us Your Homepage. Bookmark Answerway.