🚀 go-pugleaf

John MacDonald:
Thanks for your ansewer .
If i add the value to the Query1->SQL on the event of BeforeOpen ,it will be
OK.
But i want to know how can i control the data's transport from calling my
own function on the server.
I can call the server'function and the function can run and i can get the
value except the value of Query1->SQL.
The client's sentence is :
    DataModule2->ClientDataSet1->Active = false;

    i = 0;

    ICanclAcctDisp MyObj;
    MyObj.Bind(CLSID_CanclAcct);
    MyObj.GetUserInfo(i,&wsProvierName,&j);

    DataModule2->ClientDataSet1->ProviderName = wsProvierName;
    DataModule2->ClientDataSet1->Open();
The server's sentence is :
    if (Param1 == 0)
    {       m_DataModule->Query1->Close();

            m_DataModule->Query1->SQL->Text = "select * from XXX where aa <
41";
            * Param2 = WideString("Provider1").Detach();

            * Param3 = m_DataModule->Query1->RecordCount;

            m_DataModule->Query1->Open();
     }

The client send the param to the server,the server return the provider's
name and the recorder's count to the client.
the value of the provider's name and the recorder's count is right.
But the client can't get the values of i had selectted.
It show that "Query1:No SQL statement available"

    Thanks for your answer to me.Waiting for your answer.



                                                            Z.N.





John MacDonald wrote in message <80l0ed$s2v1@forums.borland.com>...
>
>zn :
>
>I would suggest you try putting a watch on the value instead.
>
>
>>ShowMessage(m_DataModule->Query1->SQL->Text);
>>in the event of BeforeOpen of the Query1,it show that the Query1's SQL is
>>NULL.
>
>
>Good luck
>
>JMAC out
>
>