by a PHP Application i want to update a dataset inside a Progress-Table, that is working generally.
But it is possible to work on the same dataset inside our EPR-System that locks the dataset. Now when i want to update the dataset this i get this error.
I have a Progress DB as an ODBC source which i export data from to allow transformation and then import into a SQL DB.
I would like to import cleansed data back into my Progress DB (update is most important but insert/delete could be useful too)
Does anyone have experience of doing...
I have a client in Houston that has an immediate need for someone with experience supporting Infor SX Enterprise and Progress databases. Any coding/customization experience is a plus but at this point I want to talk to anyone interested in a fulltime job focused on SX.e with a great company...
we are getting this error while we running below query in progress11 through odbc tester tool.
Error :-[DataDirect][Odbc Progress openedge wire protocal driver][openedge]Too many Values Specified (7531)
SUBSTRING(g."Account#",(((select sum(ss.Seg_Len) from hrdb.ab_cd_Def ss...
We can connect sql explorer through proenv cmd prompt in progress, for single database by using below syntax
sqlexp –char –S port –H hostname –db database –user username –password pwd.
but, how can we connect mutiple databases in sqlexplorer of Progress 9.1e. ? Actually i need to write...
Please excuse my ignorance in regards to nomenclature here, I am brand new to Progress.
I need to pull some data from a progress database (Openedge 10.2) in which the table is storing Binary image files and move it into a SQL . The files are split off into multiple chuncks. From what I have...
Hi to all of you.
I need an help about SQL Function IFNULL
I need to test if a date is NULL, if not i need to obatin that date in the field, otherwise i need to put a dummy date..
Ex. IFNULL (prezzi.duc , '2000-01-01')
I write from Italy , is it correct to put '2000-01-01' to have...