ExecuteHTML question

[Ricky D]

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]

Are you referring to StringArgs parameter?
It allows you to make parameterized queries.
This is the relevant code:

   If StringArgs <> Null Then 
      cur = SQL.ExecQuery2(Query, StringArgs)
   Else
      cur = SQL.ExecQuery(Query)
   End If

 

[Ricky D]

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]

Sure.

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))