|
There are e lot of little difference between Oracle
sql sintax and Sap db sintax;
With Oracle
RS1.open "select max(to_number(cod_conto)+1) as
cod_conto from anacorg"
work.
with Sap sintax
RS1.open "select to_number(max(cod_conto)
cod_conto) from anacorg"
work.
What's correct sintax with Sap db
of
RS1.open "select max(to_number(cod_conto)+1) as
cod_conto from anacorg" If i have to extract sysdate with Oracle i
use
sqlString="select
substr(to_char(sysdate,'rrmmdd'),1,2) as
aa,substr(to_char(sysdate,'rrmmdd'),3,2)
mm,substr(to_char(sysdate,'rrmmdd'),5,2) gg FROM dual"
what's correct sintax with Sap
db?
|
