Ricky D Well-Known Member Licensed User Longtime User Jan 21, 2012 #1 there is a parameter in the function that is a list. Does anyone know what this is used for? Any code I've seen sets it to null. I can't find any documentation on this.
there is a parameter in the function that is a list. Does anyone know what this is used for? Any code I've seen sets it to null. I can't find any documentation on this.
Erel B4X founder Staff member Licensed User Longtime User Jan 22, 2012 #2 Are you referring to StringArgs parameter? It allows you to make parameterized queries. This is the relevant code: Code: If StringArgs <> Null Then cur = SQL.ExecQuery2(Query, StringArgs) Else cur = SQL.ExecQuery(Query) End If Upvote 0
Are you referring to StringArgs parameter? It allows you to make parameterized queries. This is the relevant code: Code: If StringArgs <> Null Then cur = SQL.ExecQuery2(Query, StringArgs) Else cur = SQL.ExecQuery(Query) End If
Ricky D Well-Known Member Licensed User Longtime User Jan 23, 2012 #3 Umm Hi Erel, I understand that part - but I haven't seen any code anywhere use it - so I can't see what you do with it. Can you show me some working code that doesn't have it as null? All code I've seen sets it to null regards, Ricky Upvote 0
Umm Hi Erel, I understand that part - but I haven't seen any code anywhere use it - so I can't see what you do with it. Can you show me some working code that doesn't have it as null? All code I've seen sets it to null regards, Ricky
Erel B4X founder Staff member Licensed User Longtime User Jan 23, 2012 #4 Sure. Code: Dim MaxPrice As Int MaxPrice = 23 WebView1.LoadHtml(DBUtils.ExecuteHtml(SQL, _ "SELECT ProductId, Name, Price WHERE Name = ? OR Price < ?" _ , Array As String("abc", MaxPrice), 0, True)) Upvote 0
Sure. Code: Dim MaxPrice As Int MaxPrice = 23 WebView1.LoadHtml(DBUtils.ExecuteHtml(SQL, _ "SELECT ProductId, Name, Price WHERE Name = ? OR Price < ?" _ , Array As String("abc", MaxPrice), 0, True))
