Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 3794

Jun 14th, 2006

error handling in VB6 + + ODBC + MySQL...(Help!!!!)

Expand Post »

hello there,

im doing a program of consolidate database. however, my scope is to do it automatically. so far, i have designed a timer and also codes to insert the data from excel file into MySQL database. then, my idea is whenever there is an error occured in a particular rows of data, the program will capture the rows that have error and put/paste it in one temporary excel files..then continue inserting other rows. does anyone have any idea how to do this. if possible can i have the source code of this. thanx in advance!!

this is part of my program to insert data into the database;

Row = 2
Col = 1
Do While oexcel.Cells(Row, Col) <> ""

rsCVM.MoveFirst

rsCVM.AddNew
rsCVM!USER_NAME = CStr(oexcel.Cells(Row, 1))
rsCVM!DAY = CStr(oexcel.Cells(Row, 2))
rsCVM!USER_ID = CStr(oexcel.Cells(Row, 3))
rsCVM!ADDRESS = CStr(oexcel.Cells(Row, 4))
rsCVM!CONTACT_NO = CStr(oexcel.Cells(Row, 5))
rsCVM!POINT = CSng(oexcel.Cells(Row, 6))

rsCVM.Update
StatBar.Panels(1).Text = "Inserted " & Row - 1 & " data of " & numData & " into database"
Row = Row + 1
Loop

Last edited by naramis; Jun 14th, 2006 at 10:36 pm.

Similar Threads

ASP.NET Crystal Report ODBC MySQL in ASP.NET
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in PHP
help on error handling in mysql ,in primary key in MySQL
ERROR 2002: Can't connect to local MySQL server in MySQL
PHP, ASP, ColdFusion, what's your fav? in IT Professionals' Lounge

naramis

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since May 2006

Permalink

Jun 14th, 2006

Re: error handling in VB6 + + ODBC + MySQL...(Help!!!!)

What kind of errors?

Comatose

Team Colleague

Reputation Points: 361

Solved Threads: 214

Taboo Programmer

Offline

2,413 posts
since Dec 2004

Permalink

Jun 15th, 2006

Re: error handling in VB6 + + ODBC + MySQL...(Help!!!!)

Hi,
Thanx for ur quick reply. Anyway, the error that will possibly occured is type (format) or length of the data that to be inserted are not the same as been declared in the table in MySQL database.
Thanx.

naramis

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since May 2006

Permalink

Jun 15th, 2006

Re: error handling in VB6 + + ODBC + MySQL...(Help!!!!)

you can use vartype to see if a variable is of a given data type.... for example:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
If VarType(hWndOrForm) = vbLong Then
    ' /* Set hWnd To The Value Of The Passed Long */
    hwnd = hWndOrForm
Else
    ' /* Otherwise, It's A Form That Has been passed... Grab It's Handle */
    hwnd = hWndOrForm.hwnd
End If
If VarType(hWndOrForm) = vbLong Then
    ' /* Set hWnd To The Value Of The Passed Long */
    hwnd = hWndOrForm
Else
    ' /* Otherwise, It's A Form That Has been passed... Grab It's Handle */
    hwnd = hWndOrForm.hwnd
End If

checks to see if the variable is of type long. If it's about formatting, you can use the format$ function to reformat the data they posted (for example, a date in the wrong layout), or you could split apart the string and see if unauthorized characters (letters in a currency field) are found...

Comatose

Team Colleague

Reputation Points: 361

Solved Threads: 214

Taboo Programmer

Offline

2,413 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Opening a form on click event in a different File

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Boolean checking

DaniWeb Message

Cancel Changes

User Name
Password