[Gambas-user] DataSource.Table = SELECT...

[Gianluigi]

Il giorno ven 1 mag 2020 alle ore 19:20 T Lee Davidson <
t.lee.davidson at gmail.com> ha scritto:

>
> On a Wordpress database, I was able to use the following successfully:
> "SELECT option_id, option_name AS my_name FROM wp_options order by
> option_id asc"
>
>
So if I understand correctly, you did something like this:

DataSource1.Table = "SELECT option_id, option_name AS my_name FROM
wp_options order by option_id asc;"

And the data source showed you the ordered result in a grid with my_name
header.

Thanks you have been very helpful.
Regards
Gianluigi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20200501/0e0a28e6/attachment.html>