SQL IN clause with loadRecords

Classic Servoy
1

Hi everyone,

I’m having a bit of trouble with the following statement in Servoy 4.1.3, trying to load a foundset on a form:

var vSQL = 'SELECT po_li_id FROM po_li a ';
    vSQL += "WHERE a.qty_available >= 1 AND a.fk_product_id = " + vProductID;
    // Limit to the PO Line Items that are marked as available
    vSQL += " AND a.fk_po_id IN (SELECT b.po_id FROM pos b "; 
    vSQL += "WHERE b.i_available = 1)"; 
    forms.po_li_so_li_jt_list_available.controller.loadRecords(vSQL);

I’m trying to limit my foundset to line items linked to purchase orders marked as available. It works in Interactive Sql on Sybase, but in Servoy my method returns the same result, whether my purchase orders are available or not. Am I missing something? :?:

Thanks,

Ben

2

Sorry, false alarm - my form was being shown in a related tabpanel, which caused my SQL query to be ignored. :oops:

Removing the relation from the tabpanel fixed my problem and everything works like a charm, as one would expect from Servoy! Must be Friday… :)

Have a good one everybody,

Ben