Field Default for Data Entry

Discuss HanDBase running on RIM BlackBerry devices and synchronization with a desktop.

Field Default for Data Entry

Postby joefincher » Tue Oct 13, 2009 12:37 am

I am using float for entering data into a workout database for weight, distance, etc. When I create a new record I must first delete 0.00 before I can enter new data. Is there a workaround or am I setting something wrong when I create the field? Apparently there is no custom Forms for BB yet.
joefincher
 
Posts: 2
Joined: Mon Oct 12, 2009 11:57 pm

Re: Field Default for Data Entry

Postby dhaupert » Tue Oct 13, 2009 4:12 pm

This is correct. You can set a default value for a float field in the desktop when you design your database. But anything you set would have to be deleted/edited to overwrite this.
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am

Re: Field Default for Data Entry

Postby joefincher » Wed Oct 14, 2009 3:22 am

Thanks Dave, however I didn't set a default. Apparently the program is setting 0.00 as a default default (redundancy intended) which must be deleted in order to input anything. Suggestions?

Regards, Joe
joefincher
 
Posts: 2
Joined: Mon Oct 12, 2009 11:57 pm

Re: Field Default for Data Entry

Postby dhaupert » Wed Oct 14, 2009 1:53 pm

Hi Joe,

The Float field requires a numeric value to be stored, in other words, at any moment it has to have some numeric value associated with it. So a 'blank' field is 0, and the number is formatted to the number of decimal places you specify for that field. It sounds like you have it set to 2 places after the decimal which is the default setting for a float field. If you want the field to be able to default to 'blank', I'd suggest using a text field instead. Of course it won't reformat the number you put in to a fixed set of decimal places, but you can have a blank value and it can be used for calculations as well.

If not, I'd suggest putting something like 0 in the default value, so you have less to delete. Let me know which works best for you!
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am


Return to HanDBase for BlackBerry

Who is online

Users browsing this forum: No registered users and 1 guest

cron