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 <[email protected]> wrote: From: EMERSON VIER <[email protected]> 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 -~----------~----~----~----~------~----~------~--~---
