OpenROAD - SQL Functions

[Pete.Wilkinson]

are there any plans to introduce the many new SQL date, string, & numeric functions into OpenROAD? Some of them would be very useful to have built into OR.

And whatever happend to the 'Language Elements' chapter of the LRM, which used to feature such things, which seems to have gone AWOL since we lost the printed versions of the manuals?

[Bodo]

are there any plans to introduce the many new SQL date, string, & numeric functions into OpenROAD? Some of them would be very useful to have built into OR.

You can use them in SQL (e.g. within SELECT statements), provided the Ingres version you use supports them. We plan to add them to the 4GL language with a future (OR 6.x) version.

And whatever happend to the 'Language Elements' chapter of the LRM, which used to feature such things, which seems to have gone AWOL since we lost the printed versions of the manuals?

I admit that this somehow disappeared. You should open a ServiceDesk issue to open a docu bug for it.

[kschendel]

I'm no OpenROAD expert, but you might try quote doubling, i.e.

query1='select ... ... where left(tar_cod,1)=''E'' and ...

to write a single quote inside a quoted string, double it.

[giessel]

as I find the quotes sometimes confusing, I'm using hc_quote instead

select ... ... where left(tar_cod,1)='+hc_quote+'E' + hc_quote +' .....

[kschendel]

Since :query1 must be an executable sql statement, try putting a print statement in to display exactly what is in that string, and see if you can execute the same thing in the terminal monitor. Do this with your original, apparently the quoting isn't the problem. You need to find out exactly what is being sent to the DBMS server.