Hi all.
I've written the following code to enable the storage of 2 values in one form field using a colon as the delimiter - rather than redesign the form which we don't have access to do.
The form field stores the values 2.50:250.00 and the above code splits the string into 2 columns, my question is, on a relatively small amount of data, is this a wise move or would splitting the data at the front end (VB.NET) be a better idea?
This sql doesn't seem to impact on the dataset, and would save time rewriting the front end to accomodate this issue.
Cheers,
Jon
I've written the following code to enable the storage of 2 values in one form field using a colon as the delimiter - rather than redesign the form which we don't have access to do.
Code:
select policy_key, substr(pol_notes,1, (instr(pol_notes, ':')-1)) netret,
substr(pol_notes,(instr(pol_notes, ':')+1)) nri
from genpolicy where policy_key = 'XXXXX';
The form field stores the values 2.50:250.00 and the above code splits the string into 2 columns, my question is, on a relatively small amount of data, is this a wise move or would splitting the data at the front end (VB.NET) be a better idea?
This sql doesn't seem to impact on the dataset, and would save time rewriting the front end to accomodate this issue.
Cheers,
Jon