When i switch my programe from oracle into sybase, The content in the config files:
db.FieldDict.criteriaKey.createStatement.sqlStatement=\ insert into FIELD_DICT (FD_ID,NAME,LENGTH,NOTE) \ values (FDSEQ.NEXTVAL,{NAME},{LENGTH},{NOTE} ) db.FieldDict.criteriaKey.createStatement2.sqlStatement=\ select FDSEQ.CURRVAL as FD_ID from DUAL db.FieldDict.criteriaKey.createStatement2.isQuery=true
the sequence FDSEQ cannot been used here.
How can i use the similar function in sybase?
Log in to post a comment.
When i switch my programe from oracle into sybase,
The content in the config files:
db.FieldDict.criteriaKey.createStatement.sqlStatement=\
insert into FIELD_DICT (FD_ID,NAME,LENGTH,NOTE) \
values (FDSEQ.NEXTVAL,{NAME},{LENGTH},{NOTE} )
db.FieldDict.criteriaKey.createStatement2.sqlStatement=\
select FDSEQ.CURRVAL as FD_ID from DUAL
db.FieldDict.criteriaKey.createStatement2.isQuery=true
the sequence FDSEQ cannot been used here.
How can i use the similar function in sybase?