TOPIC: Access.Goto issue
Access.Goto issue 1 Year, 3 Months ago
Hi, i have quiestion about access.goto method. It seems when i input a value as type string and the database field has a field description type number that the input value is cast to be number, then access.goto no longer works. I can work around that, no problem only wonder why that is. Is it bug or is there a reason for it?
Re:Access.Goto issue 1 Year, 2 Months ago
I do not think it is a bug.

If your Field_ definition inherits from Field_number then stdlib will assume that the stored values are numbers (not strings).

If your stored values are strings, your Field_ definition should inherit from Field_string

You run into this problem if, for example, you inherit from Field_number but you change the Control: to something that results in a string value, rather than a NumberControl that results in a number alue.

This is so goto and searching know how to convert what the user types (a string) into the right type to match the stored data.

I hope that helps.
Re:Access.Goto issue 1 Year, 2 Months ago
Ah, i think you youre right, thanks. I had changed the field to become Number type later on, first it was not any specific type. I guess the default is String type.