Text Field dislikes Apostrophes??

Targets macOS
42

Looks good to me. Does it work?

43

Hold on - I will try :slight_smile:

44

Yes - that also worked :slight_smile:
Is there an advantage using one over the other?

45

You mean textfield vs listbox?

46

No - I mean:

Dim selected as string selected=Listbox1.cell(Listbox1.listindex,0) Dim ps As SQLitePreparedStatement = db.Prepare("SELECT * FROM snippets WHERE Title = ?;") ps.BindType(0, SQLitePreparedStatement.SQLITE_TEXT) ps.Bind(0, selected) rs=ps.SQLSelect

VERSUS

Dim ps As SQLitePreparedStatement = db.Prepare("SELECT * FROM snippets WHERE Title = ?;") ps.BindType(0, SQLitePreparedStatement.SQLITE_TEXT) ps.Bind(0, Listbox1.cell(Listbox1.listindex,0)) rs=ps.SQLSelect

47

Well they both do the same job. The second version is tighter and will run faster, but I doubt anyone would notice the difference in speed, so I guess it all comes down to your technique.

You might like to change this thread to general - it’s not really associated with OSX.

Go and have a good nights sleep - you deserve it after this.

48

I really appreciate all your help Wayne!