> If you have databases which have more than 28 labels, do not plan
> on moving to the PSION5 because it cannot handle them (at least with the
> standard data application).
> So, if you thought you could use the fancy SQL functions to load some
> serious stuff on your brand spanking new PSION 5, I would forget about
> it if I were you.
Ok, the restrictions you need to know about are:
s3A max record size 1022
s5 max record size 8200
It would appear that you have created 28 fields which add up
in total size to 8200 bytes (or close to).
For both the 3a and s5 you can only access 32 fields in opl,
the data app however does not limit you to this.
(I don't know about the 3c but I guess it's the same.)
There are no field number restrictions if you use the C++ SDK but
you still have to adhere to the 8200 byte rule. However, you can
have more than one TABLE in a DATABASE! Upto 26 in fact, so you
could have a total field size of 213200 bytes (in 8200 byte chunks).
The Data app only uses a single table in its database.
So I suggest you limit the sizes of your string fields (which you do
when you create them).
String fields are limited to a max of 256 bytes anyway.
Memo fields have a theoretical limit of 2Gb (yes *G*!) but you
cannot get at them from opl :-( I'm not sure how much
database space they take up.
So if you have large chunks of data, memo fields are the way
to go (as long as you don't want to do fancy stuff in opl!)
I can understand your frustration, especially if you have existing
apps, but once you learn to deal with the restrictions I think
you'll find it acceptable for most applications. Maybe someone
will produce an extended database OPX which will allow access
to the memo fields. So it's not completely impossible, hang on in
Quote:> Since this limitation which did not exist on the real PSION products
> (S3a and S3c) is still undocumented, I cannot know if the limitation is
This implies the 5 is not a Psion product! The limitations are
documented but you need to fork out for the SDK to find out about them.
Slowly all will become known, it's only been out a couple of weeks!
Quote:> *I AM VERY VERY DISAPOINTED*
Don't be :-) It's a great machine, it's different to the Series 3
Soft Base Computing Ltd. Anti spam, delete the trailing x in relpy
Visit the Psion Series 5 page at .. http://www.softbase.co.uk/psion/
and the Airsculpture home page at .... http://www.softbase.co.uk/as/