Phew, this is not working well at all!!

I have just downloaded and installed trial version of ElevateDB (VCL+Manager) and thought I'd start with the tutorial. But no matter what I try, I
can't get past the point where the table is supposed to be created.

When I press 'New .SQL' I get 'SCRIPT BEGIN     END' in the right-hand pane editor which is not in the editor. No big deal perhaps, I paste the
script

CREATE TABLE "Customer"
(
"ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1),
etc
)

between BEGIN and END, press Execute --> error "ElevateDB Error #700 An error was found in the script at line 2 and column 8 (Expected : but
instead found TABLE)
"

hmmm. So I remove the SCRIPT BEGIN END stuff, press Execute: "ElevateDB Error #700 An error was found in the script at line 2 and column 1
(Expected SCRIPT but instead found CREATE)"

hmmm again. After that I tried all combinations I could think of but no matter what I do, I get an error messages.

It's really annoying and sadly almost always the case, but tutorials and the reality never agree. Maybe that is why most people don't even bother
to read them ...

But then again, maybe it's just me being stupid - it wouldn't be the first time ...

So, what is going wrong here?

Regards,
Dag H

Aha, found it! If I select menu Script and then item 'Convert into script', this will be added

SCRIPT ()
BEGIN
  EXECUTE IMMEDIATE

and the script itself is passed as a string and then it works.

2 other things:

1) The help 'SQL Reference'does not work, "Cannot find edb2sql.hlp ..."
2) The collation is ANSI_CI althoug I really wanted to build a Unicode example. Maybe something to add to the tutorial?

Regards,
Dag

Dag,

> When I press 'New .SQL' I get 'SCRIPT BEGIN     END' in the right-hand pane editor which is not in the editor. No big deal perhaps, I paste the
> script
>
> CREATE TABLE "Customer"
> (
> "ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1),
> etc
> )
>
> between BEGIN and END, press Execute --> error "ElevateDB Error #700 An error was found in the script at line 2 and column 8 (Expected : but
> instead found TABLE)


Try this:

Execute Immediate '
  CREATE TABLE "Customer"
  (
   "ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT
BY 1),
   etc
   )';

Regards Uli

Dag

>But then again, maybe it's just me being stupid - it wouldn't be the first time ...

Not really, you just haven't caught up with the differences in ElevateDB

In EDBManager look at the New button - it has a dropdown menu statement or script. Unlike DBISAM ElevateDB has different components for running a script and running a query. EDBManager reflects this with different types of sql window. On the New buttons dropdown menu statement means query. There's confusion number 1.

So you created a new script not a query (or statement) and promptly dropped a query into it not knowing that a script in ElevateDB has a different language than in DBISAM. In DBISAM a script was essentially just a collection of querys (statements) separated by semi-colons. In ElevateDB its a whole new programming language.

The EXECUTE IMMEDIATE is a sort of half way house between DBISAM and ElevateDB allowing you to run simple statements (querys) in a script.

Roy Lambert [Team Elevate]

Dag,

<< When I press 'New .SQL' I get 'SCRIPT BEGIN     END' in the right-hand
pane editor which is not in the editor. >>

If you click on the New button, you should get a new SQL statement window,
not a new script window.  Are you sure that you aren't selecting the
New..Script option instead ?

<< It's really annoying and sadly almost always the case, but tutorials and
the reality never agree. Maybe that is why most people don't even bother to
read them ... >>

Actually, the tutorial says this:

"4. Click on the New button on the main toolbar."

Which is completely correct.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dag,

<< 1) The help 'SQL Reference'does not work, "Cannot find edb2sql.hlp ..."
>>

You may have to point it to the edb2sql.hlp file in the help subdirectory
under the main installation directory.  I'll double-check on this, though,
because it should find it on the first try.

<< 2) The collation is ANSI_CI althoug I really wanted to build a Unicode
example. Maybe something to add to the
tutorial? >>

Yes, that was missed for the CREATE TABLE statement.  I'll make sure that
this is corrected.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim
As a guess 98% of the time I have to link it up myself. It may be that I'm installing in a non-standard directory - 3rdParty\EDBUtils

Roy Lambert

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:039DEDED-0F53-4B5F-A075-C0B537015AF8@news.elevatesoft.com...

I had some time on my hands and d/l EDB to take another look.
I started the local tutorial following the help file. I got as far as
creating the c:\Tutorial everything is fine no complaints.
The niggle I have following the help file is in your example it
clearly shows a Tutorial folder below the Default folder see
attached pic. So I figured this is trial software and maybe I will
see that if I register. It froze me I went back and forth but the
table was under Default so if thats the case I shall resume.
I still love that CD thingybob tho.
Rita

Rita


From the bit you showed I'd say those aren't folders they're sessions. EDBManager comes with a default session but you have to create the others yourself. Probably your aging eyes missed that bit in the manual

The CDCollector is a nice example but, as I've said before, shows a lousy taste in music.

Roy Lambert

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:6032F757-81B0-480A-BE20-AE796BF8F491@news.elevatesoft.com...
>
> From the bit you showed I'd say those aren't folders they're sessions.
> EDBManager comes with a default session but you have to create the others
> yourself. Probably your aging eyes missed that bit in the manual
>

Iam now going to bed and forget all about it until later.

> The CDCollector is a nice example but, as I've said before, shows a lousy
> taste in music.
>

Probaly knocked that out for his granny.

On the question of eyes Tescos r trying to compete with Specsavers
and they are ok. So maybe I should nip up there.
Thanks
Rita Magoo