Hi,

I have now resolved this by changing the call to the SP to use the Command object rather than Connection object. I narrowed the issue down to the conversion of...

As usual no one is admitting to changing anything.

With p_oCom

        For l_lCounter = l_lLBound To l_lUBound

            l_cData = p_vData(l_lCounter)

            If Len(l_cData) = 0 Then

                l_cData = ""

            End...

Gents,

Many thanks for taking the time to respond but I cant have clearly defined my issue.

I have an ADO Connection object. The SQL statement is built as a string and...

Unfortunately the Bugatti and McLaren are supercars requiring super bank balances.

In the UK we get lots of small specialist sports car manufacturers. We still have the Westfield and Caterham battle...

Interesting that you should say this as here in the UK Asda (Walmart wholly owned chain) are year after year the UK business that win the employee satisfaction awards.

Interestingly its...