|
There's just not enough information to pin this down, but, it could be caused by a badly formed SQL statement. If your code is using string concatenation to build SQL queries, like
Dim mySQLStatement As String
mySQLStatement = "SELECT * FROM sometable WHERE field1=" & somevariable & " AND field2 Like '" & something & "'"
you'll problably have problems that you can't trace down.
You might also try upgrading the MDAC to the latest version.
This is one of those problems that is very generic in nature and is not going to be solved easily. If you don't have to source code for the app, you're pretty much out of luck.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
We got the source code at last...
Now what would be your approach to trace down this proble.
What you suggest to eliminate this error?
Just let you know, that this problem is not consistant and pops up in few forms till now. After kicking out from the application, user do the same thing again, it will work fine.
Viral
|
|
|
|
|
ViralParikh wrote:
Now what would be your approach to trace down this proble.
Put in instrumentation code to log what is going on by follow what functions are being called with what parameters, what return values are coming back from functions, and sql queries.
I didn't say this would be easy...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi All,
I have a requirement for shading the backcolor of certain rows of the Datagrid.
Lets assume my table has 4 rows in it. I want to display the alternate rows in different colours and if two consecutive rows is grouped for some reason they need to show the same color. (Can't Use Datagrid's Alternatebackcolor and backcolor).
Case 1
Row 1 & 3 backcolor as Pale green
Row 2 & 4 backcolor as Dark green ( Easy with the above said properties)
Case 2
Row 1 backcolor as Pale green
Rows 2 & 3 backcolor as Dark green
Row 4 backcolor as Pale green
Tried loads of samples but can't achieve these 2 cases with any of them.
can someone help ?
Thanks
|
|
|
|
|
there is no way that u can do it in DataGrid as far as i know. . . u can try MS FlexGrid
|
|
|
|
|
|
I Tried this sample yesterday and this doesn't solve my first case wherein i have to display alternate colors for each layer.
Anyway thanks for your help.
|
|
|
|
|
I am trying to figure out a way to connect to the AS400 from vb.net. how do i go about doing it?
I need a detailed explanation because i haven't done this before.
please help.
|
|
|
|
|
You don't connecto to the machine, you connect to a server running on it. What are you trying to connect to?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you for responding,
Im supposed to try and connect to a file thats on the AS400, to see if i can connect to it. i'm very new at this and this is my first actual attempt.
i'm supposed to be able to view the contents of the file.
what do i need to be able to do this?
|
|
|
|
|
|
Thanks for the reply progload,
My problem is nobody seems to know how this works here.
i have been asked to test the connection to the AS400 using vb.net
i have the server ip address, i have the user id and password to log into the as400. what or rather how would i test the connection then.
is it possible for a detailed explanation.
i need to display the file contents from a specified library into a data grid, tell me or give me an example.
thanx in advance.
|
|
|
|
|
I’m building an application that is used to manage project data such as CAD files, images, etc.
At the beginning of a project, a ‘rough’ directory structure that holds project information is created. This structure changes throughout the process of working on the project. The changes include: File/Folder renaming, deletion, adding and moving.
I’m trying to think of a user friendly interface where these file/folder operations can take place. I’m thinking of something similar to a Windows Explorer type window but with the ability to move folders up and down the tree. Or, even better, drag a folder to another location.
Has anybody ever seen any examples similar to this? Any ideas or suggestions??
Thanks
Brad
|
|
|
|
|
|
Anonymous wrote:
http://www.codeproject.com/vb/net/VbNetExpTree.asp[^]
...Very nice.
Anonymous wrote:
http://www.thecodeproject.com/vb/net/DragDropPersistingTreeV.asp[^]
...Perfect! (When combined with the first article.)
Thanks
|
|
|
|
|
I Have Classes in VB.NET ,I Want to Summary description for My classes to Enable User of it To Ease of Use
Note: I See that in C# But I can't do it in VB.NET
|
|
|
|
|
This isn't supported in Visual Studio .NET 2002 or 2003 with using a 3rd party plug-in, like VBCommentor[^]. Though in 2005, this is fully supported.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have a scanned answer sheet which has 5 circles in it corresponding to the answers.2 circles are made black using 2b pencils. Whenever i want to read the value of the marked circles it is giving different values. But using a bmp or gif with system color i m getting the value 0 whenever black color is used.
Pls help me to code the scanned image.
Pls mail me if anything is unclear.
|
|
|
|
|
Hi
I would like to know how to capture an image in vb then store it to the database oracle and then.
Example : Capture a image then the user will click on particular area of the picture i.e some pixel point here i should read the particular area/pixel point and store that area as predefined disease in the database if he cliks on some other area/pixelpoint then store it as someother disease or problem into the oracle database.
Pls can anyone help me.
Regards
Lion Heart
Software Engineer
Bangalore
|
|
|
|
|
Hi, the VB question I have concerns my lack of how to use the Format and Mask properties in an Access/VBA form.
I have a form that is tied to a table with a Date/Time field (the table's field is declared to be of type Date/Time and I only want to store HH:mm:ss - no AM/PM or date).
I have tried unsuccessfully setting either/both the Format or Mask properties on my form to be
00:00:00;0;_
The unwanted side effects are:
AM/PM being tacked on.
clicking on the TextBox control can place the cursor anywhere in the formatted control (middle, front, end) - want to go to front.<br>
can sometimes wander outside of the mask - "1234401:00:00".
Would like to make my Form have a very usable time TextBox. What can I do in VBA code to achieve this?
ALSO - how can I override regional settings for time such as hh:mm:ss A/PM. I want 24-time, regardless - HH:mm:ss
Thank you so much for helping/pointing me to what I need to learn.
Regards,
Johnny
|
|
|
|
|
|
Hi all... Long time I did not post anything here asking things.. hehe, ok, let me get straight to the point.
I want to make a small small program, to link my program to my cd writer so I can make my program burn softwares and data and the like.. Any help offered will be greatly accepted..
|
|
|
|
|
Microsoft have a free dll for doing this in XP, on the MSDN site ( from memory ). Beyond that, all methods of doing this cross platform involve SDKs that are quite expensive, AFAIK.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
will this dll work on win98?
|
|
|
|
|
No, I don't even know if it supported VB, but I do recall it was a solution for XP only.
Christian Graus - Microsoft MVP - C++
|
|
|
|