I think in 1.8 can be done with http://www.hsqldb.org/doc/1.8/guide/g.. . .
Thanks Mariosv. I am a tenderfoot in macro, a newbie to sql, and a complete ignormaus in Java. I am trying to convert an A**S database with some rather sophisticated queries to Base. I need to create some simple routines, for example REPLACE, which exists in macro and apparently in Java (and some versions of sql, but not the embedded hsql). I am using the embedded DBMS (which may be the wrong approach) and I do not know how to incorporate this alias in the sql code, nor to use the alias.
I have run the following as a stand-alone sql command:
CREATE ALIAS FINDANDREPLACE FOR "java.lang.replace";
And, by analogy with other versions of REPLACE, I have tried to call it thus:
FINDANDREPLACE( "AddressA", 'St', "AddressB" )
Which produces this error message:
Access is denied java.lan.replace ...
Any advice? Alternatively I could write a function in hsql, but I don't know how to incorporate that in my sql code, either. I seem to have several half solutiond, but no result yet!
