Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 12 total |
ElevateDB 2 Tutorial |
Fri, Mar 13 2009 10:09 AM | Permanent Link |
Dag Hovden | 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 |
Fri, Mar 13 2009 10:54 AM | Permanent Link |
Dag Hovden | 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 |
Fri, Mar 13 2009 10:58 AM | Permanent Link |
Uli Becker | 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 |
Fri, Mar 13 2009 11:59 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Fri, Mar 13 2009 12:18 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Mar 13 2009 12:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Sat, Mar 14 2009 5:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Mar 16 2009 10:35 AM | Permanent Link |
"Rita" | "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 Attachments: tutorial.png |
Mon, Mar 16 2009 11:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Mar 16 2009 11:32 AM | Permanent Link |
"Rita" | "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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
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 |