Page 1 of 1

S60 questions

PostPosted: Thu Sep 03, 2009 3:45 pm
by razvu
Hi!

I downloaded to trial version for MAC and Symbian S60. I have the Nokia E61i.
I bumped into 2 issues, so far.

1. When I create a database, in the DB properties / Fields, for a text field type, there is an option to display a certain no. of pixels. It is written "pixels shown" and it can be adjusted. However when I see all the records, the field's width remains the same, and I cannot adjust it. How is it supposed to work?
2. For a unique field, when I add a new record, it starts from 2 then goes to 4, 6, etc. Shouldn't it number the records like most databases do: 1,2,3, etc, or to input a number in the beginning and to start counting automatically from there?

Thank you!

Re: S60 questions

PostPosted: Fri Sep 04, 2009 1:10 pm
by dhaupert
razvu wrote:Hi!


Hi!

1. When I create a database, in the DB properties / Fields, for a text field type, there is an option to display a certain no. of pixels. It is written "pixels shown" and it can be adjusted. However when I see all the records, the field's width remains the same, and I cannot adjust it. How is it supposed to work?


You're describing the feature correctly with one caveat- this is the default width and any view will override this width. Perhaps you have a view set up? If so, when you go to Edit View, you'll have settings there. They override the default setting. Hopefully that's the case!

2. For a unique field, when I add a new record, it starts from 2 then goes to 4, 6, etc. Shouldn't it number the records like most databases do: 1,2,3, etc, or to input a number in the beginning and to start counting automatically from there?

Thank you!


There is a single unique counter. It increments for several reasons:

1. For each record which stores an internal unique number as part of it's header
2. For link field types
3. For Unique field types.

It's not really an autonumber field where each field will have consecutive values. This would actually be quite a bit more useful than the Unique field, which frankly is of only limited use these days. The main purpose is to generate something that would help break a tie when sorting. But honestly it's more of a legacy feature than anything and will likely go away or be completely revamped in the future.

Hope this helps!

Re: S60 questions

PostPosted: Fri Sep 04, 2009 10:03 pm
by razvu
Thank you for the reply!

I understand now about the unique field. Yes, it would probably more useful to be as an auto increment, maybe in the future.

Unfortunately I didn't have success with the view. I created another view: test. When I press on it, I have the following options:

Name: Test
Action: Adjust view of DB / Switch to other DB
Live update: Enabled / Disabled.

I selected: Adjust view of DB and Enabled.

When I go to see the database, it looks exactly the same. I selected the Test view and nothing changed.

My fields are as follows: Cust_id, Cust_name, Cust_address, etc. Basically I want to make the Cust_name wider so I can see the whole name. Under that field properties I set shown pixels: 100, but there is no difference...Does it make any sense?

Thank you for your help!

Re: S60 questions

PostPosted: Sat Sep 05, 2009 8:43 am
by dhaupert
Hi,

You're very close, while you're in the view editor, there is a field settings section. In there, you can control the width of fields, order, and which fields are visible. That's the place you need to go!

Re: S60 questions

PostPosted: Sat Sep 05, 2009 1:30 pm
by razvu
I got it! It works great!
I found that field settings yesterday, but I didn't click on a field to see its properties...
Thank you very much!
I will try other feature, I think it's exactly what I need to keep track of my data.
I hope I can post more questions, if any...

Thanks again!!!