|
Hi Vijay
My guess is that the input file is not the format you expect i.e. does not have the header line with the fields that are expected.
If I'm right the colStarts() array won't be set up correctly - that might mean changing the function that creates the array.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
|
|
|
|
|
Hello David,
Hope you remember me.
The application produces thiss error message for only few input files. and more over, the input file is formatted to a desired format, so that the comparision between the 2 files are done easily.
The columns of the 2 files compared are the same.
|
|
|
|
|
Vijay
If you send me a copy of the files I'll have a look and see if I can spot what's wrong.
A copy of the class that is being used might also be useful - not sure I've got one from last year.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
|
|
|
|
|
Thanks for your reply.
Will send you the copy of the files.
|
|
|
|
|
What are the values of lineIn, colStarts(3) and colStarts(4) when the error occurs?
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
|
Brilliant, and what does that tell us?
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
so you get an exception at a specific line, and the message tells you startIndex and length don't fit the string you're working on. The ONLY logical next step is to have a look at the length of the string, and the values of startIndex and length.
startIndex and startIndex+length both must be in the range [0, stringLength] for obvious reasons. Go check it. And fix it. Don't tell me it works most of the time, I don't care. It has to work every time.
|
|
|
|
|
Hello,everyone! I have a question about operating XML file. I need to open a XML file which was a template when the application run, after I've input in TextboxA, the XML file could be saved as a new file in one folder. Then open the saved file again and other Textboxes' text will be written in its elements. (In text_changed event). My question is : I know how to open and save a XML file, but after I save it ,if I want to write new text in it , I need to load the file again?
When I write all text in XML, it would need open--write--save and repeat much times ?I think it is so fool……
So,could you give me some suggestions or help? Maybe I should use thread? But there are so much controls 
Thanks !
|
|
|
|
|
No once you open the XML file original, load it into an in memory object, make all the changes, and write out to file, keep making more changes to the internal memory object, and write out the changes when you want to persist to file.
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|
|
Hi, Dave! Thanks for you rely. But I didn't get it……Could you take an example for me?
Thanks a lot!
|
|
|
|
|
hi,
what is the ms access equivalent code of this.
'written in visual basic.net
Private Sub btnCommon_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCommon.Click, _
btnOK.Click,btnRegister.Click, btnDataTransfer.Click, btnClose.Click
Dim button As Button
button = CType(sender, Button)
'code here
End Sub
Note: there is no Handles in ms access.
i have a small program in access and lots of buttons. i want to hide one button and call all buttons. i dont want to have event in all buttons. that is why i need a code that can call all button. just like above.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
AFAIK there's no typecasting in VBA (or VB6 and before).
Sorry
I don't like my signature at all
|
|
|
|
|
trying to remember those days
but shouldn't you look at control arrays instead?
Control Array example
Other links from Google
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
IIRC you can't use control arrays in Access VBA - they were confined to VB6.
Vaguely recollect a project where we had to do something similar but can't recall it exactly (was about 1999/2000  ).
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
|
|
|
|
|
How do you get the SaveAs dialogue box to appear in VB.Net. With VB6 was it was the commondialog.
What I want is the SaveAs box to appear and I enter the filename and able to put it into a location.
|
|
|
|
|
Try to use the SaveFileDialog object.
|
|
|
|
|
In Excel it is
Application.GetSaveAsFilename and
Application.GetOpenFilename
|
|
|
|
|
Hi. I have two tables. Table1(typeid, desc) table2(markid,desc, tyoeid). I want to delete a record from table1 using one query. I am having referential problem. Guide me a little. Thanks
|
|
|
|
|
Delete child records first(table2) and then delete the parent record.
|
|
|
|
|
I believe you can have a clause on your forgein key which specifies "cascade delete".
Something like this ...
CREATE TABLE test_child <br />
(SUB1 INT, <br />
[NO] int,<br />
FOREIGN KEY ([NO]) REFERENCES Test_parent<br />
ON DELETE CASCADE)
|
|
|
|
|
Created a automated dollar incrementar in vba ms powerpoint. Every second it increments by $20. However i want to see the amount increment from 0 to 20 to 40 etc. it is doing the increments but just shows the end result. tried adding sleep it does show the individual increments. how to resolve?
|
|
|
|
|
|
I have a vb.net application (VS 2008). I want to make the application available for the endusers at offshore.
What is the best way to do the above & how to accomplish it?
Thanks in advance.
|
|
|
|
|
You'll have to rewrite the app to be a web application. If your original app was written with a seperate UI tier, that won't be too difficult. But, if it was written as a monolithic app, you'll have to rewrite the entire thing yourself. There is no conversion tool that will do this for you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
