Search results for query: *

  1. P

    Default value in SQL not being saved

    LOL, Now I understand why you got so worked up with placing functions in tables. I did not do that! I entered getdate() as a default value in the design screen not on the field itself. That's what I did. Just removed it from the INSERT statement. I've been programming for a very long time, I...
  2. P

    Default value in SQL not being saved

    I looked into the table adapter in .net and saw this generated insert command: INSERT INTO tblMemo (MemoDescription, DateModified, UserModified, Terminated, UserCreated, Priority, DateCreated) VALUES...
  3. P

    Default value in SQL not being saved

    The getdate() function that I use is directly in the SQL table not in .net. CellValueChanged will only run when the user moves from cell to cell. I don't believe it does an update many times per second. Is there any reason why this is not being saved when every other data is?
  4. P

    Default value in SQL not being saved

    Hello all, I have a simple SQL table with a datetime field that has a default value of getdate(). I created a .net application using datagrids that connects to the sql table. Here is the code in .CellValueChanged Me.Validate() Me.TblMemoBindingSource.EndEdit()...
  5. P

    IO.StreamReader problems with accents

    Thanks JohnH It works!
  6. P

    IO.StreamReader problems with accents

    My program is very simple. All it does is read a file that has file names and their corresponding paths. It then checks to see if the files exist. If not, it writes to another file. A problem occurs when file names have accents (é) for example. StreamReader cannot read these characters and it...
  7. P

    Trouble refreshing dataset

    Thanks for your reply, I asked my collegue, who come back from sick leave today and he said add this line: dataset11.clear Obviously it worked, IT problems are often solved so simply. BTW, your solution was tried before (which is why I named the other table tblLastPrint) and I can't...
  8. P

    Trouble refreshing dataset

    Sorry for the confusion, I'll try and make it clearer: There is a punch clock in our company that records people's punch in and out of work/break. My task is to have a dotmatrix printer print the latest scan from the reader. (punch clock) Similar to a point of sales printer like a cash...
  9. P

    Trouble refreshing dataset

    Hello all, I'm new to vb.net and I'm having trouble with my adapter.fill statements. I have two tables in an Access database where the number of records are virtually identical. I have a query that links the two tables and displays the records that are not identical. One of the two tables...
Back
Top