Mr. Dobalina
New Member
Greetings All,
I am new to WebSpeed. In my previous life I did ASP.Net with C#, ASP, JavaScript, etc. Database work with Teradata, DB2, SQL Server.
Basically, I'm having the same trouble with 4GL as a 4GL guy would have with SQL Server.
We are on OpenEdge 10.1B. I am looking for a way to maximize my productivity by integrating some basic SQL when developing Webspeed pages. We currently haven't fully adapted AppServer, but are working primarily with inline scripting 4GL.
I've used the desktop application to pull data w/basic selects, and performance is good when written appropriatly. My problem is integrating into pages as I've had a hard time finding examples. (and I've seen posts where people highly recommend against it, but I am hoping that this is because they were on previous versions of Progress.
Can someone help me with a basic example of pulling data with a SELECT statement and displaying that data in a table on the web? The only example I've found uses speedscripting and performes very poorly. A statment that runs in 1 second on my desktop takes 10 to return via the web.
http://www.geocities.com/ResearchTriangle/3737/dlc/sql.html
Any assistance is greatly appreciated!
I am new to WebSpeed. In my previous life I did ASP.Net with C#, ASP, JavaScript, etc. Database work with Teradata, DB2, SQL Server.
Basically, I'm having the same trouble with 4GL as a 4GL guy would have with SQL Server.
We are on OpenEdge 10.1B. I am looking for a way to maximize my productivity by integrating some basic SQL when developing Webspeed pages. We currently haven't fully adapted AppServer, but are working primarily with inline scripting 4GL.
I've used the desktop application to pull data w/basic selects, and performance is good when written appropriatly. My problem is integrating into pages as I've had a hard time finding examples. (and I've seen posts where people highly recommend against it, but I am hoping that this is because they were on previous versions of Progress.
Can someone help me with a basic example of pulling data with a SELECT statement and displaying that data in a table on the web? The only example I've found uses speedscripting and performes very poorly. A statment that runs in 1 second on my desktop takes 10 to return via the web.
http://www.geocities.com/ResearchTriangle/3737/dlc/sql.html
Any assistance is greatly appreciated!