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