Is this wrong?

Kelly,

Yes!

And you can omit the „con” function since the inbuilt „$select“ method of the table class does a „con” by default:

Do iProdRow.$select(‘WHERE prod_id=’,iLineItemsList.line_prod_id) Returns #F

Best,

Andreas

> Am 01.03.2018 um 03:43 schrieb Kelly Burgess <kellyb@montana.com>:
>
> Hi Das,
>
>> Do iProdRow.$select(“WHERE prod_id='[iLineItemsList.line_prod_id]'”) Returns #F
>>
>> Is there something wrong with my usage of row/column inside square brackets as shown?
>
> Yes – because the square brackets are part of a string value, they won’t get evaluated.
>
> I’d try this instead –
>
> Do iProdRow.$select(con(‘WHERE prod_id=’,kSq,iLineItemsList.line_prod_id,kSq)) Returns #F
>
> Or without those kSq’s, if iLineItemsList.line_prod_id is a numeric value.
>
> Kelly
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com