Forum Announcement
23/02/2018 - The Online Chat isn't working via the normal link.
You can connect via IRC, or using another web client - https://kiwiirc.com/client/chat.qlforum.co.uk/#qlforum

Psion Archive

Anything QL Software or Programming Related.
thorsinclair
Trump Card
Posts: 171
Joined: Mon Jan 10, 2011 5:08 pm

Psion Archive

Postby thorsinclair » Wed Jan 03, 2018 6:49 pm

Hi all,

happy new year.

A trivial question for the QL enthusiast here: I'm running Archive on Q-emulator on OS X , German version with MGG Rom image, and am creating a database. I define the various text and number fields (variables) and do finish the creation. As it happens many times you notice that you did forget to add a field ...
Is it possible to add fields and variables to an existing database in Archive? How?

Thanks.

Thorsten


User avatar
Cristian
Gold Card
Posts: 441
Joined: Mon Feb 16, 2015 1:40 pm
Location: Veneto

Re: Psion Archive

Postby Cristian » Wed Jan 03, 2018 7:54 pm

My memory is weak thus I may be wrong, but you might create a new database with additional fields and import the previous one


thorsinclair
Trump Card
Posts: 171
Joined: Mon Jan 10, 2011 5:08 pm

Re: Psion Archive

Postby thorsinclair » Wed Jan 03, 2018 7:56 pm

Thanks. Yes, this would be a way to get it done I guess. Will try tomorrow.


User avatar
tofro
QL Wafer Drive
Posts: 1296
Joined: Sun Feb 13, 2011 10:53 pm
Location: SW Germany

Re: Psion Archive

Postby tofro » Wed Jan 03, 2018 9:11 pm

Page 31 of the English Archive Manual has a short Archive procedure that does exactly that. Don't have a German manual at hand, atm.

Tobias


Martin_Head
Gold Card
Posts: 271
Joined: Tue Dec 17, 2013 1:17 pm

Re: Psion Archive

Postby Martin_Head » Thu Jan 04, 2018 9:36 am

How about exporting the database to Abacus, add the extra field, then import back into Archive.


thorsinclair
Trump Card
Posts: 171
Joined: Mon Jan 10, 2011 5:08 pm

Re: Psion Archive

Postby thorsinclair » Thu Jan 04, 2018 10:05 am

solved - thank you.
I tried the programme from the users manual which creates a new database with the additional fields and copies over the existing records.

I have not yet tried to export in Abacus, adding new fields and re-importing into Archive.

Step by step ...


User avatar
Cristian
Gold Card
Posts: 441
Joined: Mon Feb 16, 2015 1:40 pm
Location: Veneto

Re: Psion Archive

Postby Cristian » Thu Jan 04, 2018 6:13 pm

So this time my memory was not so faulty :)



Return to “Software & Programming”

Who is online

Users browsing this forum: No registered users and 1 guest