Author Topic: NT809 NetWebServiceMethode when using MSSQL compile error (Read 3140 times)

johanco123 · « **on:** April 23, 2014, 02:35:31 AM »

Hi Bruce

Clarion 8.08973 and NT8.09 Exfiles2.52 . When I create a NetwebServiceMethode using a MSSQLfile i am getting compile errors 'String not terminated' and ' Illegal character'.

It is on ExamplePostRequest Routine.
p_web.Nocolon('Notes=value&Excess=value&MasterClaimNo=value&PolicyNo=value&Insured=value&PSectionNo=value&PDetail_No=value&ClaimNo=value&SectionCode=value&BrokerCode=value&InsurerCode=value&BranchCode=value&OtherCode=value&UniqueCode=value&UWYear=value&DateofLoss=value&DateNotified=value&Frequency=value&InceptionDate=value&RenewalDate=value&BrokerReference=value&AssessorCode=value&PerilCode=value&Estimate=value&EstimateXS=value&EstimateNET=value&EstimateSalvage=value&EstimateSalvageXS=value&EstimateOther=value&EstimateOtherXS=value&TotalPaid=value&TotalPaidXS=value&TotalPaidVAT=value&TotalReceived=value&TotalReceivedXS=value&TotalReceivedVAT=value&TotalClaim=value&PaidThirdParty=value&PaidThirdPartyXS=value&EstThirdParty=value&EstThirdPartyXS=value&TotalThirdParty=value&TotalThirdPartyXS=value&ClaimsStatus=value&RecoverAction=value&User=value&EntryDate=value&LastChangeDate=value&FilingNo=value&PremiumPaid=value&RiskAddress1=value&RiskAddress2=value&SumInsured=value&InceptionCoverDate=value&UnitNumber=value&UnitSumInsured=value&AggregateExcess=value&InsurerReference=value&DriverDetail=value&TimeofLoss=value&PlaceofLossCode=value&MarketerCode=value&CatCode=value&RIon=value&Diverse1=value&ExtraLookup1=value&KnockForKnock=value&ClaimFinaliseDate=value&IDSFlag=value&ClaimBlocked=value&Memo=value&ClaimTypeInd=value&VATIndicator=value&ED=value&RiskCode=value&TotalExcessAmount=value&ClaimsSubStatus=value&EstimateAggXS=value&EstimateXSAggXS=value&EstimateNetAggXS=value&TotalPaidAggXS=value&TotalPaidXSAggXS=value&TotalPaidVatAggXS=value&TotalClaimAggXS=value&Fees=value&Area=value&Progress=value&A50TotalClaim=value&A50TotalPaid=value&A50EstimateNET=value&A50TotalReceived=value&RIPolicyTreatyNo=value&OnlySurplus=value&PerilsSub=value&SalvageAction=value&Claims_Action=update') &|

Regards
Johan

Bruce · « **Reply #1 on:** April 23, 2014, 02:57:57 AM »

please send me an example app Johan - I guess it's something in the template but I'm not sure what.

cheers
Bruce

johanco123 · « **Reply #2 on:** April 23, 2014, 04:46:40 AM »

Here is an example using a MSSQL file

Regards
Johan

[attachment deleted by admin]

Bruce · « **Reply #3 on:** April 24, 2014, 01:39:15 AM »

It's caused by the template generating a very long line in the CLW ( > 4 K).
I've tweaked the template in 8.10 to bypass this for now, but I'll need to tweak the code further to get it to generate multiple source lines instead.

johanco123 · « **Reply #4 on:** April 24, 2014, 05:52:20 AM »

Many tanks Bruce

NetTalk Central

Author Topic: NT809 NetWebServiceMethode when using MSSQL compile error (Read 3140 times)

johanco123

NT809 NetWebServiceMethode when using MSSQL compile error

Bruce

Re: NT809 NetWebServiceMethode when using MSSQL compile error

johanco123

Re: NT809 NetWebServiceMethode when using MSSQL compile error

Bruce

Re: NT809 NetWebServiceMethode when using MSSQL compile error

johanco123

Re: NT809 NetWebServiceMethode when using MSSQL compile error