Help Displaying Query

[Myst5]

I have this code so far

sn1 = Input.GetText("Input1");

db = "AutoPlay\\Docs\\M.mdb"
Query1 = "Select * FROM Contacts WHERE SN = '"..sn1.."'"

result = DLL.CallFunction("AutoPlay\\Docs\\xMDB.dll", "Query_Update_MDB", "\""..db.."\",\""..Query1.."\"", DLL_RETURN_TYPE_STRING, DLL_CALL_STDCALL)

And I want to display the result in a RichText Object

Could Someone help me
Thanks in advance

[limboo]

you mean



sn1 = Input.GetText("Input1");

db = "AutoPlay\\Docs\\M.mdb"
Query1 = "Select * FROM Contacts WHERE SN = '"..sn1.."'"

result = DLL.CallFunction("AutoPlay\\Docs\\xMDB.dll", "Query_Update_MDB", "\""..db.."\",\""..Query1.."\"", DLL_RETURN_TYPE_STRING, DLL_CALL_STDCALL)
RichText.SetText("RichText1", ""..result, true);

[Myst5]

Thanks for the suggestion but it is not working
Any other ideas?

[Ulrich]

It seems that you are forgetting to inform the password.

Ulrich

[Myst5]

I have no password
All of my other queries do not have password set and they are working just fine

[Myst5]

When i added the password it returned OK
but i want to see the recors in the db
so i have a table contacts and fields name, lastname and sn
what i am trying to do is find all records that have the same sn display them in richtext or grid object so i can edit them

is there someone who can help me do that
thanks again for your replys

[Ulrich]

Looks like you should study the example code provided with the dll, to see how to store the results in a table and retrieve the records, no?

[Myst5]

ok
that's what i'm going to do
thanks for your time

[reteset]

this Example shows detailed usage of xMDB.dll
also it contains answer of question that you asked

http://www.indigorose.com/forums/showthread.php?t=20828