Hello Jason,

In fact (I forgot to mention), I need this works like an OR statement, and
not like an AND.

Something like this:

Select * from payments
where (pedido1_id=:wped_id)
or (pedido2_id=:wped_id)
or (pedido3_id=:wped_id)
or (pedido4_id=:wped_id)

[]s
Andrei



2012/12/11 IBO Support List <supportlist@...>

> I don�t see that making much sense.
> You will limit your query results in the detail by all 4 columns based upon
> that one single value.
> If this is what you actually want then go ahead and do that.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf
> Of Andrei Lu�s
> Sent: 11 December 2012 06:28 AM
> To: ibobjects@yahoogroups.com
> Subject: [IBO] Multiple MasterLinks fields
>
> Hello,
>
> I need to link 4 fields from one table to one field in another table.
> Untill today, I used only one field, like this:
> oci.pedido1_id=o.registro_id
>
>
> Is it possible to add something like this in MasterLinks property?
>
> oci.pedido1_id=o.registro_id
> oci.pedido2_id=o.registro_id
> oci.pedido3_id=o.registro_id
> oci.pedido4_id=o.registro_id
>
>
> []s
> Andrei
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]