Skip to main content

I am used to a different form of SQL from another ERP…

I am finding some reports that have been written already for us have strange syntax

 

 

what does this sumbol do :  “

for example:

select “ field2,

           'Draft' field3,

        ''  engagement_id,

 

I have tried to do a search on IFS quick report selects with “ in the code but nothing is returned.

To that point - is there a nod page - whereby we can see all the additions / allowable features as I also found the use of (+) which is a short cut to left outer join. How can I know the full list of such ‘syntax features’ for use in my quick reports/understanding existing written queries in IFS SQL please.

Thanks

i have made a rookie error in that - the syntax is actually two single quotations - so there is nothing being selected to an alias target field that will appear in the report and that is extracted to file.

 

how do i delete or remove this post. it is no longer relevant as i have understood what i was originally questioning.

thank you.

Reply


Terms & ConditionsCookie settings