Verifying the result of a SELECT using VBScript

Sat, 23 Apr 2011 22:56:52 GMT

Hi,

I'm creating a VBScript sub to read from a SQL Server table. The select reads records filtering from a particular primary key value passed by a QV variable.

I have sSQL = "SELECT TOP 1 Code FROM myTable where code = '" & varCodeValue & "'".

When it exists a record for code value I can control the select result with sSQL.Fields(0).Value, but when no records are found I have an error.

How can I verify when my select returns no records? Thanks

Verifying the result of a SELECT using VBScript

deepakk — Sun, 24 Apr 2011 07:39:53 GMT

hi,

Check if its len is greater than zero. Something like below

if len(trim(sSQL.Fields(0).Value)) >0 then

store value

else

exit script.

end if

topic Verifying the result of a SELECT using VBScript in QlikView

Verifying the result of a SELECT using VBScript

Verifying the result of a SELECT using VBScript