CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Wishes

 Custom functions/procedures within the Visual Query Builder

Print topic Send  topic

Author Message
glerma

Posts: 56
Posted: 09/19/2006, 8:12 AM

Hi!

I would like to see an improvement to the "Add Function to SELECT" within the Visual Query Builder. (In case some people are wondering, this feature is available after right-clicking on any selected column within the Visual Query Builder).

I think CCS would be even more powerful if we were allowed to add ANY type of function, including custom functions built by myself for my projects. For example, I have created over 40 custom functions in my Oracle database, however I cannot select them within the Visual Query Builder.

I realize that Custom SQL is available, however it is much cleaner to use the Visual Query Builder whenever possible, to help keep coding consistency (less mistakes) and easier changes later in the development process. This is why I am requesting this feature.

Has this already been proposed for a future release? If not, please pass this on to you product planning or development team!

Keep up the good work!

Regards,
George Lerma 8-)
View profile  Send private message
WKempees
Posted: 09/21/2006, 12:56 AM

Glerma,

Good suggestion, second that.
Meanwhile did you know this one:
In VQB Table mode (just as you example)
Suppose you have some fields in the SELECT part, like id, name,
numberofparts
VQB give you the ability to add a function to a field by right clicking the
field and then offers some standard functions.
Now if you want you own functions used on a field, go to the lower right
pane of VQB
click the field you want the function on and type it there.
So right clicking the field numberofparts and selecting add function SUM
is in fact equal to clicking the field numberofparts in the lower right pane
and typing SUM(numberofparts)

even better
in an empty row you can type any valid funtion!

This goes for the Where as well enabling you to do sub-selects.

And I agree using VQB table mode is always to be preffered over SQL mode.


Walter


"glerma" <glerma@forum.codecharge> schreef in bericht
news:22451008c37d6a9@news.codecharge.com...
> Hi!
>
> I would like to see an improvement to the "Add Function to SELECT" within
> the
> Visual Query Builder. (In case some people are wondering, this feature is
> available after right-clicking on any selected column within the Visual
> Query
> Builder).
>
> I think CCS would be even more powerful if we were allowed to add ANY type
> of
> function, including custom functions built by myself for my projects. For
> example, I have created over 40 custom functions in my Oracle database,
> however
> I cannot select them within the Visual Query Builder.
>
> I realize that Custom SQL is available, however it is much cleaner to use
> the
> Visual Query Builder whenever possible, to help keep coding consistency
> (less
> mistakes) and easier changes later in the development process. This is
> why I
> am requesting this feature.
>
> Has this already been proposed for a future release? If not, please pass
> this
> on to you product planning or development team!
>
> Keep up the good work!
>
> Regards,
> George Lerma 8-)
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.