INET and MACADDR datatypes

Classic Servoy
1

Hi,

I am attempting to display IP addresses and MAC addresses in a Servoy application - the data is stored in a postgreSQL database as INET and MACADDR datatypes respectively. It appears that Servoy does not recognise these datatypes as they are listed as in the Dataproviders window. This means any content entered into one of these fields in the application is cleared as soon as focus is moved away from that field.

Is there anything I can do to allow Servoy to recognise these datatypes or otherwise avoid the problem?

2

in the end (if you get them from the db or into the db in other tools) are they just strings? Or do they have to have a special format/data object?

3

Ultimately they are just strings (so I could always change the datatype in the DB), however I was hoping I wouldn’t have to do so as it allows me to ensure all IP and Mac addresses in the db are formatted correctly. (I am aware I could check the format of new entries via the front-end, but wanted the extra error-checking at the back-end).

4

but if you insert them with another tool are you just inserting a string? That is formatted as a ip address?

In release 2.5 we will see if we can give you an option that you can override the “unknown” type youreself (so that you can set them to one of our base types)

5

Thanks for that - however although IP’s and macaddr’s are essentially entered as strings, the main reason INET and MACADDR datatypes are useful is that they perform automatic internal formatting and validity checking. Other tools which are accessing the database are inserting values as INET and MACADDR’s, rather than strings.

Thanks again for your help