Tim (others),

First of all: Hope this year will bring you all what you're hoping for.

Is there a testscript available that one could run in the EDB manager to
create a database, add some MD relations and fill tables with some data
(like for example the northwind ms access db)? I want to test EDB, but we
are on dbIsam 3.30 so importing our own data is not possible (and some of
the stuff we want to test wasn't even there in 3x).

Regards, Harry

Tim,

<< Is there a testscript available that one could run in the EDB manager to
create a database, add some MD relations and fill tables with some data
(like for example the northwind ms access db)? >>

I agree with Harry that it would be great to have an example of how to
create a database with tables, views, data and stored procedures in
ElevateDB SQL. I believe the Northwind database would be a very good
example, since it's a well known and frequently used sample database.

I'm enclosing a Northwind database script which I've translated from the
original Transact-SQL script to standard SQL (for the large part). The
script might be of help if you want to code an ElevateDB version.

Ole Willy Tuv

Ole,

I had often considered doing something like that, even to the point of
supplying "sample" data with products... BUT, aren't there copyright
issues with such a script? We might be OK with doing such things for
our own usage, but as soon as it would be published, I believe it would
be a copyright violation.

A few years ago, I even did a little research to see if any of these
sample databases were available for general use... My impression was
that they were all definitely copyrighted and protected.

Ole,

Thanks. Tat's great. I will see if I can code an EDB version for it.

Regards, Harry

"Ole Willy Tuv" <owtuv@online.no> schreef in bericht
news:095C758E-8910-42DB-826D-7128456E9D22@news.elevatesoft.com...
> Tim,
>
> << Is there a testscript available that one could run in the EDB manager
to
> create a database, add some MD relations and fill tables with some data
> (like for example the northwind ms access db)? >>
>
> I agree with Harry that it would be great to have an example of how to
> create a database with tables, views, data and stored procedures in
> ElevateDB SQL. I believe the Northwind database would be a very good
> example, since it's a well known and frequently used sample database.
>
> I'm enclosing a Northwind database script which I've translated from the
> original Transact-SQL script to standard SQL (for the large part). The
> script might be of help if you want to code an ElevateDB version.
>
> Ole Willy Tuv
>
>
>

Harry,

<< Is there a testscript available that one could run in the EDB manager to
create a database, add some MD relations and fill tables with some data
(like for example the northwind ms access db)? I want to test EDB, but we
are on dbIsam 3.30 so importing our own data is not possible (and some of
the stuff we want to test wasn't even there in 3x). >>

We have plans to include a sample application with the release.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:7367818A-9992-42A2-8EA8-1D39C8A92A4E@news.elevatesoft.com...

> We have plans to include a sample application with the release.

I believe a large number of organized example applications would greatly
benefit ElevateDB. Even if these were created by the community and stamped
by Elevate as "good examples". As a new user it would have helped me
considerably. I would love to see folders with code and data files for
things as simple as:

Creating a table
Demonstrating record locking issues
Reading from a table: basically one table component with some of the table
properties that can be modified at run-time.
Using the engine, session and database components
Creating extensions to ElevateDB
SQL features, functions and more
Backing up a database
Optimizing tables
Repairing tables
(and many more if you call in the next 15 minutes)

I know one could argue that these examples exist elsewhere, but what could
be better than finding an example on your computer that you could run and
tweak with no effort at all. I would have learned DBISAM much faster this
way. Code snippets in the documentation helps, but a running example with
demo data would be much better.

I would be willing to create one or more of these examples in my spare time.

-Johnnie

Johnnie,

<< I believe a large number of organized example applications would greatly
benefit ElevateDB. >>

There will be examples such as this also.

--
Tim Young
Elevate Software
www.elevatesoft.com