[WD] SQL Query one EDT control for four SQL parameters?

Hello everyone

I need to do a search in one of my applications based on SQL queries. I placed the fillers on four columns in the parameter table. The client's requirement is that it can search all four queries from one Edit control. Search first the first parameter if it does not exist search the second parameter, if it does not exist search the third parameter and then the fourth. How do I set up a query and search loop? Has anyone had a similar task?

[infosonline.net]

if the same value is not in all four column, then a simple OR query will do

select x from xxx where col1=value or col2=value or col3=value or col4=value

If the same value CAN be found in different column and your description implies an EXCLUSIVE search (ie if found on first column, do NOT look also for it in second column), then a succession of four simple queries with a test if something is found between each will do the work

Hello Argus

I solved the problem as follows

QRY_QUERY.Param1 = EDT_XXX
IF HExecuteQuery(QRY_QUERY,hQueryDefault) THEN
	QRY_QUERY.Param2 = EDT_XXX
	IF HExecuteQuery(QRY_QUERY,hQueryDefault) THEN
		QRY_QUERY.Param3 = EDT_XXX
		IF HExecuteQuery(QRY_QUERY,hQueryDefault) THEN
                        Process....
			HFreeQuery(QRY_QUERY) 
		END
		Process....
                HFreeQuery(QRY_QUERY) 
	END
        Process......
	HFreeQuery(QRY_QUERY) 
END

[infosonline.net]



Edited 1 time(s). Last edit at 06/07/2022 11:45PM by infos.