Forum Discussion

michelle_cox's avatar
michelle_cox
Occasional Contributor
15 years ago

Reading data from database table

I have been able to record keyword tests were data from excel is read and used as input data in my test using the Excel DDT driver (as per the sample video). Is there a similar way to do the same but ...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
15 years ago
Hi, Michelle,



Try something like this.  This is untested, uses DelphiScript, and uses MSSQL but the concepts should be the same and should show how to build something like this.



function GetTableValue;



var

    lADOObject;

    lADOCommandObject;



begin

    lADOObject := DDT.ADODriver;

    lADOConnectObject := DDT.ADODriver.ADOConnectionObject;

    lADOObject.ADOConnectionObject.ConnectionString := Provider = 'SQLOLEDB; User ID = sa; Password = testing; Initial Catalog = QASCRIPTS30; Data Source = qatest02\SQLExpress; LoginPrompt := False;';

    lADOObject.ADOCommandObject.CommandText := 'SELECT Name from Customers where CustomerID = 1';

    Result := lADOObject.Value[0];    

end;