A new UI component, called PowerFilter, is now available from PowerToTheBuilder.com.

PowerFilter is a powerful, easy-to-implement datawindow filtering component that provides users functionality similar to what is found in Excel 2007. Add one control to your window and 3 lines of Powerscript to implement.

Features Include:

• Dropdown checklist with unique values for each column. Check as many items as desired in as many columns as desired to define the filter.
• Custom Filter with pre-defined options based on datatype (Last Month, Next Month, Last Year, This Year, Greater than, Contains, Above Average, etc.)
• Supports Grid and Tabular DataWindows.
• Supports Columns and Computed Fields.
• Supports all standard data types.
• Supports custom column formats including format expressions.
• ...and much more.

 

 

Version 2.6.3 of the UI controls are now available for download. This release focuses on performance improvements and bug fixes.

You should now experience no flickering in the tab control and powerdock control. The buttonlistbar was enhanced a bit to make it perform a little quicker whan no image is specified for a button. The toolbar control had a bug that caused it to crash when resizing if there are items on both the left and right side.

Please let us know if you see any other issues or if you have an enhancement idea.

 

The Werysoft Team

Until Jan 30, 2010, Werysoft is offering the PB UI controls free to anyone who purchases a copy of QweryBuilder.

QweryBuilder is a database development and SQL query tool. Its purpose is to make accessing information from a database simple, quick, accurate and efficient. QweryBuilder implements innovative ideas to make this possible. An end user can extract and update data without writing a line of SQL. Database developers can create ad-hoc queries, procedures, tables, views and triggers with fewer keystrokes. Best of all, you can do this with your SQL Server, ASE, SQL Anywhere and Oracle databases in one single application.

If you purchase QweryBuilder and would like the PB UI controls, just send us an email with your QB license code. We will then email the PB UI Control source to you.

Thanks,

The Werysoft Team

Werysoft is very excited to announce the release of QweryBuilder 5.3.0.

5.3.0 contains some very significant changes. Prior versions had connection information on the applications main toolbar. This has been moved to the individual query windows. We felt that this made it easier to know which data source a query window was connected to. In addition to this, we concentrated on making this the most stable and bug free release to date. Our goal was to remove all bugs...and for the most part, we were successful. With that said, if you do find a bug we will fix it as quick as possible so please let us know about them.

Here are a few other things that we did in this release:

• Added better support for Vista and Windows 7. The application will now treat the Program Files directory as read only and put user generated files and data in the My Documents folder.
• Added multi-select functionality to the SQL editor.
• Support XML results in Sybase ASE and SQL Anywhere.
• Selecting numeric or date data in a result grid will now show more details about the data.
• Each SQL query window will now have an SQL History drop down.
• New updated look and new application icon.
• Better support for remote desktop.
• SQL editor syntax folding has been improved.
• Added more documentation to Werysoft.com.
  

 We are always interested in hearing from you. Please let us know what you think of the new QweryBuilder (through our survey, email or online forum). Please let us know if you find any bugs or any other issues.

Thanks,

The Werysoft Team

A new blog was created for Werysoft and QweryBuilder.

http://werysoft.blogspot.com/

2010 is going to be an exciting year for Werysoft. As you may or may not know, Werysoft produces products such as QweryBuilder and the PB UI Controls from PowerToTheBuilder.com. We used 2009 to build quality into our products. We just released a new version of the UI controls and by the end of this year we will put out a new release of QweryBuilder. This next release of QweryBuilder is especially important to us. We believe that the product has been brought to the next level with regards to performance, useablity and reliability.

In 2010, in addition to continuing our goal of building quality, we will be making our presence in the market much more prominent. QweryBuilder has had very little exposure yet it has become a success. We want to use this momentum to make it even more successful.

One of the things that makes QweryBuilder so great is the affordable price tag. Large IT Departments can use QweryBuilder for a flat price of $1500USD. This covers all your employee's (including your super users). Compare this to the competition and you will be saving tens of thousands of dollars. For smaller IT Departments, single licenses cost only $100USD. How many tools out there will give you productivity in SQL Server, Oracle and Sybase database's for that price?

Have questions? Please email us at Info@Werysoft.com. We look forward to hearing from you.

 

The Werysoft Team

With this release comes more toolbar enhancements. A new "Group" option has been added. This will allow you to group many toolbar items into one. An arrow will display next to the toolbar item. Once clicked, a drop menu will display all the toolbar items in that group. Clicking on one will envoke its clicked event and make it the default button on the group toolbar item.

This is how you use it. First you have to add a new group. Using the id's returned from of_AddGroup and of_AddItem, call of_AssignItemToGroup to put everything together. The of_SetGroupItem function will set the default button that's displayed in the group within the toolbar. If this method is not called, the last item added to the group will be displayed in the toolbar.

//Add menu toolbar items
Long ll_group, ll_b, ll_s, ll_o, ll_c
ll_group = uo_toolbarstrip.of_AddGroup()
ll_b = uo_toolbarstrip.of_AddItem('Blue','blue.bmp')
ll_s = uo_toolbarstrip.of_AddItem('Silver','silver.bmp')
ll_o = uo_toolbarstrip.of_AddItem('Olive','olive.bmp')
ll_c = uo_toolbarstrip.of_AddItem('Classic','classic.bmp')

uo_toolbarstrip.of_DisplayText(ll_group, TRUE)

//Assign new toolbar items to group
uo_toolbarstrip.of_AssignItemToGroup(ll_group,ll_b)
uo_toolbarstrip.of_AssignItemToGroup(ll_group,ll_s)
uo_toolbarstrip.of_AssignItemToGroup(ll_group,ll_o)
uo_toolbarstrip.of_AssignItemToGroup(ll_group,ll_c)

//Set the default group item
CHOOSE CASE uo_toolbarstrip.il_CurrentTheme
    CASE uo_toolbarstrip.BLUE
        uo_toolbarstrip.of_SetGroupItem (ll_group, ll_b)
    CASE uo_toolbarstrip.SILVER
        uo_toolbarstrip.of_SetGroupItem (ll_group, ll_s)
    CASE uo_toolbarstrip.OLIVE
        uo_toolbarstrip.of_SetGroupItem (ll_group, ll_o)
    CASE ELSE
        uo_toolbarstrip.of_SetGroupItem (ll_group, ll_c)
END CHOOSE

We're reaching out to our user base to see how we can improve our PowerBuilder UI product. In the last two months we have seen that the UI controls were downloaded nearly 1200 times. In this same two month period we have recorded approx. 3 new customers. What this tells us is that either a large number of the downloads are coming from people only needing this product for personal use or that this product does not add value to your applications.

It's the latter that we are concerned about. How can we make this library of UI controls better for you? From your perspective, what are its limitations?

We are very excited to hear from you and to get your thoughts on the matter. Please email us at Sales@Werysoft.com.

Thanks,

The Werysoft Team