Why DAODataControl missing items last?

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

  • Posted 4 August 2017, 3:20 pm EST

    Why do I use DAODataControl query, the total number of items missing 1 items, but if I copy that query in Microsoft Access to records not missing ?
  • Replied 4 August 2017, 3:20 pm EST

    I send an attachment when you run prjMain.vbp has 58 items, but running SQL of Microsoft Access has 59 items, you see the picture: 58Item.jpg, 58Item2.jpg, 59Item.jpg
    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

    I figured out the cause, because my computer is the processor running too fast, if I insert MsgBox statement "was processed", vbOKOnly, "warning ...". the first 57 lines of SQL report 'have got SQL Group
        sqlTmpGiaoDich = ..., to start the program stopped in click ok and then run the program is to accurately and answer thank you
  • 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

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

    I am currently using ar2ProEval2.5.0.1309.exe, then I download and install ar2ProSP2.5.0.1322.exe superimposed on the machine but failed on
  • 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.I am attaching a screenshot of the last page of
    the report shown at my end .I think this output is correct.

    However,I am using build 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




  • 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

    I want to find the equivalent commands can replace the MsgBox to wait for a computer that period instead I have to click OK to run next?
Need extra support?

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

Learn More

Forum Channels