Search results for query: *

  1. B

    Data Set/ Data reader problems.

    Ok..almost workign Ok, now it's coming together. The advice has helped, but now it's doign somethign odd. It compiles, and starts to run, but after 3 successful loops thorugh the reader, it fails out on the 4th run with the error 'An unhandled exception of type 'System.NullReferenceException'...
  2. B

    Data Set/ Data reader problems.

    Ok, I added in the line as shown before, and it still fails to run, giving me the same 'Table has no key' It also says there is an error in how you told me to construct the line itself Dim VHSConn As New OleDbConnection(VhsConnStr) VHsAdapt.SelectCommand = New OleDbCommand(VHSQry, VHSConn)...
  3. B

    Data Set/ Data reader problems.

    OK, I tried the <> in the SQL call iand it finally got past there. I edited the code as follws concerning the MissingScemaAction and I am getting a new error now once the reader tries to start finding rows. Dim VHSConn As New OleDbConnection(VhsConnStr) VHsAdapt.SelectCommand = New...
  4. B

    Data Set/ Data reader problems.

    Ok, I am writing a program where I am sadly having to mix datasets with datareaders..at least that's the aim. I finally got it to get past the fillign the data table (I Think) but now it's failignon the execution of the data reader. Dim VHSData As New DataSet Dim Findrow As DataRow Dim...
  5. B

    Use of ' in a query.

    Ok, made a program, ti works fine 90 percent of the time. It is designed to INSERT NEW RECORDS into a database that holds video tape data. Here is the problem, some of the video titles contain an apostrophe, or single quote (') The same char that is used int eh SQL INSERT query to denote start...
  6. B

    Possible Query structure problem.

    partially. Ok BLokz, your input partially helped. the problem with the radio button 4 now works properly, but the radio button 5 is still not giving my proper results. And TechGnome, by misbehaving, I mean it's still giving my the same problem before, improper search results.
  7. B

    VB and Access some issues

    DIfferences in versions. I Think (note a big empahsis on that) you ran into something I did. I first looked at VB before it went .NET, and a lot of the database stuff has changed alot since it went to .NET. Now I have a limited understanding, but what you have to do is actually tell the program...
  8. B

    Possible Query structure problem.

    Nope Nope, that change had no effect at all on the program, it still is misbehaving.
  9. B

    Possible Query structure problem.

    Possible Query structure problem.[RESOLVED] I had hoped to not have to use this forum again (no offense) but I cannot figure out why (and yes, I checked all the sources I coudl find, help, MSDN, etc etc) this query doesn't seem to return the proper results. Query Format: VideoQuery =...
  10. B

    Distinct in SQL Query

    Thank you. Thank you, that fixed the problem, and I was able to get the rest of the small issues to iron out.
  11. B

    Distinct in SQL Query

    <sigh> No offense to your small program, but in NO WAY does it even begin to answer WHY my code keeps failing. Having a little feep program to demostrate the Insert and Update is all fine and good, but when the structure of your code is almost identical to my in terms of trying to actually...
  12. B

    Distinct in SQL Query

    mistake in words. My mistake was using the word update. The routine is NOT updating, it is inserting a totally new, unique record, which to my understanding of the help files is done by the INSERT, not the UPDATE SQL. And no offense, but as for now, as I very very barely understand even the...
  13. B

    Distinct in SQL Query

    Last Question. Alright...now desipte the several migraines, and now total lack of understanding on what this si doing by implementing code you suggested that I do no comprehend, I am gettign one final error, and Yes, I tired th help files, no information there, I tried the MSDN, no help there...
  14. B

    Distinct in SQL Query

    Ok, the whole ExecuteScalar thing is royally throwing me for a loop.....I have no clue what it is, so no offense, I am going to use DataReader. And I cannot open multiple datareaders at once, hence the open, read data, close repeat process approach. I am a self taught coder..I am NOT college...
  15. B

    Distinct in SQL Query

    Ok, here is the complete code for what I am doing thus far. The ConnString is a Public declared varible further up the form. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ' Step 1, retrieve and set Last UID used. ConnString =...
  16. B

    Distinct in SQL Query

    Fails as in gives the error An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll at 'myreader=DBcommand.ExecuteReader()' line terminating all operations. And yes, all varibles have been checked, spelling has been checked, syntax is all in...
  17. B

    Distinct in SQL Query

    Distinct in SQL Query-Problem Resolved I am writing a more ecomplex program than my previous one, one requiring parsing out dinstinct entries from a table (there are about 5 distinct values in on column across 36000 records). Here is my question. I am using the OleDbDataReader to retrieve the...
  18. B

    Nesting DataReaders?

    um...ok..I think....maybe um, I did include the SQL statement that is generated, it's called VideoQuery, and is right under the if-then statements. A text box is being used since it was simpler to get that workign than trygin to grapple with the problems associated with a datagrid, doubly since...
  19. B

    Nesting DataReaders?

    Ok,. hopefully last problem.... Ok, got the array problem figured out, and most of the other problems. Now, my last issue is trygin to sort the data via the SQL query. I used teh MSDN to figure out how to use the ORDER BY to get a single sort on the read data, and saw the syntax for multiple...
  20. B

    Nesting DataReaders?

    Re-designed, still can't figure this out. Ok, I went back and separated out the readers...trying instead to use an array varible to hold the processed data so I can have a bit mroe control, but when I debug, it debugs, but I get an 'An unhandled exception of type...
Back
Top