Thinker

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Thinker

Forum for story


    ----------pCount()--------

    Aueeins
    Aueeins
    Aueeins
    呢喃的歌声


    帖子数 : 205
    积分 : 5039
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG
    • Post n°1

    ----------pCount()-------- Empty ----------pCount()--------

    Post by Aueeins 2011-10-12, 10:56 am

    vpSource="LAW"

    SELECT * FROM m10DocRegistry WHERE 1=1 AND RefType = '1999/3361-04' AND Filegroup='LAW'


    ========


    vpSearchItem1="CASE"

    vpSearchItem3 = !ClientContactType & ""
    vpSearchItem4 = !ClientId & ""
    vpSearchItem5 = !ClientName & ""
    vpSearchItem6 = !ClientRef & ""

    SELECT * FROM m01Notes WHERE 1=1 AND KeyModule = 'CASE' AND KeyField = '"&&"'
    • Back to top
    Aueeins
    Aueeins
    Aueeins
    呢喃的歌声


    帖子数 : 205
    积分 : 5039
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG
    • Post n°2

    ----------pCount()-------- Empty Re: ----------pCount()--------

    Post by Aueeins 2011-10-12, 11:03 am

    1.做pCount，通常会有btnDocument \ btnNotes or btnMemo \ btnEvents
    为了显示其内部的数据的数量（Rowcount(ds)）
    2.结合VB6，去查找---唯一能够标示特定数据的两个Fields!!（比如Filegroup='LAW' + RefType ='" & GetDgvItem(dgv08Case, "CaseNumber")"'）
    3.通过vSql10DocRegistry（即最后执行的那一个语句）Immediate查看SQL语句，其中即是pCount的str所需要的部分！
    • Back to top
      Current date/time is 2024-05-19, 11:21 pm