>>>>>Bernard,
>>>>>
>>>>>It bombs for me too with:
>>>>>
>>>>>---------------------------
>>>>>XML Web Services Publisher Error
>>>>>---------------------------
>>>>>Field TIPS does not accept null values.
>>>>>
>>>>>
>>>>>
>>>>>Location: oweb
>>>>>
>>>>>Number: 1581
>>>>>
>>>>>Method: addfoxcode
>>>>>
>>>>>Message: INSERT INTO (THIS.cWSAlias) (Type, Name, Menu, Tips, URI, WSML, Class, Port, TimeStamp, UniqueID, Toolbox, Comfile, Prefs) VALUES("C", lcWSName, lcMethodStr, lcTipsStr, lcWSDL, lcWSMLGTM, lcClass, lcServicePort, ldDateTime, lcID, .T., lcServiceDoc, lcMethodStr2)
>>>>>
>>>>>Line: 224
>>>>>
>>>>>______________________________
>>>>>
>>>>>Press OK to ignore error and continue.
>>>>>
>>>>>Press Cancel to close.
>>>>>
>>>>>
>>>>>---------------------------
>>>>>OK Cancel
>>>>>---------------------------
>>>>>
>>>>>This SP2 is quickly becoming the worst experience for me regarding software updates.
>>>>>
>>>>>Mike
>>>>>
>>>>>
>>>>
>>>>Hi Mike
>>>>
>>>>Dont ask me how but although the code in the SP1 and sp2 FFC classes for this class is identical, somewhere else something is amiss.
>>>>
>>>>Anyway after much debugging I have come up with a fix. This will fix this error and also allow the TaskPane to work properly.
>>>>
>>>>Fix
>>>>
>>>>1. Open the class HOME()+"ffc\_ws3utils.vcx" and select the _webservice class for editing
>>>>
>>>>2. Open the method "addfoxcode"
>>>>
>>>>3. Scroll down till you see this code:
>>>>

>>>>lcServiceDoc = ""
>>>>THIS.cWSname = loService.Name
>>>>lcWSName = THIS.cWSname
>>>>lcServiceDoc = loService.Documentation  <<<--- this is the culprit
>>>>

>>>>
>>>>The above marked line sometimes returns a null and this is stored in lcServiceDoc, later on causing an error.
>>>>
>>>>4. Change this offending line to:
>>>>

>>>>lcServiceDoc = NVL(loService.Documentation,"")
>>>>

>>>>
>>>>5. Voila!. No more error and the Taskpane also works properly.
>>>>
>>>>One down many more to go....
>>>>
>>>>Bernard
>>>
>>>Hey Bernard,
>>>
>>>Thanks for the "fix". Unfortunately it will not address my issue. If you examine my error message, it looks similar to yours except it complains about the field "TIPS"!
>>>
>>>I'd quickly tried to do a similar "fix" for TIPS but had no luck. Looks like I'm going to have to dig a little deeper.
>>>
>>>Mike
>>
>>Mike
>>
>>A similar fix could be done. Tips is filled with lcTipsStr in the same method as I posted. All you'd need to do is change the INSERT statement in your error above in the class to :
>>
>>

>>INSERT INTO (THIS.cWSAlias) (Type, Name, Menu, Tips, URI, WSML, Class, Port, TimeStamp, UniqueID, Toolbox, Comfile, Prefs);
>>				VALUES("C", lcWSName, lcMethodStr, NVL(lcTipsStr,""), lcWSDL, lcWSMLGTM, lcClass, lcServicePort, ldDateTime, lcID, .T., lcServiceDoc, lcMethodStr2)
>>

>>
>>In fact if more people get errors with this the complete line should be changed to not allow NULLS since I found that if you allow a NULL in any field, the code is generated but the Combo that should appear on the Taskpane for selecting the Web Service disappears.
>
>Yeah I tried that as well as in the REPLACE command immediately above it and I still get the error when I try to "Register an XML Web Service" in the taskpane. I suspect that somehow my changes are not being seen by the taskpane. Do I need to recompile something?

Maybe recompile the Classlib - _ws3utils.vcx?