[Gambas-user] How to write sql query in gambas way

[Safiur Rahman]

Hi

That cannot be the answer. The array can be of variable count and count may
go to twenty or thirty.

On Mon, 9 May 2022, 21:40 Safiur Rahman, <isafiur at gmail.com> wrote:

> Hi
>
> I get result when I execute the following query:
>
> Dim res As Result
>   res = conn.Exec("select fldtitle from tbltest where flddepartment
> in('Austria','Azerbaijan')")
>
> But I don't get result when I execute the following query:
> res = conn.Exec("select fldtitle from tbltest where flddepartment in &1",
> ["Austria", "Azerbaijan"])
>
> How can I write this query properly in gambas passing an array argument?
>
> (Attached a project to demonstrate)
>
> --
> Regards
> Safiur Rahman
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20220510/de7101f1/attachment.htm>