SAL Enhancements

forum.wishlist (1998-2005) & forum.gupta.wishlist (2005-2010)
Fridolin Schwarz

SAL Enhancements

Post by Fridolin Schwarz » 09 Apr 2004, 17:00

 Posted by:  Fridolin Schwarz 

I would greatly appreciate some of the following features resp. enhancements
of the SAL-functionality:

- datatype Integer
- private and public sections in class-definitions
- the possibility to define arrays with a constant length
eg: CONSTANT A_LENGTH = 5
NUMBER: naNum[LENGTH]
- a possibility to assign a complete array
eg: naNum = [ 3, 5, 7, 9, 8]
- the possibility to define Constants everywhere where I can define a
variable, as in Functions, Dialogs etc.
- a Case-Statement which accepts Constant-Expressions,
eg.
SELECT CASE nVar
CASE -1
.....
CASE 4 * A_LENGTH
.....
- a SqlPrepareAndExecute-Function which only Prepares And Executes my
statement.
eg: SqlPrepareAndExecute( hSql, 'SELECT "mörderisch lange Spalte" FROM
"Hölderlins umfangreiche Lieblingstabelle" INTO :nParMyValue ' ) shoult
yield an result set and not an error on a Oracle Database

- in SQLBase unnamed subqueries, or whatever this is called in Oracle or SQL
Server;
eg. SELECT x, y, COUNT(*) FROM (SELECT a+b as x, c*d as y FROM x_tab, y_tab
WHERE a=d)
GROUP BY x, y;

fritz

Jim McNamara

SAL Enhancements

Post by Jim McNamara » 12 Apr 2004, 16:44

 Posted by:  Jim McNamara 

function name with '__' (double underline) it will be 'hidden' from the rest
of the app.

code

negative #'s, non-integer values, and strings. An elegant series of IF
statements to handle those situations is a work-around to missing
functionality.

Fridolin Schwarz

SAL Enhancements

Post by Fridolin Schwarz » 13 Apr 2004, 12:09

 Posted by:  Fridolin Schwarz 


Have you ever seen something like " ..... WHERE int_col = CONVERT(INTEGER,
:NumberVar) " ?
Quite cumbersome, isn´t it?

Trying to hide functions with an underscore ist nothing more than a nice
try. It depends on other people pretending not to see them.

And, by the way, thank you for your assistance but this is, as I think, the
Whishlist-Forum, not the workaround forum. I am using SQL Windows for
several years now, and I think I have met a lot of workarounds, and Im
forced to use them; that´s my problem.

Just two new points that come to my mind:
- overloading of functions would be great ...
- Customizer was a real good invention! Information at your fingertip, where
did i hear this slogan. If I would like the ugly Attribute Inspector I
would prefer Visual Basic.

Thomas Lauzi

SAL Enhancements

Post by Thomas Lauzi » 13 Apr 2004, 16:06

 Posted by:  Thomas Lauzi 

I think it is a real advantage having only a datatype number.
If you have several datatype(int uint, long,byte...) you must have care
about conversion (to long, to int, to byte, .......).

It works very well I think, or what do you mean concret? What kind of
overloading?

Thomas L.

Armin Pokorny

SAL Enhancements

Post by Armin Pokorny » 13 Apr 2004, 16:37

 Posted by:  Armin Pokorny 


Function: NVL
Returns
Date/Time:
Parameters
Date/Time: d1
Date/Time: d2

Function: NVL
Returns
Number:
Parameters
Number: n1
Number: n2

Thomas Lauzi

SAL Enhancements

Post by Thomas Lauzi » 13 Apr 2004, 17:39

 Posted by:  Thomas Lauzi 

Polymorphic function or polymorphic overloading ? (I don´t like both)
What is the advantage you can also do it with objects as parameters, which
is IMHO clearer than with native datatypes.

Polymorphic overloading...
cBase:
Function: NVL
Returns
Date/Time:
Parameters
Date/Time: d1
Date/Time: d2
cDerived:
Function: NVL
Returns
Number:
Parameters
Number: n1
Number: n2

Polymorphic function with different parameters.
cBase:
Function: NVL
Returns
Date/Time:
Parameters
Date/Time: d1
Date/Time: d2
Function: NVL
Returns
Number:
Parameters
Number: n1
Number: n2

Martin Knopp

SAL Enhancements

Post by Martin Knopp » 13 Apr 2004, 20:13

 Posted by:  Martin Knopp 

Well there are pros and cons about function overloading.

Anyway I think anybody of us should always be careful to see that each new
feature adds complexity and "downgrades" SAL a bit from a 4GL to a 3GL.

I guess function overloading is one of the features that a good number of TD
developers

Martin Knopp

SAL Enhancements

Post by Martin Knopp » 13 Apr 2004, 20:22

 Posted by:  Martin Knopp 

sorry hit the wrong key before!

Well there are pros and cons about function overloading. Some like it some
not.

Anyway I think anybody of us should always be careful to see that each new
feature adds complexity and "downgrades" SAL a bit from a 4GL to a 3GL. And
Gupta has to consider that as well before adding new language features!

I guess function overloading is one of the features that a good number of TD
developers would probably find a bit confusing.

But the Integer datatype that you suggest would definitely be one of my
biggest favorites and I would see a need for private methods of classes as
well (this could make coding easier and more secure specially if you base
your applications on a framework).

Let me add one wish connected to private functions:

I would like to be able to "seal" functions for Step Into of the debugger.
This would be useful to avoid that "application developers" (those
developers writing the actual applications) step into methods of an
underlying framework which they would not like to see anyway. Maybe it would
be a nice idea to have two levels for the debugger (call it "application" or
"framework" or "standard" and "expert" or however) - if your IDE is
configered (I see this in the perferences dialog) on the lower level then a
Step Into does actually a Step Over if a method is marked as "framework" or
"expert" (depending how the levels are called). Default for new methods
would be the lower level so if you don't do anything special everything
behaves like today.

--
Martin Knopp, Dipl. Ing.

fecher GmbH
good people - good software

D'Orsay-Gasse 4/1
A-1090 Wien

Phone +43-1-3199124-0
Fax: +43-1-3199124-80
mailto:Martin.Knopp@fecher.at
http://www.fecher.at
------------------------------------------

Gerne informieren wir Sie über die folgenden spannenden Themen:

-- Cross platform development mit SQLBase und Team Developer für Windows
und Linux

-- buildingBLOCKS XP: Web Oberflächen mit ASP.NET und Team Developer

-- buildingBLOCKS JAVA: Schnelle Entwicklung offener browserbasierter
Geschäftsanwendungen

-- ENSEMBLE: Die Integrationsplattform für Ihre Geschäftsprozesse,
Anwendungen und Daten

Return to “gupta.wishlist”

Who is online

Users browsing this forum: [Ccbot] and 0 guests