Why DAODataControl missing items last?

Posted by: dongtrien on 4 August 2017, 3:20 pm EST

  • Posted 4 August 2017, 3:20 pm EST

    <span id="result_box" class=""><span class="hps">Why do</span> <span class="hps">I</span> <span class="hps">use</span> <span class="hps">DAODataControl</span> <span class="hps">query</span><span class="">,</span> <span class="hps">the total number of</span> <span class="hps">items</span> <span class="hps">missing</span> 1 <span class="hps">items</span><span>, but</span> <span class="hps">if</span> <span class="hps">I copy</span> <span class="hps">that query</span> <span class="hps">in</span> <span class="hps">Microsoft</span> <span class="hps">Access</span> <span class="hps">to</span> <span class="hps">records</span> <span class="hps">not</span> <span class="hps">missing</span><span class=""> ?</span></span>
  • Replied 4 August 2017, 3:20 pm EST

    <span id="result_box" class=""><span class="hps">I</span> <span class="hps">send</span> <span class="hps">an attachment</span> <span class="hps">when</span> <span class="hps">you</span> <span class="hps">run</span> <span class="hps">prjMain.vbp</span> <span class="hps">has</span> <span class="hps">58</span> <span class="hps">items</span><span>, but</span> <span class="hps">running</span> <span class="hps">SQL</span> <span class="hps">of</span> <span class="hps">Microsoft Access</span> <span class="hps">has</span> <span class="hps">59</span> <span class="hps">items</span><span>,</span> <span class="hps">you</span> <span class="hps">see the</span> <span class="hps">picture</span><span>:</span> <span class="hps">58Item.jpg</span><span>,</span> <span class="hps">58Item2.jpg</span><span>,</span> <span class="hps">59Item.jpg</span></span>
    2011/03/miss_item_last.rar
  • Replied 4 August 2017, 3:20 pm EST

    Hello,

    Please copy the sql query that you are writing that displays this behavior.

    Regards,
    Prantik
  • Replied 4 August 2017, 3:20 pm EST

    Hello,

    Thank you for the files.I will check this and get back to you soon.

    Regards,
    Prantik
  • Replied 4 August 2017, 3:20 pm EST

    Thanks for letting us know that the issue has been resolved.
    I would also like to suggest to use the Debug window rather than using MsgBox as the Message Box will block the further operation of the code until user clicks on any of the buttons on the message box.


  • Replied 4 August 2017, 3:20 pm EST

    <span id="result_box" class=""><span class="hps">I</span> <span class="hps">figured out</span> <span class="hps">the cause</span><span>,</span> <span class="hps">because</span> <span class="hps">my</span> <span class="hps">computer</span> <span class="hps">is</span> <span class="hps">the processor</span> <span class="hps">running</span> <span class="hps">too fast</span><span>,</span> <span class="hps">if</span> <span class="hps">I insert</span> <span class="hps">MsgBox</span> <span class="hps">statement</span> <span class="hps atn">"</span><span>was</span> <span class="hps">processed</span><span>"</span><span>,</span> <span class="hps">vbOKOnly</span><span>,</span> <span class="hps atn">"</span><span>warning</span> <span class="hps">...".</span> <span class="hps">the</span> <span class="hps">first</span> <span class="hps">57</span> <span class="hps">lines</span> <span class="hps">of</span> <span class="hps">SQL</span> <span class="hps">report</span> <span class="hps atn">'</span><span>have</span> <span class="hps">got</span> <span class="hps">SQL</span> <span class="hps">Group</span>
        <span class="hps">sqlTmpGiaoDich</span> <span class="hps">=</span> <span class="hps">...</span><span>,</span> <span class="hps">to</span> <span class="hps">start</span> <span class="hps">the</span> <span class="hps">program</span> <span class="hps">stopped</span> <span class="hps">in</span> <span class="hps">click</span> <span class="hps">ok</span> <span class="hps">and</span> <span class="hps">then</span> <span class="hps">run the</span> <span class="hps">program</span> <span class="hps">is</span> <span class="hps">to</span> <span class="hps">accurately and</span> <span class="hps">answer</span> <span class="hps">thank</span> <span class="hps">you</span></span>
  • Replied 4 August 2017, 3:20 pm EST

    Ok, I understand that.
    Let me know if you have further questions regarding this.
  • Replied 4 August 2017, 3:20 pm EST

    <span id="result_box" class=""><span class="hps">I</span> <span class="hps">used</span> <span class="hps">Debug</span> <span class="hps">but</span> <span class="hps">not found</span> <span class="hps">the cause</span> <span class="hps">because</span> <span class="hps">when</span> <span class="hps">I</span> <span class="hps">debug</span> <span class="hps">and</span> <span class="hps">seen</span> <span class="hps">enough</span> <span class="hps">items</span><span>,</span> <span class="hps">but when</span> <span class="hps">I</span> <span class="hps">press</span> <span class="hps">F5</span> <span class="hps">to</span> <span class="hps">run</span> <span class="hps">miss 1 record</span><span>.</span> <span class="hps">after</span> <span class="hps">I</span> <span class="hps">send the</span> for example <span class="hps"></span> <span class="hps">to you</span> <span class="hps">and</span> <span class="hps">you</span> <span class="hps">say</span> <span class="hps">is</span> <span class="hps">still</span> <span class="hps">enough</span> <span class="hps">items</span><span>,</span> <span class="hps">I thought</span> <span class="hps">about</span> <span class="hps">the</span> <span class="hps">machine</span> <span class="hps">running</span> <span class="hps">so fast,</span> <span class="hps">machine no time to</span> <span class="hps">update</span> <span class="hps">the last</span> <span class="hps">record</span> <span class="hps">so</span> <span class="hps">I</span> <span class="hps">thought</span> <span class="hps">to</span> <span class="hps">insert</span> <span class="hps">a</span> <span class="hps">command</span> <span class="hps">to</span> <span class="hps">stop</span> <span class="hps">little seconds</span> for <span class="hps">machines</span><span class="hps"></span><span>,</span> <span class="hps">I</span> <span class="hps">have not</span> <span class="hps">found</span> <span class="hps">any</span> <span class="hps">command</span> <span class="hps">to</span> <span class="hps">stop</span> <span class="hps">a few</span> <span class="hps">seconds</span><span>,</span> <span class="hps">so</span> <span class="hps">I</span> <span class="hps">try to</span> <span class="hps">insert a</span> <span class="hps">MsgBox</span> <span class="hps">command</span><span>,</span> <span class="hps">after</span> <span class="hps">I</span> <span class="hps">insert</span> <span class="hps">MsgBox</span>, <span class="hps"></span><span class="hps"></span> <span class="hps">results</span> <span class="hps">as</span> <span class="hps">expected</span><span>,</span> <span class="hps">I'm</span> <span class="hps">looking for</span> command <span class="hps">stop few seconds</span> for machine <span class="hps">to replace</span> <span class="hps">MsgBox</span> <span class="hps">command.
    </span></span>
  • Replied 4 August 2017, 3:20 pm EST

    <span id="result_box" class=""><span class="hps">I am currently</span> <span class="hps">using</span> <span class="hps">ar2ProEval2.5.0.1309.exe</span><span>,</span> <span class="hps">then</span> <span class="hps">I</span> <span class="hps">download</span> <span class="hps">and</span> <span class="hps">install</span> <span class="hps">ar2ProSP2.5.0.1322.exe</span> <span class="hps">superimposed</span> <span class="hps">on</span> <span class="hps">the machine</span> <span class="hps">but</span> <span class="hps">failed</span> <span class="hps">on</span></span>
  • Replied 4 August 2017, 3:20 pm EST

    Hello,

    Please try uninstalling the earlier build from control panel->add and remove programs.Then try running the installer for the latest build.

    Regards,
    Prantik
  • Replied 4 August 2017, 3:20 pm EST

    Hello,

    I am able to find the 59th item when I run your sample at my end.<span class="txt4">I am attaching a screenshot of the last page of
    the report shown at my end .I think this output is correct.

    </span>However,I am using build <span class="txt4">2.5.0.1322.What is the build that you are using? If you are on an older one,you may try upgrading to the latest one from this link.

    Regards,
    Prantik


    </span>

  • Replied 4 August 2017, 3:20 pm EST

    Hello,

    Unfortunately, I am not clear about your requirement. Could you please elaborate a little of what exactly are you trying to achieve? When I ran the sample that you had attached,I was able to see the 59th record as well.Are you still unable to see the same?

    Regards,
    Prantik
  • Replied 4 August 2017, 3:20 pm EST

    <span id="result_box" class=""><span class="hps">I</span> <span class="hps">want to</span> <span class="hps">find the</span> <span class="hps">equivalent commands</span> <span class="hps">can</span> <span class="hps">replace the</span> <span class="hps">MsgBox</span> <span class="hps">to</span> <span class="hps">wait</span> <span class="hps">for</span> <span class="hps">a</span> <span class="hps">computer</span> <span class="hps">that</span> <span class="hps">period</span> <span class="hps">instead</span> <span class="hps">I</span> <span class="hps">have to click</span> <span class="hps">OK</span> <span class="hps">to</span> <span class="hps">run</span> <span class="hps">next</span><span class="">?</span></span>
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels