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...
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...
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?
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()...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.