group_concat

Databases
1

I try using group_concat in my Xojo code and it does not work. I try it SQLiteManager and it work fine. Any idea why??

2

group_concat ?
Never heard of it

EDIT : Had to google that one to see what it was
Never used it

3

It works for me. Show some code?

4

It works for me to.

5

strange… will put some code later

Norman, i discover this about 2 week ago and try out on sqlitemanager and try to use it yesterday on the code.

basically i want to show the the result of the SQL in a listbox. When i remove the new column with group_concat and the listbox show the result and when i include the group_concat, the result does not show up at all.

6

We use it and it works, so it’s likely to be a problem with your database code. Try putting a breakpoint in when you’re doing the SELECT statement, and seeing if any errors are returned.

7

ok… will try later…

8

just try group_concat today and it work great

9

what kind of things do you use group_concat for??