PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WEBDEV 2024 → Querys using linked id fields for the filtering part
Querys using linked id fields for the filtering part
Started by Diego Sanchez, Jun., 11 2013 6:36 PM - 1 reply
#1
Registered member
39 messages
Posted on June, 11 2013 - 6:36 PM
Hi all !

I am trying to create a query that receives several parameters, the parameters are linking ID fields from other tables, but I need them to be optional, I have setup the query conditions as Table.aID = {paramone} AND Table.bID = {paramtwo} how can I have them to be optional ?

--
Diego Sanchez
Tecnoinformática S.A.
#2
Posted on June, 13 2013 - 8:40 PM
Hi Diego

if you set a query parameter to NULL, it is ignored by the query

Best regards


--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

New web site (EXPERIMENTAL) http://www.fabriceharari.eu
(More information on http://www.fabriceharari.com)


On 6/11/2013 10:36 AM, Diego Sanchez wrote:
Hi all !

I am trying to create a query that receives several parameters, the
parameters are linking ID fields from other tables, but I need them to
be optional, I have setup the query conditions as Table.aID = {paramone}
AND Table.bID = {paramtwo} how can I have them to be optional ?

--
Diego Sanchez
Tecnoinformática S.A.
→ Go back to WEBDEV 2024