SelectSQL/ExecuteSQL with array parameter

Databases
1

In this thread, we have discovered that the array version of SelectSQL and ExecuteSQL won’t compile. You get the error “There is more than one method with this name but this does not match any of the available signatures.” Works fine of course with a paramarray (comma-delimited list of parameters).

Has anyone gotten this to work? I don’t recall seeing any issues with it during the betas.

2

Filed <https://xojo.com/issue/57929> for this.

3

I can’t reproduce this, works just fine here.

dim params() as variant
params.AddRow 1

dim r as RowSet = db.SelectSQL("SELECT 1 FROM claim WHERE id = $1", params)
db.ExecuteSQL "SELECT 1 FROM claim WHERE id = $1", params
4

[quote=458796:@Kem Tekinay]I can’t reproduce this, works just fine here.
[/quote]
I found the problem. Bobby’s code defined the sql variable as Text instead of String. I had just copied his code and didn’t catch that. It appears that Text auto-conversion confuses the compiler in this situation.

5

Hi Jay. ahhh. Great discovery of Text / String. I just uses Text more and more, if I need to make common modules between iOS / Desktop.