Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread New user needs help
Wed, Feb 13 2013 8:39 AMPermanent Link

Mohd Atan

hi all,
i am trying to create a table for my application. So i started Database System Utilities, create the tables and tried to save.
The create new table setting are Local (Single/Multi-User) and the available database is Memory. There are no other selection at the available database combo box.
This will result in the table being create but only in the memory. it disappears the next time i start the Database System Utilities.

How do i correctly save the tables? Is there a section in the manual that tells me how to do this?

I would like to create for a single user local database and its table.

thanks in advance.
Wed, Feb 13 2013 9:07 AMPermanent Link

Raul

Team Elevate Team Elevate

On 2/13/2013 8:39 AM, Mohd Atan wrote:
> The create new table setting are Local (Single/Multi-User) and the available database is Memory. There are no other selection at the available database combo box.
> This will result in the table being create but only in the memory. it disappears the next time i start the Database System Utilities.

You need to just enter a path in the "Available Databases" listbox or
browse for file system path (the "select" button really means browse for
folder).

DBISAM database is really a folder - meaning tables in same folder
belong to same DB.

Raul
Wed, Feb 13 2013 9:21 AMPermanent Link

Mohd Atan

ok thnks for the tip.
btw would i able to execute sql queries on a single user table? or does it require the server?

thnks
Wed, Feb 13 2013 9:41 AMPermanent Link

Raul

Team Elevate Team Elevate

Yes - absolutely.

Server really only adds Client/Server architecture for multi-user
access. Usage like SQL queries etc is same for both.

Raul


On 2/13/2013 9:21 AM, Mohd Atan wrote:
> ok thnks for the tip.
> btw would i able to execute sql queries on a single user table? or does it require the server?
>
> thnks
>
Wed, Feb 13 2013 9:47 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mohd

>btw would i able to execute sql queries on a single user table? or does it require the server?

Client/server or fileserver says how the database will be accessed not what you are allowed to do to it. You will have no problem with executing sql queries as long as they are valid.

Since you're probably a newbie it would be worth mentioning the execution plan. In DBSys you can choose to show a plan for your query. This can help you identify indices that would speed things up etc.

Roy Lambert [Team Elevate]
Wed, Feb 13 2013 9:58 AMPermanent Link

Mohd Atan

noted with thanks to all.
Image