OneWorks Business Solutions, Inc.

Question:

Hi,

I have a load all subfile in which i want to add search utility so that user can give a specific value at the top right of the screen and see the specific recerod.I mean subfile display should show the page starting by the record which he/she searched for..Any idea please

Thanks in Advance

Bikram (from IT Knowledge Exchange – itknowledgeexchange.techtarget.com)

Answer:

The best way to handle this is by using embedded SQL to load your subfile. When someone types search criteria in on the screen, you can rebuild your SQL statement with a where clause searching for the criteria entered on the screen.

Question:

Ravi Srinivas Ganti has written a basic cursor program in SQLRPGLE. The PF has records but strangely the FETCH is not fetching the records. The idea of writing this program is to make it a stored procedure so that the RPG call from Java would execute it and get the output displayed on a browser.

Answer:

Typically, this comes from the SQL statement not having the correct syntax. Put in debug and take a look at the generated SQL statement to see if it correct. More than likely, something is misaligned. Please post your code and I would be glad to take a look.

Steve and Chris in the middle of Time Square in New York.

We were back on the road again this week, spending a day in Providence, Rhode Island with the American Ring Company, Inc. The American Ring Company, Inc. specializes in supplying clients of varying sizes quality jewelry such as Belk, Dillard’s, JC Penny and Kohl’s. As a company that has traditionally spent most of our time in the southeast, its always a tremendous experience to be able to visit new areas and new industries.

Soon we are hoping to offer a new ERP experience that will change the way small businesses are able to interact with and manage their products and services within their business, as well as track their clients and inventory with advanced graphical reporting beyond what large scale ERP packages such as JD Edwards and HarrisData generally offer. For future details about our web-based ERP package, continue to check back with us via our website, or sign up for our mailing list at the bottom of this page.

The Key City Online Outlet is an e-commerce project that is currently still in the design phase. The above image is the most recent concept for the project.

Barstools Delivered was a concept we created for Boyles Furniture, who was looking for a concept e-commerce website to distribute their high-end line of bar stools. Unfortunately, the project has likely become a victim of the slow economy as furniture manufacturers have been hit especially hard.