AW: SQL from Search calcaultion

[Rudolf Bargholz]

Hi Jim,

You could try the following:

WHERE
(
  (FAGL_Type='B' and FATG_TYPE like '%BJ%')
  OR
  (
    ((FATG_CREATOR='A' or FATG_CREATOR='TA') and FATG_TYPE like '%DFR%' and FATG_TYPE_2='P' )
	OR
	(FATG_TYPE like '%EI%')  
  )
)

At least this might give you a starting point to test the SQL.

Regards

Rudolf Bargholz

-----Ursprüngliche Nachricht-----
Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> Im Auftrag von Jim Creak
Gesendet: Dienstag, 4. August 2020 07:11
An: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Betreff: SQL from Search calcaultion

Hi,  I’ve got a question here for the SQL gurus who have some time on their hands :)

I’ve got a search statement that I use in my search routine for Classic that I would like to see if I can get into SQL for OmnisSQL any one up for the challenge?

Here is the Search line

	pick(FAGL_Type='B',pick(FATG_CREATOR='A'|FATG_CREATOR='TA',pos(FATG_TYPE,'EI'),pos(FATG_TYPE,'DFR')&FATG_TYPE_2='P'),pos(FATG_TYPE,'BJ')>0)

Remember, this is into OmnisSQL, not standard SQL :)

Thanks
Jim

JACSoft Programming Ltd. <http://www.jacsoft.co.nz/main.shtml>
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com