QBE in DevForce?
Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=261
Printed Date: 11-Jun-2026 at 7:46am
Topic: QBE in DevForce?
Posted By: Customer
Subject: QBE in DevForce?
Date Posted: 16-Jul-2007 at 10:41am
| Is the Query By Example (QBE) control that was available in Ideablade available in DevForce? |
Replies:
Posted By: IdeaBlade
Date Posted: 16-Jul-2007 at 10:43am
|
The control is not available; however we do make the QBE object model available as source code. It's non-trival to develop a fully general UI for QBE. I've attached a solution (which includes the QBE source) wherein I tried, but stopped short of providing a satisfactory interface for the IN query operator. Other than that it seems to work, though it has certainly not been extensively tested. My own conclusion from that work was that, for most applications, one is better off making a few simplifying assumptions, and not trying to achieve quite so general a solution. That seems to have been the general conclusion of those who worked on the original QBE control, too.
|
Posted By: m2r4miller
Date Posted: 20-Sep-2007 at 1:36pm
|
Would it be possible to get a copy of the QBE code you are referring to?
Thanks!
Mark Miller
mailto:mark@msdcweb.com - mark@msdcweb.com
|
Posted By: Edhy
Date Posted: 15-Feb-2008 at 1:45pm
|
Hi,
Could you please send me a copy of that solution?
Why IdeaBlade is not providing a general class for this type of need, since in my experience with my applications, they all have the need to retrieve a subset of the data instead of getting all the data like you do in the training videos?
So I believe that in most cases many of the maintenance forms will need some sort of QBE form to allow the user to get the data they want to work with in those forms.
Edhy!
|
Posted By: GregD
Date Posted: 15-Feb-2008 at 5:27pm
|
Could you please send me a copy of that solution?
>>
Why IdeaBlade is not providing a general class for this type of need, since in my experience with my applications, they all have the need to retrieve a subset of the data instead of getting all the data like you do in the training videos?
So I believe that in most cases many of the maintenance forms will need some sort of QBE form to allow the user to get the data they want to work with in those forms.
<<
We do provide it, we just don't really promote it, as we discovered that doing QBE in a very general way gets too complicated for most people's tastes.
Please contact IdeaBlade support directly via email (support@IdeaBlade.com), and they'll see that you get a copy.
Greg Dunn
Training and Documentation Manager
IdeaBlade
|
Posted By: Edhy
Date Posted: 15-Feb-2008 at 6:33pm
|
Hi Greg,
Thanks for the information.
I am new to .NET but a Visual FoxPro experience developer and at this point I am taking the time going into the massive and impressive documentation for DevForce and of course all the videos available.
Looking at the PT6-AddDeleteWithBindNav video I noticed that some custom code is required in order to have these Add/Delete functionality in synch with DevForce and noticed that you don't have a BindingNavigator subclass which provide the code needed by DevForce. Why don't you have a set of subclasses of the .NET controls to accomodate the required DevForce code?
My question goes toward the need to re-use those kind of control in many forms and then have to make the same modification to the BindingNavigator control every time, or is this something that an experience .NET can take care easily?  ------------- Edhy Rijo |
Posted By: GregD
Date Posted: 18-Feb-2008 at 9:00am
|
The only configuration you really have to do on the BindingNavigator itself is the setting of the two properties that link the default handlers for the AddNewItem and DeleteItem buttons, i.e., MyBindingNavigator.AddNewItem = null;
MyBindingNavigator.DeleteItem = null;
By turning the default handlers off, the BindingNavigatorAddNewItem and BindingNavigatorDeleteItem buttons just become ordinary buttons to which you can assign actions. I think we would likely have little success trying predict what behavior our customers want behind the Add and Delete buttons.
Greg Dunn
IdeaBlade
|
Posted By: Edhy
Date Posted: 18-Feb-2008 at 9:11am
|
Thanks. ------------- Edhy Rijo |