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...@yahoo.com.br> wrote: From: EMERSON VIER <emersonv...@yahoo.com.br> Subject: [nsbasic-ce] SQL WHERE To: nsbasic...@yahoogroups.com 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 nsb-ce@googlegroups.com To unsubscribe from this group, send email to nsb-ce+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en -~----------~----~----~----~------~----~------~--~---