Having built a new system with a variety of forms, I have been presented with a particular user request and I am unsure how best to solve it.
This area of functionality involves the user supply certain information which will be turned into SQL instructions. these include the use of the terms 'EQUAL' and 'NOT EQUAL'- to satisfy the whims of (Oracle) SQL it is necessary to store these on the database as '=' and '<>'.
These 'operators' (and others) are being held within the MS Access database (and presented as a pulldown list) but then being used to formulate information which is then forwarded for storage on the Oracle database.
I need to present these 2 operators in textual form on the screen but pass them forward in SQL form, i.e. when existing detail is displayed in the form, I need to convert from SQL to text but when a new entry is created, I need to convert from text to SQL when I store that detail on the Oracle database.
The two options I have thought of are :-
a) Use the 'On Change' event to recognise when either of these two values is selected from the pulldown list so that the value can be converted before storage.
b) Wait until the form is closed and then process the database entries to convert any rows contain either of the two values.
Note that create/modification of this detail will be relatively low-key (after the initial set of detail has been created) and that the number of entries in the Oracle database table will be relatively small. [However there will be a number of tables utilising these operators and each form will have a maximum of 3 entry points for these values]
Hopefully this level of description is enough to 'get the ball rolling' - I would be interested to hear of any thoughts (+ possible code ?) regarding this issue, together with any other suggestions of how the problem might best be solved.
This area of functionality involves the user supply certain information which will be turned into SQL instructions. these include the use of the terms 'EQUAL' and 'NOT EQUAL'- to satisfy the whims of (Oracle) SQL it is necessary to store these on the database as '=' and '<>'.
These 'operators' (and others) are being held within the MS Access database (and presented as a pulldown list) but then being used to formulate information which is then forwarded for storage on the Oracle database.
I need to present these 2 operators in textual form on the screen but pass them forward in SQL form, i.e. when existing detail is displayed in the form, I need to convert from SQL to text but when a new entry is created, I need to convert from text to SQL when I store that detail on the Oracle database.
The two options I have thought of are :-
a) Use the 'On Change' event to recognise when either of these two values is selected from the pulldown list so that the value can be converted before storage.
b) Wait until the form is closed and then process the database entries to convert any rows contain either of the two values.
Note that create/modification of this detail will be relatively low-key (after the initial set of detail has been created) and that the number of entries in the Oracle database table will be relatively small. [However there will be a number of tables utilising these operators and each form will have a maximum of 3 entry points for these values]
Hopefully this level of description is enough to 'get the ball rolling' - I would be interested to hear of any thoughts (+ possible code ?) regarding this issue, together with any other suggestions of how the problem might best be solved.