OK I'm working a vb.net application using OleDB connections to a ms access database. I'm running an update query on a memo style column and keep getting this expression to complex error. I've discovered it's due to the & clauses I believe. The query below causes the error but if I remove one of the & clauses from the string it seems to update just fine. I have to have these hard returns in the test so removing them is a problem. I have no idea what's going on here. Thanks for any help this is driving me crazy.
Query is below:
UPDATE Task SET Basis_of_Estimate = "Basis of Estimate: " & chr(13) & chr(10) & "" + chr(13) & chr(10) & chr(13) & chr(10) & "1. Study " & chr(13) & chr(10) & "· Based on RE inputs (verbal) times the current forward pricing rates." & chr(13) & chr(10) & "· Labor hours: Eng, ILS & Procurement" & chr(13) & chr(10) & "·Material: Boeing " & chr(13) & chr(10) & "2. Implementation:" & chr(13) & chr(10) & "·EMD" & chr(13) & chr(10) & "·Based on RE and engineering estimates times the current forward pricing rates." & chr(13) & chr(10) & "· Labor hours: Eng, ILS: TO, LSA, provisioning" & chr(13) & chr(10) & "·New Shut-off Valve Is Not NDI" & chr(13) & chr(10) & "· TOs by NG." & chr(13) & chr(10) & "· Flight test by AF @ Whiteman" & chr(13) & chr(10) & "· Material: Boeing: Cost of original part, escallated." & chr(13) & chr(10) & "·Retrofit" & chr(13) & chr(10) & "· Based on RE and engineering estimates times the current forward pricing rates." & chr(13) & chr(10) & "· Kits by NG (Boeing)." & chr(13) & chr(10) & "· Remove & replace labor by AF during Maintanence activity." & chr(13) & chr(10) & "· Every actuator is replaced." & chr(13) & chr(10) & "· Labor hours: Eng, ILS & Ops ( Kitting)" & chr(13) & chr(10) & "· Material: Boeing: Cost of original part, escallated." & chr(13) & chr(10) & "3. O&S" & chr(13) & chr(10) & "· Assumes 20% Increase in Reliability Over 'Empirical' Baseline" & chr(13) & chr(10) & "· (25) Actuators were at ITT for ICS and repair of repairables (ROR) in Jan to Mar of 1998." & chr(13) & chr(10) & "· (22) spares have been delivered to program." & chr(13) & chr(10) & "· PDM has no impact " & chr(13) & chr(10) & "·16 PAA, 21 Aircraft, 372.6 Flying hrs. per year per PAA, 20 years of operations." & chr(13) & chr(10) & "4. Other Groundrules & Assumptions:" & chr(13) & chr(10) & "· This is a quick turn around cost analysis developed to assist in sustaining engineering budget planning. The estimates are based on engineering judgment and are not to be considered contractually binding." & chr(13) & chr(10) & "·In the event of an increase to Life Cycle Costs it is possible that the negative financial return-on-investment may be mitigated by inherent operational and/or technical gains." & chr(13) & chr(10) & chr(13) & chr(10) & "· Previous Studies are excluded." & chr(13) & chr(10) & "· Government Costs are Included (note: not excluded) at: at 30% for the Study, 28% for EMD, and 15% for Retrofit." & chr(13) & chr(10) & "· Acquisition Costs and O&S Costs are in constant 2001 dollars (note: not 1999). Escalation used is 4.5% per year."
WHERE Category_ID=336 and Task_Number='C2Y';
Query is below:
UPDATE Task SET Basis_of_Estimate = "Basis of Estimate: " & chr(13) & chr(10) & "" + chr(13) & chr(10) & chr(13) & chr(10) & "1. Study " & chr(13) & chr(10) & "· Based on RE inputs (verbal) times the current forward pricing rates." & chr(13) & chr(10) & "· Labor hours: Eng, ILS & Procurement" & chr(13) & chr(10) & "·Material: Boeing " & chr(13) & chr(10) & "2. Implementation:" & chr(13) & chr(10) & "·EMD" & chr(13) & chr(10) & "·Based on RE and engineering estimates times the current forward pricing rates." & chr(13) & chr(10) & "· Labor hours: Eng, ILS: TO, LSA, provisioning" & chr(13) & chr(10) & "·New Shut-off Valve Is Not NDI" & chr(13) & chr(10) & "· TOs by NG." & chr(13) & chr(10) & "· Flight test by AF @ Whiteman" & chr(13) & chr(10) & "· Material: Boeing: Cost of original part, escallated." & chr(13) & chr(10) & "·Retrofit" & chr(13) & chr(10) & "· Based on RE and engineering estimates times the current forward pricing rates." & chr(13) & chr(10) & "· Kits by NG (Boeing)." & chr(13) & chr(10) & "· Remove & replace labor by AF during Maintanence activity." & chr(13) & chr(10) & "· Every actuator is replaced." & chr(13) & chr(10) & "· Labor hours: Eng, ILS & Ops ( Kitting)" & chr(13) & chr(10) & "· Material: Boeing: Cost of original part, escallated." & chr(13) & chr(10) & "3. O&S" & chr(13) & chr(10) & "· Assumes 20% Increase in Reliability Over 'Empirical' Baseline" & chr(13) & chr(10) & "· (25) Actuators were at ITT for ICS and repair of repairables (ROR) in Jan to Mar of 1998." & chr(13) & chr(10) & "· (22) spares have been delivered to program." & chr(13) & chr(10) & "· PDM has no impact " & chr(13) & chr(10) & "·16 PAA, 21 Aircraft, 372.6 Flying hrs. per year per PAA, 20 years of operations." & chr(13) & chr(10) & "4. Other Groundrules & Assumptions:" & chr(13) & chr(10) & "· This is a quick turn around cost analysis developed to assist in sustaining engineering budget planning. The estimates are based on engineering judgment and are not to be considered contractually binding." & chr(13) & chr(10) & "·In the event of an increase to Life Cycle Costs it is possible that the negative financial return-on-investment may be mitigated by inherent operational and/or technical gains." & chr(13) & chr(10) & chr(13) & chr(10) & "· Previous Studies are excluded." & chr(13) & chr(10) & "· Government Costs are Included (note: not excluded) at: at 30% for the Study, 28% for EMD, and 15% for Retrofit." & chr(13) & chr(10) & "· Acquisition Costs and O&S Costs are in constant 2001 dollars (note: not 1999). Escalation used is 4.5% per year."
WHERE Category_ID=336 and Task_Number='C2Y';
