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