Forum Discussion

markhost's avatar
markhost
Visitor
10 years ago

How an I get TestComplete to recognize "is null" in a DB query?

I am trying to use a DB variable to pull some data to use for testing, but TestComplete doesn't seem able to recognize the "is null" keyword.  My query is in the form of:   SELECT field1, field2,...
ghuff2's avatar
ghuff2
Contributor
10 years ago

You might need to select the proper Providor/Driver for connecting to the specific database you have. For instance I connect to a remote SQL Server database, and I needed to install and use the SQL Server Native Client.

 

Just for reference here's where I'm talking about setting it in TestComplete:

 

 

If you are using the default Microsoft ODBC driver it might not have the IS NULL functionality. You'll have to research installing the proper driver for the database you are trying to connect to. Though if it's working through your DB admin tool then it's most likely already installed.