Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 10 of 14 total |
SQL ElevateDB Tutorial |
Thu, Jan 18 2007 7:25 PM | Permanent Link |
John Stevenson | I have been using DBISAM from the beginning, and to date, I have successfully avoided using SQL.
With the advent of ElevateDB, it looks like I need to move with the times. I am intending to migrate from DBISAM to ElevateDB ... may as well do it now, rather than when DBISAM gets phased out in a few years. I have tried to get going with the Tutorial in the help file that accompanies the ElevateDB beta. But ... it starts off ... The following steps will guide you through creating a basic local application using ElevateDB and Delphi 7. Note It is assumed that you have already created a database called "Tutorial" in the local folder "C:\Tutorial\DB" using the SQL below: CREATE DATABASE "Tutorial" PATH 'C:\Tutorial\DB' DESCRIPTION 'Tutorial Database' and that you have created a table called "Customer" in the "Tutorial" database using the SQL below: ... etc. Well, I am lost there. Checked out edbmgr, but all I can achieve there is an "ElevateDB Error #400 The collation ENU already exists." error message. Could I get some step by step instructions on implementing the above, please? Thanks John |
Fri, Jan 19 2007 8:39 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< Checked out edbmgr, but all I can achieve there is an "ElevateDB Error #400 The collation ENU already exists." error message. >> When you do get this error message ? Could you please elaborate on the steps that you're taking ? Also, what build of the preview are you using ? To create a database in the EDB Manager you must: 1) Start up the EDB Manager 2) Make sure that the configuration file path is set to the desired location ('c:\Tutorial'): a) In the task pane, click on the Edit Options link b) Make sure that the configuration file folder in the first edit box is the desired folder c) Click on the OK button. 3) Double-click on the Default session in the right-hand properties pane. 4) Click on the SQL tab at the top of the right-hand properties pane. 5) Paste in the CREATE DATABASE SQL from the tutorial. 6) Click on the Execute SQL link in the task pane. 7) Click on the Refresh button at the top of the EDB Manager. 8) Click on the + sign next to the Databases node in the treeview. 9) Click on the new Tutorial database that you just created. 10) Click on the Open Database link in the task pane. 11) Click on the SQL tab at the top of the right-hand properties pane. 12) Paste in the CREATE TABLE SQL from the tutorial. 13) Click on the Execute SQL link in the task pane. 14) Click on the Refresh button at the top of the EDB Manager. 15) The table should now show up in the list of Tables for the Tutorial database. -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Jan 21 2007 7:22 PM | Permanent Link |
John Stevenson | Tim
>> << Checked out edbmgr, but all I can achieve there is an "ElevateDB Error >> #400 The collation ENU already exists." error message. >> >> When you do get this error message ? Could you please elaborate on the >> steps that you're taking ? Also, what build of the preview are you using ? I am using ElevateDB Manager Version 1.00 (1.00 Build 5), which I think I downloaded on 18 January. To get the above mentioned error message I clicked on Connect Session. >> To create a database in the EDB Manager you must: >> 1) Start up the EDB Manager >> 2) Make sure that the configuration file path is set to the desired location >> ('c:\Tutorial'): >> a) In the task pane, click on the Edit Options link OK ... could not find any Edit Options link, but eventually found that if you selected ElevateDB Manager on the left, it became visible. >> 3) Double-click on the Default session in the right-hand properties pane. If I do that, I get the "ElevateDB Error #400 The collation ENU already exists." error message. John |
Mon, Jan 22 2007 8:06 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< I am using ElevateDB Manager Version 1.00 (1.00 Build 5), which I think I downloaded on 18 January. To get the above mentioned error message I clicked on Connect Session. >> What OS and version are you using ? It sounds like there is a duplicate locale ID installed on your system. << OK ... could not find any Edit Options link, but eventually found that if you selected ElevateDB Manager on the left, it became visible. >> The Edit Options task link should be visible when you first start up EDB. Was this not the case for you ? -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jan 22 2007 9:30 PM | Permanent Link |
John Stevenson | Tim
<< What OS and version are you using ? It sounds like there is a duplicate locale ID installed on your system. >> Windows XP Pro Version 2002 SP2 << The Edit Options task link should be visible when you first start up EDB. Was this not the case for you ? >> It is visible when I first start up EDB. It would have been last time too, but in answering your question about the error message, I temporarily lost it. John |
Tue, Jan 23 2007 1:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< Windows XP Pro Version 2002 SP2 >> Weird. I'll have to see about putting a check in EDB for this because I'm not sure why the OS is serving up a duplicate locale. It certainly isn't doing so with XP SP2 here and we haven't had any other reports of this, so it must be something very particular. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jan 23 2007 10:26 PM | Permanent Link |
John Stevenson | << Weird. I'll have to see about putting a check in EDB for this because I'm
not sure why the OS is serving up a duplicate locale. >> Thanks Tim ... I will look forward to hearing from you when we can progress. John |
Wed, Jan 24 2007 11:14 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< Thanks Tim ... I will look forward to hearing from you when we can progress. >> Could you do me a favor and run an application on your machine ? I want to see what it returns for the list of locales. I will email it to you privately if you agree to do so. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jan 24 2007 11:48 AM | Permanent Link |
Evgeni Georgiev | I recieve the same error! I installed the beta of edbmgr to new instalation of XP sp2. First it ran normally then
I installed Bulgarian language and then the error raised. |
Wed, Jan 24 2007 5:04 PM | Permanent Link |
John Stevenson | Tim
<< Could you do me a favor and run an application on your machine ? I want to see what it returns for the list of locales. I will email it to you privately if you agree to do so. >> Of course ... no problem ... happy to do all that I can to assist!! John |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |