Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 20 of 21 total |
A useful SQL function. |
Mon, Oct 9 2006 6:47 PM | Permanent Link |
"Ralf Mimoun" | 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 |
Mon, Oct 9 2006 6:48 PM | Permanent Link |
"Ralf Mimoun" | 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 |
Mon, Oct 9 2006 6:49 PM | Permanent Link |
"Ralf Mimoun" | 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 |
Mon, Oct 9 2006 7:12 PM | Permanent Link |
"Robert" | "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. |
Tue, Oct 10 2006 2:17 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Oct 10 2006 10:21 AM | Permanent Link |
Jon Lloyd Duerdoth | 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 |
Tue, Oct 10 2006 1:01 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Jon
In my case it was scientific calculations (chem eng) and a missing bracket in something nested about 20 deep. Roy Lambert |
Wed, Oct 11 2006 7:41 AM | Permanent Link |
Abdulaziz Jasser | 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. |
Wed, Oct 11 2006 8:24 AM | Permanent Link |
"Jose Eduardo Helminsky" | 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 |
Wed, Oct 11 2006 7:57 PM | Permanent Link |
"Ralf Mimoun" | 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 |
« Previous Page | Page 2 of 3 | Next Page » |
Jump to Page: 1 2 3 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |