Is there an option to remove unnecessary bracket?

The following code

SELECT tbvilles.VilleID, tbvilles.Ville
FROM tbvilles
LEFT JOIN tb_lbxown_villessel
ON tbvilles.VilleID = tb_lbxown_villessel.VilleID
WHERE (((EXISTS(SELECT tb_dw_owner.villeid
FROM tb_dw_owner
WHERE tb_dw_owner.villeid = tbvilles.villeid)) <>False)
AND ((tb_lbxown_villessel.VilleID) IS NULL)
AND ((LEN([Ville])) >1)) ;

Will become:

SELECT tbvilles.VilleID, tbvilles.Ville
FROM tbvilles
LEFT JOIN tb_lbxown_villessel
ON tbvilles.VilleID = tb_lbxown_villessel.VilleID
WHERE EXISTS(SELECT tb_dw_owner.villeid
FROM tb_dw_owner
WHERE tb_dw_owner.villeid = tbvilles.villeid) <>False
AND tb_lbxown_villessel.VilleID IS NULL
AND LEN([Ville]) >1 ;

Thanks



Edited 1 time(s). Last edit at 12/27/2010 01:10PM by guidomarcel.

I have had varying results with the unnecessary brackets option within the tool. In an older version, it would sometimes change the results. In newer versions, it doesn't really remove them in an example such as yours.

This may be corrected in today's version.

Hi jcrane,
sorry for the late answer. I am still in holiday :-)

The removal of unnecessary bracket has mainly been designed for MS Access as its SQL generator adds many many unnecessary brackets. SQLinForm looks for double brackes like in the last line of your SQL:

WHERE
((A=)
AND 
(((C>D)))

and removes them so that it becomes

WHERE
(A=
AND 
(C>D)

In your code there are unnecessary brackets but they are not found by SQLinForm

Regards
Guido