2
I would like to know how best to work with abstraction of SQL in a multi-bank system.
For example:
Firebird: SELECT SUBSTRING(nome FROM 5 FOR 8) FROM clientes
Oracle: SELECT SUBSTR(nome,5,8) FROM clientes
How to make the application, after identifying which bank is being used, prepare the instruction SQL correctly?
I know there are several ways to do this. But technically what is the best way to do it or the most advised way?
Thank you for your answer, but in my search for the best way to do that, I would like to not have to write the same code twice. If you value security, I think your answer is the best one, but if you value the speed of development, it becomes complicated. But I think for now is what we can do.
– Andrey
Exactly, as there is no standard between the parameters of the "Abstraction" of the two mentioned banks there is no option, we have to write again! If a new alternative appears I edit the answer!
– Junior Moreira