OleDbCommand Select Returning Null
Feb 16, 2011
Having trouble importing a value from a .csv file to a .csv file. This this done because data needs to be massaged and the data file renamed. This is a user interface. Do not want to have the user touch the .csv in any way except upload to the application so the applicaiton can do manipulation. Either way here is the issue.
There is a column in the original .csv file that contains a zip code. The first row of the .csv has a value of 17003 in the zip code column. In the second row of the .csv the zip code column has a value of 11746-9984. The value in the zip code column from the second row always comes back as a Null value. My guess is that the OleDbDataAdapter is defining some kind of Schema. Again, the first row containing the zip code column probably insists the value must be numeric. When the data table field is established it probably gets defined as numeric. If that is true and the second row of the .csv zip code column is not numeric that must cause the zip code value to be Null.[code]...
View 2 Replies
ADVERTISEMENT
Apr 3, 2012
My code seems to behave a way I don't understand. Sometimes it returns null as expected and sometimes it returns a value when its supposed to be null. How can someone explain this? Here is the code that selects from access and displays the result in a messagebox:
cmd5.Connection = cnn
cmd5.CommandText = "SELECT receipt_num " & _
"FROM brought_coffee, farmer where crop_year= " & yr & " and " & _
"brought_date=#" & dtt & "# and farmer_centre='" & ctr & _
[code]....
View 1 Replies
Dec 22, 2010
I typed this question once already, hit preview, and somehow never got the preview and lost what I typed. It has been that kind of a day.So here is my quick overview then I am going shopping. I am using OLE DB to select from an excel spreadsheet. It has over 15000 rows and 33 columns. Sometimes even when a cell is not null, it is returning a null value. If I just do a "select * where [termination date] is not null", for example, it will return no rows even though I can see with my own eyes that sometimes termination date is not null.
View 9 Replies
Sep 28, 2009
I'm using the following code to work out the next unique Order Number in an access database. ServerDB is a "System.Data.OleDb.OleDbConnection"
Dim command As New OleDb.OleDbCommand("", serverDB)
command.CommandText = "SELECT max (ORDERNO) FROM WORKORDR"
iOrder = command.ExecuteScalar()
NewOrderNo = (iOrder + 1)
If I subsequently create a WORKORDR (using a different DB connection), the code will not pick up the new "next order number."e.g.
iFoo = NewOrderNo
CreateNewWorkOrderWithNumber(iFoo)
iFoo2 = NewOrderNo
will return the same value to both iFoo and iFoo2. If I Close and then reopen serverDB, as part of the "NewOrderNo" function, then it works. iFoo and iFoo2 will be correct. Is there any way to force a "System.Data.OleDb.OleDbConnection" to refresh the database in this situation without closing and reopening the connection. e.g. Is there anything equivalent to serverdb.refresh or serverdb.FlushCache
How I create the order.I wondered if this could be caused by not updating my transactions after creating the order. I'm using an XSD for the order creation, and the code I use to create the record is ...
Sub CreateNewWorkOrderWithNumber(ByVal iNewOrder As Integer)
Dim OrderDS As New CNC
Dim OrderAdapter As New CNCTableAdapters.WORKORDRTableAdapter
[code]....
View 2 Replies
Jul 21, 2010
I am getting an error: OleDbCommand.Prepare method requires all parameters to have an explicitly set type.
on the last line of the code below.I have seen things saying you have to set the datatype of each parameter but how can i do that when it being generated by the command builder?
[Code]...
View 1 Replies
Jan 11, 2012
Public Sub checkemail()
sqlcheckemail = "select Email from WEBUSER where Email='" + TBEmail.Text + "'"
Dim dscheckemail As New DataSet
[Code]....
if u see the one that i've commented is the one i already googled at tested...so now if the email address exist in the db..everything works wonderful..but if it doesn't exist the code should process the one that does not satisfy the first if statement...but now i'm getting the result as "There is something" eventhough the email does not exist in the db...
View 2 Replies
May 4, 2008
This may seem like a dumb question, but how do you set a default date for the datetimepicker or set today's date as default in the table?
For some reason the control (every instance I've inserted so far) returns a null value when I try to update rows without selecting or entering a specific date while the program is running. The date columns are required, and in at least one case I need the date to automatically return today's date.
In the properties I have chosen "values" for today's date, past dates, even future dates, but I keep getting the following error:
A first chance exception of type 'System.Data.NoNullAllowedException' occurred in System.Data.dll
When I review the details, VS tells me that the date column in question does not allow nulls. If I select a date while running the program, I don't get this error, so it seems like the default value is not getting set.
View 3 Replies
Apr 3, 2009
is it possible for a VB.net function with a return type of integer to return null ?
View 3 Replies
Jan 4, 2010
I have this function correctly linked in an external .js file...
function SubmitAge(age, UpdatePanelID, HiddenAgeID) {
$get(HiddenAgeID).value = age;
__doPostBack(UpdatePanelID);
}
and am calling it like this from an onClick of an a href="#" ... html tag (tags removed, please scroll right as stackoverflow has the greatest difficulty in displaying simple content, 7th display related edit,
[Code]...
Why on earth is HiddenAgeId, clearly passed just like UpdatePanelID, is returning an "Undefined identifier Error"??? its perplexed me to the point where i have no room to move! have i missed something guys?edit: Update: turns out it works perfectly (as it should) when i load it up in FireFox, but has the resulting error in Internet Explorer, this is not a browser compatibility issue, it should also work in IE, but it doesn't!
View 3 Replies
Feb 4, 2011
I am still a newbie with VB. If I return a number the if statement works fine, with opening the new form and updating it as needed. Id the if statement returns a Null from the database it crashes.
[code]...
View 2 Replies
Jun 9, 2009
I have this function correctly linked in an external .js file...
function SubmitAge(age, UpdatePanelID, HiddenAgeID) {
$get(HiddenAgeID).value = age;
__doPostBack(UpdatePanelID);
}
and am calling it like this from an onClick of an a href="#" ... html tag (tags removed, please scroll right as stackoverflow has the greatest difficulty in displaying simple content, 7th display related edit, thanks stackoverflow)
a href="#" onclick="SubmitAge(24, 'ctl00_MainContent_arFrom_upAgeRange', 'MainContent_arFrom_HiddenAge')" runat="server" 24 /a
yet, i am getting this error, and its being called on the first line of the SubmitAge function (line with $get(HiddenAgeID)... etc...)
Error:Microsoft JScript runtime error: 'null' is null or not an object
i've copied and pasted my WATCH windows in visual studio .net (vs2010 beta 2 using vb.net & c#) while the execution breaks inside teh SubmitAge .js function...
age 53 Number
UpdatePanelID "ctl00_MainContent_arTo_upAgeRange" String
HiddenAgeID Undefined identifier Error
Why on earth is HiddenAgeId, clearly passed just like UpdatePanelID, is returning an "Undefined identifier Error"???
edit: Update: turns out it works perfectly (as it should) when i load it up in FireFox, but has the resulting error in Internet Explorer, this is not a browser compatibility issue, it should also work in IE, but it doesn't!
View 5 Replies
Nov 18, 2010
I am finding this weird issue. When I do this > activities.Where(Function(a) (Not a.IsDeleted And a.ParentId = 100) It returns an in-memory query & when I try opening it up, it throws a object not set exception. This only happens when there were no items which satisfied the condition. Shouldn't it be returning an empty set? When there are items satisfying the condition, then it returns a list & works all good.
View 1 Replies
Jan 5, 2012
In my VB.NET application when I try to get the image location using picturebox.ImageLocation (path), it is returning null. I have to use that path string in filestream's parameter to open it. Since it is returning null, I couldn't open the file (image) in filestream. The following error is coming:
"Path cannot be null"
This is my code:
Dim path As String = Picturebox1.ImageLocation
Dim filestrm As FileStream = New FileStream(path, FileMode.Open)
Dim arry(filestrm.Length - 1) As Byte
filestrm.Read(arry, 0, filestrm.Length)
View 6 Replies
Mar 29, 2012
I am trying to call an external C++ function using VB.NET (answers in C# are fine, I can convert back) which returns a list of device names. This comes in the form of a pointer to a null-terminated array of null-terminated char arrays (correct me if I've misunderstood what I'm dealing with) with a function signature:
long GetNames(char*** names)
Most of the answers to similar questions I've found have involved something more like:
long GetNames(char** names, int length)
It appears from what I've read that I need to give it an IntPtr but I'm uncertain as to how this should be initialized, and in my case I don't know the length of the array. At the moment, in the VB module, I have:
<DllImport("MyExternal.dll", CallingConvention:=CallingConvention.Cdecl)> _
Function GetNames(ByRef names as IntPtr) As UInteger
End Function
I've tried calling the function by passing an IntPtr initialized as IntPtr.Zero or using Marshall.AllocHGlobal, but I always get an AccessViolationException.
Any ideas on how I should be calling this function and how I get the return value into a managed string array would be greatly appreciated.
EDIT: I've found a sample function call in native C as follows:
char **tmplist;
GetNames(&tmplist)
View 2 Replies
Jan 28, 2012
I want to select all records in a table and only 1 field in 2 related tables so my query is:
strSQL = "SELECT CL.Name, CL.FirstName, T1.Description, T2.Description " & _
" FROM Clients CL, Table1 T1, Table2 T2 " & _
" WHERE CL.Tab1Cod = T1.Code " & _
" AND CL.Tab2Cod = T2.Code"
All works and all records are selected only if fields CL.Tab1Cod and CL.Tab2Cod contain data but if one or both contain NULL value then NO record are selected. how can I test in a query statement if a filed contains a null value and, in this case do not expose the related field ?For example if CL.Tab2Cod is null the field T2.Description will be empty but all other fields are exposed.
View 4 Replies
Jan 25, 2012
I've got a table that caches calculated values for certain dates. I want to use LINQ to select all rows where the calculated value fields are null.But when I use isNothing I get an error that LINQ can't translate this into T-SQL. Is there a way to select null values with link, like this...?
Dim var = From rec As Record In myDataContext.Records Where IsNothing(rec.calculatedValue) Select rec
Other posts on stackoverflow mostly discuss how to avoid or check for null values with LINQ.
Note: I can't just set cacluatedValue's default to -1 to flag records whose calculated value has not been set (and then select those records) because I run queries that sum/average the calculated values. Selecting nulls seems cleaner and less bug-prone.
View 1 Replies
Mar 29, 2010
I'm trying to use a select case statement to evaluate the value being passed from an array list...any suggegstions. I need to determine if the array is null or not, and setup my select case statement based on if the array is populated. See sample code below Code Sample selected As New ArrayList
Dim dvExisting as DataView
Dim grdExisting as DataGrid
For
i = 0 To dvExisting.Count - 1
If grdExisting.IsSelected(i) Then
[Code]...
View 3 Replies
May 29, 2012
Not sure what I am doing wrong, but here is the code.
SQL Server Express 2008 R2
VB 2010
Private Sub FillDataSetAndViewGrid()
[Code].....
View 7 Replies
Nov 9, 2011
I have this simple-minded query:
select a.str_number+' '+a.str_name+' '+a.str_suffix+' '+a.str_apt AS addr from mytable
This query works as long as none of the concatenated values are not NULL. If any is null, the address does not show.
I tried this:
select IsNULL(a.str_number+' '+a.str_name+' '+a.str_suffix+' '+a.str_apt AS addr,'') from table
What I would like to accomplish is to replace NULL with empty space if the value is null but I still get no values.
View 3 Replies
Feb 2, 2011
I'd like to take all suggestion either in C# or VB.NET.I have a DB diagram like the image below. I also include the database script here [URL]In the Students table, CountryId and RoomId column are allowed null. Because some records do not have info about room and country yet.Also, some students do not have essays.I'm doing a joint query with all tables. I want to select all students to project the result like this:Wanted query result.
Here's my current query that gives the result like the image below:
Dim db As New DBDataContext
Dim query = From st In db.Students _
Join c In db.Countries On c.Id Equals st.Id _
Join r In db.Rooms On r.Id Equals st.RoomId _
[code].....
current query result I got only one result back because I have (2) William NoMan record in every table. But I don't get anything about others, like (3) Sync Master who has everything but RoomId.What do I need to modify the query above so it will give me all students like in the wanted query image above?
View 2 Replies
Dec 31, 2009
Im working on an access database, and I want to know how can I fix the code below so that I could display the correct information to the user. The problem is, I want to display an error message if the oledbcommand did not succeed.
[Code]...
View 2 Replies
Aug 7, 2010
created a database and I am able to read from the database into VB and also able to create a new set of feilds. I do needte a set of records, can't seem to find the right code.The access database has 4 columns one of which is a unique code (column name is 'code') that relates to each different item so I would have the user put in the code to the textbox and then the programme will delete the set of records corresponding to that code
View 4 Replies
Jun 24, 2011
I'm using the following
HTML
Dim conz As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:BdadosCV_PARTS.accdb;Persist Security Info=False")
[code]......
View 3 Replies
Mar 15, 2012
I have an ASP.NET web application (VB.NET) using an Oracle database. On an insert, I need to get the identity of the inserted row back. I am trying to use RETURNING, but I keep getting a value of 1 returned.
Dim strInsert As String = "INSERT INTO L.TRANSACTIONS (LOCATION_KEY, TRANS_CREATOR, TRANS_EMAIL, TRANS_PHONE) VALUES (:location_key, :trans_creator, :trans_email, :trans_phone) RETURNING TRANS_ID INTO :ukey"
[Code].....
View 2 Replies
Mar 23, 2010
I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file
[Code]...
View 4 Replies
Jan 26, 2011
I am getting a syntax error missing operator, I have tried this so many times by eyes are crossed can someone spot my mistake?
HTML
"SELECT * , Left([DateSold], Len([DateSold])-(InStr([DateSold], 'AM')-InStr([DateSold],'1')+1) AS DateSold , FROM " & Me.OpenFileDialog1.SafeFileName & " Where
[code].....
View 10 Replies
Jan 15, 2010
I need some help working with an OleDbCommand Statement existing statement
OleDb.OleDbCommand("Select *, (([AddressDisplay])&', '&([City])) AS Address
The City is stored in database with the city name and an additional abbreviation added. I need to get rid of the abbreviation, if possible.I DONT control the database its from a 3rd party.
Example: Houston[HST] I need to remove the [HST]
Can this be done? Either in the command statement of perhaps in the displaymember of the combobox that reads the database?
View 8 Replies
Apr 8, 2012
I have an ACE OleDb connection to an accdb file that�s working well but I�m mystified by something I recently discovered when using named parameters. Order of adding of parameters overrides the parameter names. I see in the MSDN that is states when in "Text" mode named parameters is not supported. My testing has proven this to be the case. The example below puts "Value 2 in Field1 and "Value 1" in Field2. In fact I could change @value2 to @blahblah and it works.
Dim command As New OleDb.OleDbCommand("INSERT INTO Results(Field1,Field2) Values(@value1,@value2)", con)
command.Parameters.AddWithValue("@value2, "Value 2")
command.Parameters.AddWithValue("@value1", "Value 1")
what is text mode and how do I change it and what other types are there? According to John McIlhinney�s earlier explanation things like date variables are added in a binary fashion including support for DBNull. So this is not "Text" so how am I sending binary data to a Db in Text mode? I�m just not getting why it supports names when it ignores them. Is it simply the case that there is no way to add parameters out of order in my case?If adding out of order is impossible should my command use some other syntax? I see other syntax that just uses question marks in the command dim for the Values section. EG "Values(?,?)".
Is there a way of adding parameters without names?In general I�d love to hear someone to explain this so I can understand the inner workings here a little better and have a little more confidence in what I�m doing here. I can fix my code to work but I feel like an idiot using parameter names that are ignored. I just know I�m doing something wrong even if it works.
View 8 Replies
Jun 14, 2012
I am using VB .Net to loop through a regex Match and generate a sql statement. I'm creating the sql like this
sql = "Insert Into Agencies (Address) Values"
While MatchObj.Success
sql = sql & "(""" & MatchObj.Groups(1).Value & """), "
[code].....
View 1 Replies
Jun 12, 2009
I'm trying to add a new table to a database connected via MS Jet driver. When I run the following Code, the error I get is:
Quote:In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.I'm not sure what it is exactly hanging up on.
sql = "CREATE TABLE tblTable2 ([Text1] text(100) WITH Compression, " & _
"[Text2] text(25) WITH Compression, " & _
"[Int1] int(4) WITH Compression, " & _
[code]....
View 7 Replies