I have the error "Microsoft SQL Native Client Query timeout exceeded" when I execute a query in custom Form in Great Plains (GP).
What Can I do ?
*This post is locked for comments
I have the error "Microsoft SQL Native Client Query timeout exceeded" when I execute a query in custom Form in Great Plains (GP).
What Can I do ?
*This post is locked for comments
OpenRsro "SELECT DISTINCT CHEKBKID,CHEKNMBR, CHEKDATE, CHEKAMNT, VENDNAME FROM dbo.Chequescontabilizados WHERE CHEKBKID= '" + Me.cbocuenta.Value + "' AND (CHEKNMBR between '" + Trim(NumCheque1) + "' AND '" + Trim(NumCheque2) + "')", rs, cn
And the form is a customized form : printing of ckeck lote
the query:
OpenRsro "SELECT DISTINCT CHEKBKID,CHEKNMBR, CHEKDATE, CHEKAMNT, VENDNAME FROM dbo.Chequescontabilizados WHERE CHEKBKID= '" + Me.cbocuenta.Value + "' AND (CHEKNMBR between '" + Trim(NumCheque1) + "' AND '" + Trim(NumCheque2) + "')", rs, cn
And the form is a customized form : printing of ckeck lote
>>>> The first thing you can do is show us the form and the query you are talking about.>>>>
: D
The first thing you can do is show us the form and the query you are talking about.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156