![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Wed, Feb 13 2013 8:39 AM | Permanent 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 AM | Permanent Link |
Raul ![]() | 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 AM | Permanent 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 AM | Permanent Link |
Raul ![]() | 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 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 AM | Permanent Link |
Mohd Atan | noted with thanks to all.
|
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |