Beja Expert Licensed User Longtime User May 15, 2014 #1 Hello friends, I need the b4a implementation of the SQL statement above: criteria = EditText1.Text .RecordSet = "Select * from records where RecID = '" & criteria & "'" Thanks in advance.
Hello friends, I need the b4a implementation of the SQL statement above: criteria = EditText1.Text .RecordSet = "Select * from records where RecID = '" & criteria & "'" Thanks in advance.
JakeBullet70 Well-Known Member Licensed User Longtime User May 15, 2014 #2 B4X: dim criteria as string = EditText1.Text dim cur As Cursor cur = SQL.ExecQuery2("select * from records where Recid = ? ",Array As String(criteria)) Upvote 0
B4X: dim criteria as string = EditText1.Text dim cur As Cursor cur = SQL.ExecQuery2("select * from records where Recid = ? ",Array As String(criteria))
Beja Expert Licensed User Longtime User May 16, 2014 #3 Hello JakeBullet70, Thanks for your quick help.. tried it. no error at all (de, also no filtering..) Upvote 0
JakeBullet70 Well-Known Member Licensed User Longtime User May 16, 2014 #4 what filtering do you want? Upvote 0
DonManfred Expert Licensed User Longtime User May 16, 2014 #5 Sure there is a filtering B4X: where Recid = ? Upvote 0