Roy Lambert wrote:
> But why not simply
>
> Query.SQL.Add('SELECT FirstName + QuotedStr(' ') + SecondName
> +QuotedStr(' ') + LastName FROM Table1');

The Delphi comiler will not eat this code.

Ralf

Abdulaziz Jasser wrote:
> Roy & Ralf,
>
> I use QuotedStr to do the trick with DBISAM version 4 (Still
> evaluating and making the conversion from 3 to 4), but I didn't know
> that I can
> use "quote quote space quote quote" to do the same thing.

It's that way since Pascal 1 or so...

> Although
> this would make REPEAT function does the trick, but I still see SPACE
> function is more easy and direct?

Of course, but you must admit that it's not that urgent anymre. Almost like
wanting a RepeatD function that saves you the fist parameter of REPEAT,
using the character D.

Ralf

Abdulaziz Jasser wrote:
....
> More SQL functions usefully give more power to the SQL engine
> and make the user's life easier.  

And make the DBISAM SQL dialect less compatible.

Ralf

"Ralf Mimoun" <nospam@rad-on.de> wrote in message
news:C8B6D8F7-FDDE-47D9-8631-6BC13466B4C7@news.elevatesoft.com...
> Roy Lambert wrote:
>> But why not simply
>>
>> Query.SQL.Add('SELECT FirstName + QuotedStr(' ') + SecondName
>> +QuotedStr(' ') + LastName FROM Table1');
>

He's missing the quote after each string part as in  'SELECT FirstName' +
etc . But I for sure don't want any non-standard SQL, unless it is something
that is REALLY fantastic and can't be done other ways.

Robert


>He's missing the quote after each string part as in 'SELECT FirstName' +
>etc

Dead right - the difference between knocking up code in a text editor and for real

Roy Lambert

Ah yes... the days of punch card programming... submit the
job and "oops" a missing (....fill in the blank....)  

Jon

Roy Lambert wrote:
> Robert
>
>
>> He's missing the quote after each string part as in 'SELECT FirstName' +
>> etc
>
> Dead right - the difference between knocking up code in a text editor and for real
>
> Roy Lambert

Jon


In my case it was scientific calculations (chem eng) and a missing bracket in something nested about 20 deep.

Roy Lambert

Ralf

<<Of course, but you must admit that it's not that urgent anymre. Almost like
wanting a RepeatD function that saves you the fist parameter of REPEAT,
using the character D.>>

It wasn't urgent from the moment I posted this thread.  But it was good to have the SPACE function especially when it comes to use REPEAT with
those ugly quotes.  SPACE function would have being better and simple.


<<And make the DBISAM SQL dialect less compatible.>>

Are talking about being ANSI compatible?  Being ANSI compatible is not the key to success.  Also, do not try to limit your productivity to ANSI
standers.

Ralf

I understant your point but Oracle does not think like that.
Standards are good way to follow but I think adding proprietary functions
will improve DBISAM features a lot.

BTW, the upcomming ElevateDB has the ability to add functions according
developer wishes.

Eduardo

Jose Eduardo Helminsky wrote:
> Ralf
>
> I understant your point but Oracle does not think like that.

DBISAM is not Oracle. I will run and hide if it it becomes only slightly
similar. Every single Oracle proejct has a huge problem: Oracle.

> Standards are good way to follow but I think adding proprietary
> functions will improve DBISAM features a lot.

We are talking about a single parameter, which is realls simple to remember
and to type. If there is a really good idea for a function, and if there is
no equivalent in the wildlife, then of course add something propietary. But
for REPEAT?

> BTW, the upcomming ElevateDB has the ability to add functions
> according developer wishes.

There is a huge difference between propietary functions I add to the engine
because I need them in a project and propietary functions that are part of
the out-of-the-box system.

Ralf