progress

  1. B

    How to find out if record is locked

    Hello community, 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. SQL error...
  2. S

    Update records in Progress DB using SSIS

    Hello, 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...
  3. B

    MultiThread

    Hi everyone, While working and developping more and more with progress, something came to me. When I have a huge request on Win's starting the window go on a no responding by windows. So is it possible to run the windows on a thread and all the querry work/calcul/process on another thread ...
  4. B

    Question How to move a window to the top

    Hi guys, I'm working on a multi-window application. This is my scenario: From my main window (we will call it "parent", I run another one (we will call it the "child") with the persistent option. The user can hide the child behind the parent and forget he already launched the child. DO...
  5. Sayanil Datta

    Getting frequent errors from SQL Server 2016 while connecting to progress database using openedge driver

    Getting frequent errors from SQL Server 2016 while connecting to progress database using openedge driver: 1)An error occurred while preparing the query "Select * from XXXX where XXX.XXXXX='XXXXXXX'" for execution against OLE DB provider "MSDASQL" for linked server "ProgressDB". 2)Cannot execute...
  6. M

    Question Set Statement With Editing Block (mfg/pro)

    I am using QAD-MFG/PRO in .NET windows version. I have a frame in which the fields are array elements. During the code execution, the frame is populated with the current field values in database. Hence, the scrolling function enabled for the these fields will start the scroll from current value...
  7. N

    Question Openedge Software Support

    Hi everyone - I am evaluating different software platforms and I wanted to see how well OpenEdge compares to other offerings in the marketplace. Curious to see how the company has done in terms of investing in the product - do they provide relevant updates to the software as well as support...
  8. H

    Limiting Connections To Progress Database

    Hello, I wonder if anyone can help? I've written a Microsoft SSIS package to export data from two Progress databases (10.2 and 11.3) that connects via an ODBC 11.3 driver to export data into SQL Server. However, the Progress administrator contacted me to let me know that on several occasions...
  9. H

    Limiting Connections To Progress Database

    Hello, I wonder if anyone can help? I've written a Microsoft SSIS package to export data from two Progress databases (10.2 and 11.3) that connects via an ODBC 11.3 driver to export data into SQL Server. However, the Progress administrator contacted me to let me know that on several occasions...
  10. J

    !!! Sx.e Job Opportunity !!! Houston, Tx

    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...
  11. D

    Question How To Calculate Distance Between Zip Codes

    Unix v11.3 I am in need of calculating the distance between two zip codes. I have all the zip codes and longitudes / latitudes data. Does anyone have code that does this? I figured I'd check here before starting to dig in.
  12. G

    Question Slow Database In New Server

    Hi, recently we change our databases to a new server but the startup and the queries are extremely slow, even tho the hardware is better than before. We lack knowledge about databases, we manage our clients services and remote connection as well as other services but we do not know about...
  13. P

    Question Experience With Data Protector

    I 'm looking for people with experience of data protector Data Protector is a plugin to write Progress backup directly to TSM . All I can find is the supplier documentation
  14. N

    Support For Utf-8 Using Progress Data Server For Oracle

    I am using progress 10.2B with Oracle 9i as back end DB with use of progress data server for oracle. I created one schema holder and started it with parameters "-cpinternal UTF-8 -cpstream UTF-8 -cpterm UTF-8 -cpcase Basic -cpcoll basic". Now I am connecting same schema holder and Oracle DB...
  15. J

    Materialized Views In Progress

    Hi, Is it possible to create materialized views in progress openedge. if it is possible, how can we create it. please suggest me. thanks.
  16. R

    Editable Multiline Frame ?

    Hi guys, i would like to make a editable frame over temp-table...is it possible? I have temp-table with oreders - and i would like to display 10 orders in one frame and update one logical field..is it possible thru frames with DOWN or is it possible only with query with BROWSE? Thanks Rumi
  17. N

    Error While Resolving The Issue

    Hi all, I have an isuue, can anyone help me buddy. with the concern explaination Requirement: 1) To delete terminated orders codes from requested status of active order records,These are appearing while doing the active orders. 2) Also, Need to prevent the system from selecting the...
  18. J

    Too Many Values Specified (7531) Error

    Hi, 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) Query : select SUBSTRING(g."Account#",(((select sum(ss.Seg_Len) from hrdb.ab_cd_Def ss...
  19. J

    Mutiple Database Connect Using Proenv Command Prompt In Progress 9.1e

    Hi, 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...
  20. J

    Reg Expressions In Progress

    Hi, Is Progress 9.1e support regular expressions. Actually i need to divide the Account Number in different parts based on regular expression pattern, how can i do this in progress 9.1e? if progress supoorts reg expressions, please give me the guidance to use reg expression in sql query. Thanx.
Top