Hi guys,
I'm modifying a database slightly, trying to edit without really understanding the entire functionality of the system. Basically I have an append query where a set of default data is added to a table containing modified values. So if you had created A and C entries in the table already, this query will append B, D, E, etc...
However I want one of the fields that is by default set to B (and is B from the default table) (to indicate write/read) to be changed to R (read only) in all the entries that are added from this query.
Basically its so the log file records all of the values, but only uploads the modified values.
Thankyou
I'm modifying a database slightly, trying to edit without really understanding the entire functionality of the system. Basically I have an append query where a set of default data is added to a table containing modified values. So if you had created A and C entries in the table already, this query will append B, D, E, etc...
However I want one of the fields that is by default set to B (and is B from the default table) (to indicate write/read) to be changed to R (read only) in all the entries that are added from this query.
Basically its so the log file records all of the values, but only uploads the modified values.
Thankyou
Last edited:
