There has been another thread going in EDB-SQL ... it reached 28 messages, and has branched away from the original content, so I thought I would restart it here:

I wrote:

>><< I think this whole thread shows that it would be great to have a
>>dedicated space on the forums or EDB Website for people to see examples of
>>EDB SQL. I realise it is "more or less" SQL2003 ... but there are
>>differences & tiny differences often cause the most pain! >>

Tim Replied:

>>I can set up a new newsgroup in a minute.  Doing something more would take a
>>bit more time.

>>Any votes on one or the other ?

My personal vote would be for a new bit of the website (sorry I know its more work!) it would have a series of headings for broad categories of SQL, and under this users could add example-code, i.e. longish complicated SQL which newbies or others might find useful.

I am willing to post a pretty large amount ... I have plenty of examples ... as a contribution. Of course the existing stuff from the help manuals could be pasted in. There is also quite a lot which could be "harvested" from the forums. I would be willing to do some of that as well, to share the burden.

The thing is that EDB SQL is really quite a complex language, and many of us come from a "SELECT WHERE" SQL background, making it a very big leap to go straight into "IF ENDIF, DECLARE, IN/OUT Variables" etc.

We could just have another newsgroup (a bit like the third-party code newsgroup, but with SQL as attachments) ... I guess that might be almost as good.

Votes / Ideas?

Adam,

<< There has been another thread going in EDB-SQL ... it reached 28
messages, and has branched away from the original content, so I thought I
would restart it here: >>

Michael Riley had the fantastic suggestion that I used Elevate Web Builder
to create it, thus killing two birds with one stone (not that I advocate
such a thing).

I think I'll do it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Michael Riley had the fantastic suggestion that I used Elevate Web Builder
>to create it,

I actually thought that maintaining your website was the main reason for developing EWB

thus killing two birds with one stone (not that I advocate
>such a thing).

Depends how hungry you are

>I think I'll do it.

Great. Now my first request is for the ability to personalise downloads so I just click one button and get a predefined selection rather than having to pick each one in turn.

Roy Lambert

Count my vote in for such a forum.  Much of my SQL learning has been through examples posted here and elsewhere, and there never seems to be enough of them (or the right kind).

Dale

That is a most awesome idea!  (Not the killing of birds, but an "examples"
web site and built with EWB.)

David Cornelius
Cornelius Concepts

Thanks for these responses & I look forward to the new forum/site!

By the way is there anything public anywhere about Elevate Web??? Tim has been writing teaser-stuff about it on-line for ages ... but nothing concrete.

For a start: what other web tools is it related to / derived from etc?

Adam

D'Oh:

http://www.elevatesoft.com/products?category=ewb

http://www.elevatesoft.com/blog?action=view&id=elevate_web_builder

http://www.youtube.com/watch?v=mraP4dRSjpk

... all interesting & really exciting.

Is the Elevate product in any way related to Morfik? (www.morfik.com) ... an interesting Pascal-based web-tool.

How does the Elevate product handle the statelessness of the web? This is one of the big problems with all web-application builders. The fact of having to add XAML layers etc., in tools like Visual Studio has always been a big negative for me.

Really eager to hear more ... though I will be sorry if I have to dump all my Morfik code to switch to Elevate Web Builder!

Adam,

<< Is the Elevate product in any way related to Morfik? (www.morfik.com) ...
an interesting Pascal-based web-tool. >>

No.  Although there are some minor similarities, the two are really
different in a lot of ways.

<< How does the Elevate product handle the statelessness of the web? This is
one of the big problems with all web-application builders. The fact of
having to add XAML layers etc., in tools like Visual Studio has always been
a big negative for me. >>

You can manage the state in any way that you wish, using cookies, HTML5
storage, etc.  Remember, this is just like doing a Delphi application,
except that it runs in a web browser instead of in Windows.  When you're
developing in the IDE, you're developing the front-end application only, and
so you will use requests along with cookies/local storage to retrieve the
state/data from the back-end, as necessary.  You can create classes that
handle all of this for you, also - EWB units look just like Delphi units.

<< Really eager to hear more ... though I will be sorry if I have to dump
all my Morfik code to switch to Elevate Web Builder! >>

Yes, you will need to code things from scratch, although I think you'll be
happy with how much is done for you already in terms of the visual aspects
of things and things that, at first, seem minor because they are easy in
Windows, but are a major pain to get correct in a browser, such as tab
ordering, z-order/stack order, modality, dragging, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com