Hi,
I've come from using NexusDB and am just starting to use DBISAM. I
created a test table using the dbsys utility and now find that I would
like to add some extra fields - I expected that by restructuring the
table I could do so but restructuring seems to allow only modification
of existing fields.
Is this possible with dbsys or do I need to do it some other way?
Thanks,
Steve

Steve McGrath <smcgrath@no-spam.org> wrote on Wed, 10 May 2006 22:35:31 +0100

>
>Hi,
>I've come from using NexusDB and am just starting to use DBISAM. I
>created a test table using the dbsys utility and now find that I would
>like to add some extra fields - I expected that by restructuring the
>table I could do so but restructuring seems to allow only modification
>of existing fields.
>Is this possible with dbsys or do I need to do it some other way?
>Thanks,
>Steve

Steve


You can add field to an existing table using dbsys.  (In version 3.30) Just go to the end of the grid that shows the fields and use the down arrow key to add a new line to the grid.  You can move this up to where you want it using the arrow buttons at the side of the grid.


Cheers

Jeff

P.S.  The usual question is "how do I delete a field?" - to which the answer is <Ctrl>+<Delete>. J.

--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff Cook wrote:
> Steve McGrath <smcgrath@no-spam.org> wrote on Wed, 10 May 2006 22:35:31 +0100
>
>> Hi,
>> I've come from using NexusDB and am just starting to use DBISAM. I
>> created a test table using the dbsys utility and now find that I would
>> like to add some extra fields - I expected that by restructuring the
>> table I could do so but restructuring seems to allow only modification
>> of existing fields.
>> Is this possible with dbsys or do I need to do it some other way?
>> Thanks,
>> Steve
>
> Steve
>
>
> You can add field to an existing table using dbsys.  (In version 3.30) Just go to the end of the grid that shows the fields and use the down arrow key to add a new line to the grid.  You can move this up to where you want it using the arrow buttons at the side of the grid.
>
>
> Cheers
>
> Jeff
>
> P.S.  The usual question is "how do I delete a field?" - to which the answer is <Ctrl>+<Delete>. J.
>
> --
> Jeff Cook
> Aspect Systems Ltd
> Phone: +64-9-424 5388
> Skype: jeffcooknz
> www.aspect.co.nz
>  
>
>
>

Jeff,

I'm using v4.24 of dbSys. When I open a table using Utilities - Alter
table - Structure tab, all I see is a single row representing my single
field in the table. Clicking the up/down arrows on the left doesn't do
anything,
Thanks,
Steve

Steve McGrath wrote:
> Jeff Cook wrote:
>> Steve McGrath <smcgrath@no-spam.org> wrote on Wed, 10 May 2006
>> 22:35:31 +0100
>>
>>> Hi,
>>> I've come from using NexusDB and am just starting to use DBISAM. I
>>> created a test table using the dbsys utility and now find that I would
>>> like to add some extra fields - I expected that by restructuring the
>>> table I could do so but restructuring seems to allow only modification
>>> of existing fields.
>>> Is this possible with dbsys or do I need to do it some other way?
>>> Thanks,
>>> Steve
>>
>> Steve
>>
>>
>> You can add field to an existing table using dbsys.  (In version 3.30)
>> Just go to the end of the grid that shows the fields and use the down
>> arrow key to add a new line to the grid.  You can move this up to
>> where you want it using the arrow buttons at the side of the grid.
>>
>>
>> Cheers
>>
>> Jeff
>> P.S.  The usual question is "how do I delete a field?" - to which the
>> answer is <Ctrl>+<Delete>. J.
>>
>> --
>> Jeff Cook
>> Aspect Systems Ltd
>> Phone: +64-9-424 5388
>> Skype: jeffcooknz
>> www.aspect.co.nz
>>  
>>
>>
>>
>
> Jeff,
>
> I'm using v4.24 of dbSys. When I open a table using Utilities - Alter
> table - Structure tab, all I see is a single row representing my single
> field in the table. Clicking the up/down arrows on the left doesn't do
> anything,
> Thanks,
> Steve
>

Found it! Just use the <Insert> key,

Steve

Steve McGrath <smcgrath@no-spam.org> wrote on Wed, 10 May 2006 23:06:45 +0100

>
>Found it! Just use the <Insert> key,
>
>Steve

Steve

Hmmm.... <Insert> key works for v3.30 too!  After all these years ....


Jeff
--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff


Tell me about it I figured out ctrl-del quick enough tried ctrl-ins but that did nothing and resigned myself for years to adding at the bottom and moving the new field. Then some bright spark (probably Tim) posted use insert........


Roy Lambert

Roy Lambert wrote:
> Jeff
>
>
> Tell me about it I figured out ctrl-del quick enough tried ctrl-ins but that did nothing and resigned myself for years to adding at the bottom and moving the new field. Then some bright spark (probably Tim) posted use insert........
>
>
> Roy Lambert
>
Whew... It's good to know I'm not alone on the Planet gives you a
sense of place eh?

Allan