I have never used a database in rb, and don't use them much in general,
but it looks to me like
'titleField.text' shouldn't be in quotes?
Regards,
Jon Daniels
On Tuesday, February 26, 2002, at 04:58 PM, Danandjulies at aol dot com wrote:
OK, here's my delima. I've got an application that I use to maintain an
inventory of my dvds. cds etc... I've got the db thing working great and
I've
got a listbox that will display all the info in the db. My problem is, I
want
to be able to search for a dvd by entering the title in an editfield. I
want
the search to be accomplished with a pushbutton. I've got the
databasequery
bound to the listbox, but I can't get the sqlselect from where to work.
It's
either not working, or my listbox isn't displaying the info. heres the
query
Select * from dvd where title ='titleField.text'
the action event for the pushbutton is
databasequery1.runQuery
The binding for the databasequery to the list box is
bind listbox1 with list data from databaseQuery1 results
is there something that I'm missing?
Is it possible to to use the editfield this way, or do I have to convert
the
text from the editfield to something else before the databasequery can
use it
in a search?
Thanks
Dan
---
Subscribe to the digest:
<mailto:realbasic-nug-digest at lists dot realsoftware dot com>
Unsubscribe:
<mailto:realbasic-nug-off at lists dot realsoftware dot com>
|