Run-Time Error '3421'

"Application uses a value of the wrong type for the current operation"

This error will appear on your current environment specially if you are working Sql Server 
stored procedure and call it via VB6. To fixed this problem, you can double check the Data 
Type fields on your database and make it sure that you assign it on their respective data types
and also on your Stored Procedure, this is a sample,assigning on its corresponding Data Types













As you can see at the image above the data types on each field will exactly fit or accurate on
each column name, and make it sure your stored procedure will set on its corresponding data
types:

Hope this will Help ^_^
The Hardest thing to to is yo Do Nothing ^_^
Continue Reading with Borgy's Blog »
These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Furl
  • Reddit
  • Spurl
  • StumbleUpon
  • Technorati

How to Use A Boolean Data Types in V6

Hello guys this sample code,i will show to you on how to use a Boolean Data Types on your
own Visual Basic Program

first you must Declare it,whether on a Module for the user can access it or used it all the time,
or in a Control Event like Load,click,Mose-move event etc...

 we can code it like this

Public Adrian As Boolean or 
Dim Adrian As Boolean

Note:
Boolean Data Types can only Holds a
True And False Statement

We can use it via code like shown below:
'i declare it via General declaration
Dim Adrian As Boolean

Private Sub Form_Load()
    Adrian=True
 End Sub

Private Sub Command1_click()
    If Adrian=True then
          MsgBox"Boolean is True"
    End If
End Sub

Happy Coding!!!!
Continue Reading with Borgy's Blog »
These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Furl
  • Reddit
  • Spurl
  • StumbleUpon
  • Technorati

Copyright @ Codes-47.Blogspot.Com. Powered by Blogger.