>>>>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?