I need to enter the various input values to my application, which will be created in the database dynamically based on the scenario.
I need to know how I can get these values from database with the same column names to Global or Action sheet, which I can use to input to our application.
Say we have an ODBC connection setup called data that points to your Database containing your test data:
Assume the table tblClient contains data regarding a Client (Firstname, Secondname etc)
</font><blockquote><font size="1" face="Verdana, Arial, Helvetica">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">'create The recordset
set rs = createobject("ADODB.RecordSet"
'open the Table tblClient from the DSN called data
rs.open "tblClient", "data",2,3
if not rs.EOF then 'if the table is not blank do stuff
'Find the table entry we want
do while not rs.EOF
if rs("ID" <> someknownID then
firstname = rs("Firstname" 'rs("Firstname"is a column in the table tblClient
secondame = rs("Secondname" 'rs("Secondname"is a column in the table tblClient
set rs = nothing
msgbox secondname</pre><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">Right thats as basic as I can go for now.
I should be able to go into a bit more detail via email.