SQL Functions

Posts   
 
    
jeffreygg
User
Posts: 805
Joined: 26-Oct-2003
# Posted on: 12-May-2004 21:14:36   

I don't suppose there's anyway to construct a predicate using a SQL function such as datediff, is there?

Jeff...

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 12-May-2004 22:05:39   

Not at the moment. (will come with the next runtime update, together with count etc. ). If you want, you can write your own predicate class, like the one in the runtime library sourcecode, (FieldCompareValue() for example). It requires a couple of functions to be implemented. If you need help on this, let me know.

Frans Bouma | Lead developer LLBLGen Pro
jeffreygg
User
Posts: 805
Joined: 26-Oct-2003
# Posted on: 13-May-2004 18:18:49   

Thanks, Frans!

Jeff...

takb
User
Posts: 150
Joined: 12-Mar-2004
# Posted on: 14-May-2004 03:15:09   

Otis wrote:

...will come with the next runtime update, together with count etc. )...

Is the "next runtime update" in your June timeframe?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 14-May-2004 09:49:50   

June-july. First some database drivers will be created. The GUI is done, I now have to alter some templates and a beta will be released. The coming month is for drivers, then a new runtime update is planned.

Thanks to the fine folks at the MS Winforms team I lost 2 weeks because of unfixable bugs in the winform controls rage so I had to replace a lot of controls with 3rd party controls. But that's done now...

Frans Bouma | Lead developer LLBLGen Pro
vikramka
User
Posts: 42
Joined: 08-Sep-2004
# Posted on: 29-Nov-2004 17:57:10   

Are there any sql date functions yet in llblgen?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 29-Nov-2004 18:21:09   

No, except the aggregate functions like SUM, AVG etc. Function support is planned for the next designer upgrade.

Frans Bouma | Lead developer LLBLGen Pro
vikramka
User
Posts: 42
Joined: 08-Sep-2004
# Posted on: 30-Nov-2004 03:35:46   

thanks. I look frwd to it.

Its been my first project with llblgen pro. I had been using the older llblgen before. Its been smooth sailing, easyto understand and pickup. keep up the great work!!

gfunny
User
Posts: 20
Joined: 21-Apr-2005
# Posted on: 21-Jun-2005 21:51:33   

Are DateFunctions coming out soon? DatePart etc?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 22-Jun-2005 10:57:24   

They're on the list though it depends on how much time there is left when the major features for 1.0.2005.1 are done. The key aspect of these functions is that it's hard to get a generic way of defining them in C#/VB.NET code without having to type a lot.

Frans Bouma | Lead developer LLBLGen Pro
omar avatar
omar
User
Posts: 569
Joined: 15-Oct-2004
# Posted on: 22-Jun-2005 12:07:41   

The coming month is for drivers, then a new runtime update is planned

Frans...what new drivers to expect. Any plans for Progress??

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 22-Jun-2005 12:36:25   

omar wrote:

The coming month is for drivers, then a new runtime update is planned

Frans...what new drivers to expect. Any plans for Progress??

Undecided. The current upgrade development moves along fine, though I'll take as much time as I need to, no rushing. This means that if there's no time left (and it looks that way) I won't release any new drivers for the current code base, only for v2.0.

Frans Bouma | Lead developer LLBLGen Pro
omar avatar
omar
User
Posts: 569
Joined: 15-Oct-2004
# Posted on: 22-Jun-2005 13:26:14   

how about running some sort of a drivers wish list to see which drivers are in high demand for LLBL users.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 22-Jun-2005 14:00:06   

I can give you taht list right now: - postgresql - vistadb - sybase - pervasive

Frans Bouma | Lead developer LLBLGen Pro
omar avatar
omar
User
Posts: 569
Joined: 15-Oct-2004
# Posted on: 22-Jun-2005 14:49:34   

can u put my vote for ProgressSQL

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 22-Jun-2005 15:05:09   

Noted simple_smile

Frans Bouma | Lead developer LLBLGen Pro
ChrisMoses
User
Posts: 18
Joined: 22-Feb-2005
# Posted on: 27-Aug-2005 23:33:36   

I vote for VistaDB.