-
Mar 31st, 2006, 12:33 AM
#1
Thread Starter
Junior Member
[RESOLVED] runtime error '6':overflow
hi gurus..
i need your help after a week been looking for this solution and hope i'm in the correct track.
i run a VB6 application called CRF which i bought it from a developer. there's an interface to upload data from c: into the database (mssql).
so the problem is right now, when i want to upload data yesterday, it prompted runtime error 6: overflow which before this it can be run successfully.
anyone can explain to me what had happened and how to resolve it. and for your info, i haven't touch the source code because i didn't get the source code since the application purchased. when i refer to the internet, apparently the problem is with the source code. so here i don't think some command had changed right?
i tried to reinstall the application. fortunately, the data can be uploaded but when the second time i want to do the same thing, the runtime error had prompted once again.
what shoul i do?..
thank you in advance.
-
Mar 31st, 2006, 12:37 AM
#2
Re: runtime error '6':overflow
this is a problem with the data supplied thru the interface. you would have sent a double value to an integer variable. so, first check your data, change it and try once again and see it..hope it will work.. and this error is not handled in your application.
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
Mar 31st, 2006, 01:56 AM
#3
Thread Starter
Junior Member
Re: runtime error '6':overflow
Originally Posted by ganeshmoorthy
this is a problem with the data supplied thru the interface. you would have sent a double value to an integer variable. so, first check your data, change it and try once again and see it..hope it will work.. and this error is not handled in your application.
thank you sir for your reply. i really appreciate it.
what do you mean by double value of integer anyway, sir? is it while upload the data, there are duplicates data? i've checked and retried however the error is still appear.
glad to hear it is nothing to do with the source code because i never know bout it
i also tried with a couple of another data..but still got the same error.
what should i do next?
-
Mar 31st, 2006, 12:38 AM
#4
Frenzied Member
Re: runtime error '6':overflow
well that happens when a variable cant contain the data which is assigned to it.
for example, you declared a variable a as integer and you did something like
a = 10 / 3
this one returns an error because that computation does not return an integer. it returns a double.
so therefore, the problem is with the source code.
On error goto Trap
Trap:
in case of emergency, drop the case...
****************************************
If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option. if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
-
Mar 31st, 2006, 01:29 AM
#5
Re: runtime error '6':overflow
Originally Posted by d3gerald
well that happens when a variable cant contain the data which is assigned to it.
That is true.
Originally Posted by d3gerald
for example, you declared a variable a as integer and you did something like
a = 10 / 3
this one returns an error because that computation does not return an integer. it returns a double.
Your example is not true. If a is an integer, your example would return 3 without causing an error. VB will 'coerce' the return value to fit the declared data type if it can. If it can't, then you will get an error. For example:
VB Code:
Dim a as Integer
a = 65535
This would cause an error because an integer (in VB speak) can only hold numbers between -32768 and +32767.
Pete
No trees were harmed in the making of this post, however a large number of electrons were greatly inconvenienced.
-
Mar 31st, 2006, 01:59 AM
#6
Thread Starter
Junior Member
Re: runtime error '6':overflow
Originally Posted by pnish
That is true.
Your example is not true. If a is an integer, your example would return 3 without causing an error. VB will 'coerce' the return value to fit the declared data type if it can. If it can't, then you will get an error. For example:
VB Code:
Dim a as Integer
a = 65535
This would cause an error because an integer (in VB speak) can only hold numbers between -32768 and +32767.
ermm..you're saying here is something to do with the source code right?
but how come before this, without i know bout the source code which i didn't get it earlier as well, the upload function can be run?
or is it updates or patches issue?
-
Mar 31st, 2006, 01:37 AM
#7
Frenzied Member
Re: runtime error '6':overflow
ohh, sorry, i haven't worked with integers nowadays.
On error goto Trap
Trap:
in case of emergency, drop the case...
****************************************
If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option. if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
-
Mar 31st, 2006, 02:00 AM
#8
Member
Re: runtime error '6':overflow
It could also be because you're passing too much data in, so you could try splitting up a file if you have a huge file you're passing to it. For example, this would cause an overflow error:
Dim i As Integer
Do Until i > 32767
i = i + 1
Loop
If for example you're passing a large Excel or text file to your app which contains over 32767 lines in it, then you could try splitting it up. Without looking at the source code though and knowing what the app is trying to do it's all going to be guess work as to where it's falling over. Your best bet would probably be to mail the software vendors and ask them to fix their code.
-
Mar 31st, 2006, 02:07 AM
#9
Thread Starter
Junior Member
Re: runtime error '6':overflow
Originally Posted by l12ngo
It could also be because you're passing too much data in, so you could try splitting up a file if you have a huge file you're passing to it. For example, this would cause an overflow error:
Dim i As Integer
Do Until i > 32767
i = i + 1
Loop
If for example you're passing a large Excel or text file to your app which contains over 32767 lines in it, then you could try splitting it up. Without looking at the source code though and knowing what the app is trying to do it's all going to be guess work as to where it's falling over. Your best bet would probably be to mail the software vendors and ask them to fix their code.
thank u friend..
i've tried that as well. even i tried to upload only 1 data in 1 time..
the error still came up.
the problem is i didnt get any support from the vendor anymore. they're gone with the wind
or is it possible if my sql server problem? might be it is full or something? but it is a fool guess i think..
-
Mar 31st, 2006, 02:20 AM
#10
Member
Re: runtime error '6':overflow
I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.
Is CRF the full name of the application (or an abreviation) and do you know what the vendors name is or was? Also, what does the app do, just load a single type of file to the database (in which case is it an Excel file or something similar?) or does it grab all the files on your hard drive?
-
Mar 31st, 2006, 02:27 AM
#11
Re: runtime error '6':overflow
Originally Posted by l12ngo
I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.
Is CRF the full name of the application (or an abreviation) and do you know what the vendors name is or was? Also, what does the app do, just load a single type of file to the database (in which case is it an Excel file or something similar?) or does it grab all the files on your hard drive?
you are right.if problem was on the db side .the error message would come from the db i.e the error message (description) will show the error code that was encountered on the db side .but i dont think thats the problem here.so may be its a flaw in the coding itself
__________________
________________0îîî___
___îîî0________(___)____
__(___)_________) _/_____
___\_ (_________(_/______
____\_)_________________
-
Mar 31st, 2006, 04:06 AM
#12
Thread Starter
Junior Member
Re: runtime error '6':overflow
Originally Posted by l12ngo
I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.
Is CRF the full name of the application (or an abreviation) and do you know what the vendors name is or was? Also, what does the app do, just load a single type of file to the database (in which case is it an Excel file or something similar?) or does it grab all the files on your hard drive?
in the setup.exe the application name is CRF.exe. actually this is such a tracking system for my company to track the inventory in our warehouse. the application will upload from a notepad named MRDATA.txt from C: which the fields are OPID, Subscriber, ContractNo, Product, Media barcode, Media Name, Location code, time and date.
-
Dec 8th, 2010, 02:46 AM
#13
New Member
Re: runtime error '6':overflow
if run time error -6 overflow is coming
then
just change the integer data type to long...........
as a result it can hold more than 32767 data ....
-
Mar 31st, 2006, 02:03 AM
#14
Re: runtime error '6':overflow
or maybe the amount of data u uploaded is more than what ur app can hold or handle.check it in the documentation if any such limits have been mentioned
__________________
________________0îîî___
___îîî0________(___)____
__(___)_________) _/_____
___\_ (_________(_/______
____\_)_________________
-
Mar 31st, 2006, 02:52 AM
#15
Member
Re: runtime error '6':overflow
It could also be down to the actual data you're passing to it. Say for example (just working with integers again), you've been passing order numbers to the app via your file, the app could be then taking that order number and assigning it to a variable which now can no longer cope with the data because you've reached the limit (badly explained so here's an example)
Data file 1 contains:
OrderNo: 32764
OrderNo: 32765
OrderNo: 32766
Run app and it works because it assigns the number to a variable which has been declared as an integer. Then, when you run against Data File 2:
Data file 2 contains:
OrderNo: 32767
OrderNo: 32768
OrderNo: 32769
App will return an overflow error.
Having said all this, this wouldn't explain why the app would run the first time after installation, but fail the second. Does the app still work if you close it then re-open it? If so it may be storing the data into a global variable, which doesn't get cleared till the app is closed.
There's so many ways this could be failing it's going to be really tough for you I'm afraid
-
Mar 31st, 2006, 04:15 AM
#16
Re: runtime error '6':overflow
do you remember when it was working fine what are the data you have uploaded. if you try with same set of data are you getting errors....
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
Mar 31st, 2006, 04:53 AM
#17
Thread Starter
Junior Member
Re: runtime error '6':overflow
Originally Posted by ganeshmoorthy
do you remember when it was working fine what are the data you have uploaded. if you try with same set of data are you getting errors....
last week it still work well and the data format is just the same..
-
Mar 31st, 2006, 05:07 AM
#18
Re: runtime error '6':overflow
i'm asking about the data not data format...please clarify, if the same data and error then you have to call the vendor, no other way (you can play with your db, but you should be careful when doing this) or if no error for same data then you have to check the data
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
Apr 2nd, 2006, 08:31 AM
#19
Thread Starter
Junior Member
Re: runtime error '6':overflow
these are samples of the data :-
1234 MIH OSS0000093 T MIH 00414646 SRS260505 00384898 25/02/2006 15:03:34
1234 MIH OSS0000093 T MIH 00414645 SIGN260505 00384897 25/02/2006 15:04:01
pls make me clear what is data and data format?
anyway, one more thing, when i run and pull the database (sql server) locally (127.0.0.1) from my pc..the program and the upload interface run properly and the data can be uploaded succesfully..
???
-
Apr 6th, 2006, 02:39 AM
#20
Thread Starter
Junior Member
Re: runtime error '6':overflow
my problem is now had settled..thanks to all the thread under this topic guys..
there's a file in setup program didn't install together during the installation. fortunately i've copied the tiptop file so i just copy it into the folder.
but i'm still confused why sometimes the file is missing, report cant be generated and other runtime errors in the application because i'm pretty sure i didn't touch anything since the first installation.
apparently i need to get the coding, no matter what huh...
anyway, thank u very much guys
-
Apr 6th, 2006, 02:53 AM
#21
Re: [RESOLVED] runtime error '6':overflow
fine...protect the system files, so that it will not be deleted without your knowledge
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
Apr 7th, 2006, 05:01 AM
#22
Thread Starter
Junior Member
Re: [RESOLVED] runtime error '6':overflow
i've got it clearly now..
the data itself is giving me all this headache
ermm..when i try with another stack of data..the upload process is going well..
how can data can be currupted, anyway?? eventhough it is still with the same file??
what can cause it?
-
Apr 12th, 2006, 12:00 AM
#23
Thread Starter
Junior Member
Re: [RESOLVED] runtime error '6':overflow
is there any hint sir, which data can be overflow??
-
Apr 12th, 2006, 12:25 AM
#24
Re: [RESOLVED] runtime error '6':overflow
when a value to a variable exceeds the overflow error occurs...if you assign more than 32767 then it causes this....
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
May 5th, 2014, 03:21 PM
#25
New Member
Re: [RESOLVED] runtime error '6':overflow
Originally Posted by alinysyahril
which i bought it from a developer
because i didn't get the source code since the application purchased.
I have a similar problem with a program that was written in the late 90's. My issue turned out to be the fact that the application saves it's last screen location (Top, Left, Height, Width) to the registry and somewhere in the stream that restores the position, variables are declared as Integer. With a multi screen environment, it is pretty easy to get Left to exceed 32767, and the next time the application runs up pops the "runtime error '6': overflow". The oddest bit of this is that it doesn't seem to have any problem saving values over 32767! It seems to happen just rarely enough that I forget what the problem is and have to rediscover it every time. (the older I get the shorter that period of time is...) I'm actually posting to this thread because it is the one that shows up each time I Google the issue.
-
Jul 20th, 2014, 05:53 AM
#26
New Member
Re: [RESOLVED] runtime error '6':overflow
no any code for sum of numbers in col 1?
-
Jul 20th, 2014, 05:54 AM
#27
New Member
Re: [RESOLVED] runtime error '6':overflow
no any way for fix particular col in msflexgrid?
-
Jul 20th, 2014, 05:58 AM
#28
New Member
Re: [RESOLVED] runtime error '6':overflow
no any way for numbers frequency in msflexgrid vb6?
-
Jul 20th, 2014, 05:50 AM
#29
New Member
Re: [RESOLVED] runtime error '6':overflow
hi
please help me
in msflexgrid vb6 :
dim x
With MSFlexGrid1
x = .Row
For x = 1 To 500
.TextMatrix(x, 3) = Format(.TextMatrix(x, 2) / .TextMatrix(x, 1), "standard")
Next x
End With
if .TextMatrix(x, 1) = 0 , occurs error runtime 6 overflow
why vb unable do 0/0 or 1/0 ,no any idea?????????
-
Jul 20th, 2014, 09:52 PM
#30
Re: [RESOLVED] runtime error '6':overflow
@madeaz,
Please Do not bump and hijack topics Start your own thread.
when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
https://get.cryptobrowser.site/30/4111672
-
Jul 22nd, 2014, 01:38 AM
#31
Re: [RESOLVED] runtime error '6':overflow
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|