|
You said that you are allowed to add a new column, so I assume that you are free to adapt the table structure.
If I were you, I would separate the < and > type characters from this column into its own column. Then transform the original column to type int, and simply adapt any queries or code to take both columns into account instead of only the one.
This means that you may have to adapt the query that got the data into this column to begin with, so that it separates the two value types (integers and < / >).
My advice is free, and you may get what you paid for.
|
|
|
|
|
|
Hi friends,
how to avoid flickering of tooltip? This application was done using vs-2003 and is working fine.But after converting it to vs-2008,flickering problem has arised .Please guide me in sorting out this issue.
Thanks,
Prasad
|
|
|
|
|
When you say flickering do you mean it is blinking? (toggling visibility at a fixed interval)...?
|
|
|
|
|
|
I installed a windows service in VB, and the service work fine.
But my service sometimes stop automatically when i don't use it for a long time (about 12hours).
Who can tell me reason?
Thanks.
|
|
|
|
|
There is no reason why Windows would arbitrarily decide to stop a random service after 12 hours so there must be something else going on here. What does your service do?
|
|
|
|
|
May be, an exception goes unhandled which bring down your service. Handle all exceptions and instrument your code to write to Windows Event Log when your service starts and stops. This might help you to troubleshoot your problem.
Also, in Service Manager, you can configure your service to restart automatically after a failure (in Recovery tab).
|
|
|
|
|
Hello great minds!
I built a 2008 vb.net win app with a local MS Access DB that has several reports (.rdlc) They were all working just fine and suddenly:
"An error occurred during local report processing. An internal error occurred on the report server. See the error log for more details."
Can't see any reports at all. Since I could not locate the error log file, I rebooted the system, but the issue remains.
The stacktrace is:
at Microsoft.ReportingServices.Diagnostics.Utilities
.RSTraceInternal.Assert(...)
.RSTrace.Assert(...)
at Microsoft.ReportingServices.ReportProcessing
.ProcessingErrorContext.RegisterItem(...)
.ProcessingErrorContext.Register(...)
.ProcessingErrorContext.Register(...)
.ReportProcessing.RuntimeRICollection.GetExternalImage(...)
.ReportProcessing.ReportProcessing.Merge.Process(...)
.ReportProcessing.ReportProcessing.ProcessReport(...)
.ReportProcessing.ReportProcessing.ProcessReport(...)
.ReportProcessing.ReportProcessing.RenderReport(...)
.ReportProcessing.ReportProcessing.RenderReport(...)
at Microsoft.Reporting
.LocalService.RenderWithDataCache(...)
.LocalService.Render(...)
.WinForms.LocalReport.InternalRender(...)
Thank you very much for your time, interest and help.
alexvw.
modified on Wednesday, November 25, 2009 5:48 PM
|
|
|
|
|
This article describes the same error, and although it talks about MS SQL 2005, I wouldn't be entirely surprised if it at least sets you in the right direction, as Visual Studio 2008 employs MS SQL 2005, and thereby possibly uses some common driver to access your Access DB.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi Johan,
Thank you for your help. This morning before going to work, I decided to try a silly thing. I replaced the myform.Designer.vb file with a previous one and it all came back to normal: well, did lose some data, but that won't take my sleep away.
My guess is that the code that created the instance and rendered the reportviewer object got somehow corrupted.
Once again, thanks for your time.
Best regards.
|
|
|
|
|
My VB really sucks, after googling, I still can't find what Array("UserCode") is in the following line:
vUsers = m_ObjUser.Retrieve(Array("UserCode"), -1)
Help much appreciated thanks!
|
|
|
|
|
From you personal comment I glean that this is legacy code, so I won't ask why you're messing about with VB6 still.
Without seeing all the relevant code, my guess is that this line breaks down as follows:
vUsers is a string that should hold a user's name ?
m_ObjUser is a custom object or class, that holds methods to get data about a user ?
.Retrieve(TheUserCode, SomeIntegerDeterminingSomething) is a method that gets the user's name based on his code ?
Array("UserCode") is an array that has a named index ("UserCode") which holds and returns the user's code. Although it seems a bit strange that that syntax would return anything.
You could just put MsgBox(Array("UserCode")) just before the line you posted, and see what it says.
The user code can end up in this array in any of a million ways. In other words just use the search function of your editor, and find out when / where this Array("UserCode") is created and/or gets populated.
My advice is free, and you may get what you paid for.
|
|
|
|
|
This does not seem to be VB6 array syntax.
'Array' must be a user defined function that takes in a string as paramter and returns something (which is used by m_ObjUser.Retrieve).
Hint: Right click on 'Array' and select 'Definition' from the context menu to see what it means.
|
|
|
|
|
'Array' is a global method in VB6 which takes a parameter array and returns an array of 'Variant'.
You can replace it by:
New Object() {"hello"}
or even better:
New String() {"hello"}
David Anton
Convert between VB, C#, C++, & Java
http://www.tangiblesoftwaresolutions.com
|
|
|
|
|
Hello everyone i am currently trying to figure out to highlight text in a textbox when the user tabs over from textbox to textbox? For example lets say there are 4 TEXTBOXs and the first one displays teh name, 2nd = last name, 3rd= telephone, 4th= GPA, so when the user wants to add another record to the database and after entering in a NEW FIRST NAME, he/she tabs to the lastname text box and IT WOULD HIGHLIGHT THE TEXT and then he could just start entering in new text without having to erase(BACK SPACE what is der)
here is my code of what i got so far. Right now after saving using a button and he tabs it goes and hightlights the text of the FIRSTNAME TEXT BOX
private sub btnSave_Click(blah blah blah)
txtFirst.Focus()
txtFirst.SelectAll() 'selects text in firstname text box after hitting the SAVE BUTTON'
End Sub
I dunno if i would have to use something like TabIndexChanged and tell it to highlight the text?? or what? THANKS
|
|
|
|
|
Hi,
The TabIndex determines the order in which controls get focus when the tab key is hit; as long as you don't change the TabIndex, TabIndexChanged won't fire.
I would go for the Enter and Leave events.
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
thanks i GOT IT!!! I used the txt leave event like u said
one little problem when I am working with a masked box, i tried to select all the string in it but it wont, im guessing
since it is a masked box?
I did mskTele.SelectAll()
but it just sets the cursor at the end of the data
|
|
|
|
|
PAguilar09 wrote: im guessing
since it is a masked box?
Guessing isn't very professional. How about studying, researching and trying?
Maybe like so[^].
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
I am working with a textfile; the content of which I have read into a multiline textbox. The number of lines in my textfile will vary from time to time, but I know that the line that I want to modify is always 3rd from the bottom.
for eg.
SM*82*000102339~
my intent is to read the file and modify the 82 to a variable nuCount.
My first thought is to write to an Array and do something. I am stuck. can anyone help me out and put me back on the right track? Thanks
|
|
|
|
|
So, you read the entire contents into an array of Strings, then find the line you want and do some very simple string manipulation. What's the problem? You're stuck on what part of this??
|
|
|
|
|
I'd think he's stuck on the string manipulation bit..
|
|
|
|
|
Nothing a little RegEx couldn't easily handle...
If that's his problem. I wasn't too sure after reading his post a few times.
|
|
|
|
|
How about this:
- forget the multiline TextBox, use a single-line TextBox instead;
- use File.ReadAllLines to get a string array;
- set an integer variable "index" equal to the array length minus 3;
- show the relevant line in the TextBox by setting its Text property;
- have the user edit it and indicate he is done somehow (a "Save" Button would be fine)
- store the TextBox.Text into the same array position you used before;
- and now call the right File method.
Of course if you know exactly what modification has to be applied, you don't need the TextBox at all and you can have your code do it for you.
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Luc, thank you for your suggestion. I think I am going to run with it and then repost the solution here. Gracias.
modified on Wednesday, November 25, 2009 12:24 PM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
