Simple Q

Apocolypse2005 · August 7th, 2007, 11:47 AM

What does ...

Type Mismatch

Error Code '13'

...mean?

It gets thrown when this code is executed

Code:

If sTitle Or sArtist Or sAlbum Or sGenre Or sLength Or sKey = "" Then

This code is executed by a function called ValidateInput

Code:

Public Function ValidateInput(sTitle As String, sArtist As String, sAlbum As String, sGenre As String, sLength As String, sKey As String) As Boolean

Now i assume that this above means that you can set validateinput as true or false or return it as true or false when its executed some code within or called outide its function.

So on this assumption i tried writing this in a cmdAdd_Click

Code:

ValidateInput = False
Call ValidateInput(txtTitle.Text, txtArt.Text, txtAlb.Text, txtGen.Text, txtLen.Text, txtKey.Text)   
If ValidateInput = True Then
Call AddToGrid(txtTitle.Text, txtArt.Text, txtAlb.Text, txtGen.Text, txtLen.Text, txtKey.Text)
Else
Exit Sub 'this is because if ValidateInput returns false it already handled within the function
End If

But this throws a compile error

Function call on left-hand side of assignment must return Variant or Object

And this means...?

Two questions there, in simple terms
What does Type Mismatch, code '13' mean?
What does Function call on left-hand side of assignment must return Variant or Object mean?

Thanks for any help

------------------------------------------------
Apocolypse2005
Always ready and waiting to be helped!

gbianchi · August 7th, 2007, 12:00 PM

hi there..

step by step:

Code:

If sTitle Or sArtist Or sAlbum Or sGenre Or sLength Or sKey = "" Then

you are trying to compare every string with ""?? if that is the case, vb doesn't handle the if this way (in fact I think that any language do that this way)...
you have to compare every string with = "" something like this:

Code:

If sTitle = "" Or sArtist = "" Or sAlbum  = "" Or = "" sGenre = "" Or sLength = "" Or sKey = "" Then

the error is telling you that it can't convert the strings to boolean (because OR compares boolean values ;) )

your second problem is easily solved if you have option explicit set to on...
since ValidateInput is a function, you cannot assign a value to it (you are doing that when:

Code:

ValidateInput = False

)

you have two ways to do this:
1. Store the returned value of this function in a new variable (maybe ReturnedValue) and then do the if...
2. write the if with the function (ugly to see, but the same result)

Examples:

1.

Code:

dim ReturnedValue as boolean
returnedvalue = ValidateInput(txtTitle.Text, txtArt.Text, txtAlb.Text, txtGen.Text, txtLen.Text, txtKey.Text)   
If returnedValue Then
    AddToGrid(txtTitle.Text, txtArt.Text, txtAlb.Text, txtGen.Text, txtLen.Text, txtKey.Text)
Else
    Exit Sub 'this is because if ValidateInput returns false it already handled within the function
End If

2.

Code:

if ValidateInput(txtTitle.Text, txtArt.Text, txtAlb.Text, txtGen.Text, txtLen.Text, txtKey.Text) Then
    AddToGrid(txtTitle.Text, txtArt.Text, txtAlb.Text, txtGen.Text, txtLen.Text, txtKey.Text)
Else
    Exit Sub 'this is because if ValidateInput returns false it already handled within the function
End If

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Apocolypse2005 · August 7th, 2007, 01:39 PM

Can i just ask, what is option expplicit?

gbianchi · August 7th, 2007, 01:43 PM

by default, VB doesn't need to have the variables declared, which is a awfull way of work.. by adding option explicit to the top of every form, class, module you force declaration of every variable you use...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Apocolypse2005 · August 7th, 2007, 03:08 PM

Oh is that why when you upgrade ur vb6 projects to vb2005 it shows a load of cautionsay variable not declared yet?!

gbianchi · August 8th, 2007, 08:04 AM

probably... and sometimes you need to initialize them too...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========