Lookup SQL Statement too long

[Tm99]

Hi all,
we have created a new CRM template for Sage Office Line / 100 which is based on the MSSQL template. Now we are able to sync three phone numbers only because the lookup SQL statement seems to be to long. For three numbers it has a length 973 and for four numbers around 1176 and it seems that the max length is 1000.

Is there any possibility to paste the longer statement, maybe directly into the database or wherever it is saved?

Cheers, Timo

PS: Later on I can provide the template because I think there are some people which are interested in a Sage template.

 

[edossantos]

No, the limit is 1000 characters. Something you can do to avoid this, is creating a Stored Procedure in your database, which receives the caller number, and executes the long query that it needs. Then, from the template you just need to invoke the stored procedure.

 

[Tm99]

Thank you very much for the feedback. We will go with the stored procedure.