Has anyone experienced any problems with writing to opportunities using the ODBC driver under Max 2000?

I keep getting strategy_id not updateable even though I'm not even trying to update the strategy field.

eg I get the error with

Update Opportunity Set Objective='Wibble' Where (Opp_ID='304' and Opp_Number=0)

Hi,

This is fairly typical of the sort of problem that can occur with the ODBC driver.

I've tried the line of code

UPDATE OPPORTUNITY SET Objective = 'Wibble'
WHERE (Opp_ID='990817000831788442303O' and Opp_Number=0);

and it worked fine so there are a couple of possibilities here.

Your SQL really is in error... Double check it ( sorry!)

The message is missleading .. eg its really means it can't find the opportunity or..

Somethings wrong with the ODBC driver. This can happen on large updates and if your short of diskspace/memory. Its a good idea to make sure you have the latest driver version which is currently 5.05.00.952

If you have an early Enterprise 2000 you may not have this version. You should be able to get this from your reseller or I can help you if you email me at ian.wallace@cabc.co.uk

Hope this helps,

Ian Wallace
CABC, Newbury

Have you got a strategy assigned to the opportunity you are trying to test it with because thats when the error kicks in.

You only get it when there's a strategy defined.