Alpha Software is focused on enabling developers to create robust, data-driven business applications that run on any PC, Tablet or Smartphone in the fastest, most efficient and cost-effective manner possible.

Share this blog:

Showing posts with label Stored procedure. Show all posts
Showing posts with label Stored procedure. Show all posts

Wednesday, September 21, 2011

A few more of my favorite things ...

The other day, I listed a few of my favorite things, but did you think I would really end at the dialogue component in Alpha Five Version 11?

I'd love to dedicate a post just to Clifton, or maybe the game of cricket, but for now, I'm going to move on to our summary of my favorite features in Version 11's grid component.

The first feature I'm excited about is the alternate views for the Web Grid. The tabular and columnar views of a grid convey a lot of information, but the human eye is much more sensitive to shapes and colors than it is to variations in text.

So we thought that with an alternate view of a grid, you could display the same information in a way that will really grab the user. For example, if it's geographical information, the best display might be a map. If it's scheduling information, the best display might be a calendar.

Friday, December 10, 2010

How to call a SQL stored procedure with arguments

It seems like everyone has their own opinion about using stored procedures. And I'm not here to tell you what's right or wrong. I'm just bringing it to your attention because Alpha developer Bob Moore has created new videos showing you how to call a SQL stored procedure with arguments.

Why would you want to call a SQL stored procedure? Because it offers many benefits, such as reduced traffic between an application and the database server; increased app performance; it's reusable, transparent, and secure; and offers code management and access to expert level SQL programmers for distribution of the programming load. However, some developers argue against using stored procedures because it locks you into a SQL vendor.

If you're interested in learning more about stored procedures, watch Bob's two-part video. Part one covers the client-side JavaScript, the server-side Xbasic, and the T-SQL at the SQL Server. Part two discusses another option for passing arguments from JavaScript to the Xbasic callback function. It also includes a discussion of using Firebug for client-side debugging of Ajax callbacks.

Part one

Part two

Related Posts Plugin for WordPress, Blogger...