Easy Function - ShowMessage

michael.sch

hy,



i want to use a dictionary value what i saved via a Sql-Query in the ShowMessage function.

I tried the following:





SQLQuery("Warnung|SELECT U_Warntext FROM OCRD WHERE CardCode = $[$4.0.0]")

ShowMessage(ViewData("Warnung"))



and



SQLQuery("Warnung|SELECT U_Warntext FROM OCRD WHERE CardCode = $[$4.0.0]")

ShowMessage(GetData("Warnung"))



but nothing works :/

has anybody an idea how i can access the Dictionary value in the message?



thanks

mike

Lorenz Stierlin

Hello Mike



Thanks for your request.



Try following:



SQLQuery("Warnung|SELECT U_Warntext FROM OCRD WHERE CardCode = '$[$4.0.0]'")

ViewData("Warnung")



I think it was because of the '' in the SQL query and to display it you can just use ViewData.



I hope this will help you.



Kind Regards,

Lorenz