[Gambas-user] Issue 446 in gambas: Select statement returns no data

[paulwheeler]

Thank you,

That worked.

However, when I uncommented the tvwInventory load code a few lines down, 
I now get a "Bad Row Index" message.

Not sure how tvwInventory[iCounter, 0].Text with iCounter equal to 0 can 
be a bad row, but that is what it says!


I took the exact same code from another section that is loading the 
exact same tableview, and it works perfectly fine!


How is this possible?


P
On 06/25/2013 04:28 PM, gambas at ...2524... wrote:
> Comment #1 on issue 446 by ea7... at ...626...: Select statement returns no
> data
> http://code.google.com/p/gambas/issues/detail?id=446
>
> I think you have to get rid of single quotes in the nested query. Try this
> as:
>
> Select * From Inventory Where InventoryId In (Select InventoryId From
> Topics2InventoryXref Where TopicId = 18)
>
> Regards
>
>