Webspeed Newbie - Basic SQL Usage Question

Mr. Dobalina · Feb 19, 2009

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!

Cecil · Feb 20, 2009

Try using the ABL native query language rather that using SQL. I know this will be hard to shake off.

Code:

<TITLE>SQL example</TITLE>

<table border=1><tr><th>number</th><th>Name</th><th>Address</th></tr>

<SCRIPT LANGUAGE="Speedscript">
FOR EACH customer NO-LOCK
     BY customer.number:  [COLOR="SeaGreen"]/*Sort the list by customer number*/[/COLOR]
</SCRIPT>
     
<tr>
   <td>`customer.number`</td>
   <td>`customer.name`</td>
   <td>`customer.address`</td>
</tr>

<SCRIPT LANGUAGE="Speedscript">
END. [COLOR="SeaGreen"]/* End of the FOR EACH block....*[/COLOR]/
</SCRIPT>
</table>

webguy · Feb 21, 2009

Cecil is right try using native 4gl code. Once you get use to 4gl and webspeed you'll find you can whip stuff out pretty quickly.

Another way to do your example.

<html>
<head>
</head>
<body>
<table>

<tr>
<td>`customer.number`</td>
<td>`customer.name`</td>
<td>`customer.address`</td>
</tr>

</table>
</body>
</html>

agnaldo.macedo · Feb 21, 2009

Try Flex.

It is much more interesting than just using HTML / Ajax.

Examples:

http://starweb-software.no-ip.info:8000/ex010/

http://starweb-software.no-ip.info:8000/ex020/

http://starweb-software.no-ip.info:8000/ex030/

http://starweb-software.no-ip.info:8000/ex040/

Casper · Feb 21, 2009

That's an interesting way of answering two entirely different questions....

(http://www.progresstalk.com/showthread.php?t=114845)

agnaldo.macedo · Feb 21, 2009

Are no different.
Both have the same problem.
4GL generating HTML as the interface layer.

Using Flex, note the complete separation between screen and 4GL.

Webspeed Newbie - Basic SQL Usage Question

Mr. Dobalina

New Member

Cecil

19+ years progress programming and still learning.

webguy

Member

agnaldo.macedo

New Member

Casper

ProgressTalk.com Moderator

agnaldo.macedo

New Member

Similar threads