The blogger at Slapout Tech recently worked on a PowerBuilder Project with an SQL server. He's compiled a few tips for if you ever come across a similar project on Single Quoted Strings, Identity Columns, Bit Fields, and Files Required.

Check out the full article on Slapout Tech

---

This is day 5 of the 100 days of PowerBuilder and its helping to organise PBLs. "... Establishing a uniform structure to the contents of your PBLs which applies across the applications you develop is much more important in terms of lessening the learning curve for new developers and improving maintenance activities. Most applications which are at least ten years old have a hodge-podge of PBLs loosely organized at best. Many may have had better structure but over time entropy took control, especially when the initial developers moved on to something else, and there was no longer anything other than individual discipline keeping things organized. The two types of sturctures I advocate are Object Centric and Module Centric."

Read more on the Anvil of Time

---

Here's an article with a very interesting discussion on HTML5. In this article Bruce Armstrong clarifies his position on the latter, and having PowerBuilder support for HTML5. He has published various articles discusing the latest revision of HTML. "I do not believe that HTML5 is currently a mature technology suitable for the generation of enterprise line of business applications. It may be in a few years, it currently isn't."

Read more here

---

The schedule for May has been posted on the PBTV site! Including a sneak peek at Appeon Mobile as well as our first ever PBTV webinar with Bruce Armstrong! You can now sign up for three upcoming sessions:

1) How to make your application multilingual with Enable 5.0
2) Appeon Mobile Sneak Peek
3) How to develop Multithreaded applications with PowerBuilder with Bruce Armstrong

Sign up here

?

---

Looking for some interesting debates on the future of PowerBuilder? LinkedIn discussion forums are surprisingly fruitful! Vote on what topic you think would be great for a next PB book, or have your say on the future of telecommuting and PB developers. You can check this out and more on the link below (you will need to create a LinkedIn profile to be able to post a response)

 

---

This post comes from the SlapOut Tech blog, he wanted a comprehensive PB color chart so he created his own My PowerBuilder Color Chart, he then "wanted an easier way to specify a color. So [he] created a new function, f_color. You pass it one of the PowerBuilder color names and it will return the proper number. For example, our alternate row highlighting expression now becomes:
if (mod(getrow(), 2) = 0, f_color("White"), f_color("Gray"))
Plus, you can now do things like use Transparent and the Window colors:
if (mod(getrow(), 2) = 0, f_color("Transparent"), f_color("Button Face")) Check out the rest of the post here

---