Sorry I make mistake to write here I use this form cmd="SELECT * FROM NameDB WHERE lastname = """ & tbLastName.Text & """" showStatus cmd Set r=db.Execute( cmd) MsgBox & r &
How I get the result for this action? I use this database NameDB sample FirstName LastName Joe Bob Henry Bill Tedy Herman Thx for all EMERSON VIER --- In [email protected], Harold Wood <hwoody2w...@...> wrote: > > you need a properly formatted query. > > > "select * from [table name goes here] where [column name goes here] = '" & > tbLastName.Text & "'" > > --- On Wed, 5/20/09, EMERSON VIER <emersonv...@...> wrote: > > > From: EMERSON VIER <emersonv...@...> > Subject: [nsbasic-ce] SQL WHERE > To: [email protected] > Date: Wednesday, May 20, 2009, 10:16 PM > > > > > > > > > How I found the last name on the sample on TN15 > I try > > cmd="SELECT * FROM WHERE NameDB lastname = """ & tbLastName.Text & """" > showStatus cmd > Set r=db.Execute( cmd) > MsgBox & r & > > But this not return the line. > > EMERSON VIER > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nsb-ce" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en -~----------~----~----~----~------~----~------~--~---
