跳到主内容

搜索

搜索

Delay Timeout Error

评论

2 条评论

  • Avatar
    Susan Chen
    版主
    Hi, Nek:


    Can you elaborate more for us on how do you use Bartender with SQL server 2005? This error is a generic message about an IDispatch error. The description might point out more specific problems.

    1)Do you use custom SQL statement in Bartender? Or just get data from SQL server database? Are you using VB or C# and integrate with Bartender?

    2)If you use specific SQL statement, can you try the SQL statement on Microsoft SQL2005 Server Management Studio first to see if it work OK first?



    Thanks!
    0
  • Avatar
    Legacy Poster
    Hello Susan ,

    yes I use a custom SQL Statement . It is the follow

    SELECT SUM(M.QTY1) AS QTY1 , I.CODE2, L.CODE AS ROLON , I.CODE AS MTRL_CODE,I.NAME, M.WHOUSE FROM MTREXTDATA M LEFT JOIN MTRLOT L ON M.MTRLOT=L.MTRLOT LEFT JOIN MTRL I ON L.MTRL = I.MTRL WHERE M.COMPANY=1 AND I.MTRLOTUSE=1 AND I.ISACTIVE=1 AND M.MTRLOT<>0 AND (I.CODE LIKE '%?Артикул%' AND M.WHOUSE = '?Код Склада') AND L.ISACTIVE=1 GROUP BY L.CODE,I.CODE2,I.CODE,I.NAME,M.WHOUSE,I.MTRACN HAVING SUM(M.QTY1)>0 ORDER BY I.CODE, L.CODE

    The strange is sometimes it work's ok and some other times not.

    Thanks in advance.
    0

请先登录再写评论。