Hello again.
Well, seem to have the demo database working
very nicely now, and have just started to venture into doing my own database, which again is going ok but it appears to be doing something funny with the last field. I have added in an extra field, and so now have 10 fields, and numbered them correctly - userid field is now field number 10, rather than field number 9. Field number 9 is now a field for fax numbers. What's happening is that it doesn't appear to save the fax number at all, and saves the userid in the fax field. It all displays ok on the search and add screens. I'm using a clean database rather than messing with the default. So two questions really :
1) do I need to define somewhere else what the Id field is ? (I've looked but cannot see anything)
2) I've got rid of the radio buttons and check box and turned them into different field types, but I notice that in default.cfg that below the database definition there is some code which defines a couple of fields as radio/check etc - do I need to get shot of that code or is it just being harmless, even though it refers to field names that no longer exist ?
Hoping someone can lend their experience,
Many thanks, Dave.
PS: I may as well dump the database congig here while I'm here, so here it is :
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 255, 1, '', ''],
URL => [2, 'alpha', 40, 255, 1, 'http://', '^http://'],
Country => [3, 'alpha', 0, 60, 1, '', ''],
Category => [4, 'alpha', 0, 255, 1, '', ''],
Type => [5, 'alpha', 0, 100, 1, '', ''],
Description => [6, 'alpha', '40x3', 500, 0, '', ''],
Email => [7, 'alpha', 40, 100, 1, '', ''],
Telephone => [8, 'alpha', 40, 45, 1, '', ''],
Facsimile => [9, 'alpha', 40, 45, 1, '', ''],
Userid => [10, 'alpha', -2, 15, 0, '', '']
);
Well, seem to have the demo database working
very nicely now, and have just started to venture into doing my own database, which again is going ok but it appears to be doing something funny with the last field. I have added in an extra field, and so now have 10 fields, and numbered them correctly - userid field is now field number 10, rather than field number 9. Field number 9 is now a field for fax numbers. What's happening is that it doesn't appear to save the fax number at all, and saves the userid in the fax field. It all displays ok on the search and add screens. I'm using a clean database rather than messing with the default. So two questions really :
1) do I need to define somewhere else what the Id field is ? (I've looked but cannot see anything)
2) I've got rid of the radio buttons and check box and turned them into different field types, but I notice that in default.cfg that below the database definition there is some code which defines a couple of fields as radio/check etc - do I need to get shot of that code or is it just being harmless, even though it refers to field names that no longer exist ?
Hoping someone can lend their experience,
Many thanks, Dave.
PS: I may as well dump the database congig here while I'm here, so here it is :
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 255, 1, '', ''],
URL => [2, 'alpha', 40, 255, 1, 'http://', '^http://'],
Country => [3, 'alpha', 0, 60, 1, '', ''],
Category => [4, 'alpha', 0, 255, 1, '', ''],
Type => [5, 'alpha', 0, 100, 1, '', ''],
Description => [6, 'alpha', '40x3', 500, 0, '', ''],
Email => [7, 'alpha', 40, 100, 1, '', ''],
Telephone => [8, 'alpha', 40, 45, 1, '', ''],
Facsimile => [9, 'alpha', 40, 45, 1, '', ''],
Userid => [10, 'alpha', -2, 15, 0, '', '']
);
