|
Ya..
Actually i wanted to know when the File is last opened or executed.
The requrement is like that.
I want to trace the date and time of my software's last run.
Just Understand that..This is to track the events going on in our client place.
I know that what u are telling is making the sense.
But you must know what i want..
Thanx 4 ur reply..
Any suggestions from you??
Regards
Bibin
|
|
|
|
|
you create date field in the data base update the same whenever you modify/add the data with current date that will be the last run
regards
chandru
|
|
|
|
|
Your applicaiton should log this somewhere. Depending on the security requirements, you could even log this to an encrypted XML file hidden somewhere or to the systems own event log. But, depending on the LastAccess time is not reliable at all, considering you can screw it up just by getting properties on it or if backup software runs and backs it up to tape or something.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi all ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
If we are using more then one table in my code for saving the data. If both table contain different data then what I want
I want to delete data from first table, if I get error when I am saving then data in the second table.
any property we have directly 
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
Is that in English?!
Please check your questions again before posting it...
|
|
|
|
|
If my english is weak then do not laugh on it...
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
shakti5385 wrote: If my english is weak then do not laugh on it...
Well, could you try and rephrase what you asked, because I am having difficulty understanding it also.
|
|
|
|
|
How to use connection.begintransaction in the vb.net
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
shakti5385 wrote: How to use connection.begintransaction in the vb.net
You put the BeginTransaction at the start of your queries. If you have an error then use RollbackTransaction to undo the changes you've made on the database. If everything works then put CommitTransaction at the end and close the connection.
A note of caution: While a transaction is in progress parts of the database will get locked out from other processes that are trying to access it. This is to ensure the safety of the transaction and other processes that are accessing the database. When you start a transaction perform the queries you need quickly so that the locks don't last long. And do not wait for user input inside a transaction.
|
|
|
|
|
can you have any code so please send me
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
myConnection.BeginTransaction()
If someErrorHappened Then
myConnection.RollbackTransaction()
Return
End If
myConnection.CommitTransaction()
|
|
|
|
|
Thanks Friend
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
Hi.
Can anyone offer some assistance with creating an invoice in vb express 2005. perhaps some code examples etc.
i looked around and can find example like richtextbox printing etc.
Thanks.
Robbo
|
|
|
|
|
Hello to all, I am a newbie with the visual basic language and i am currently building a small application for my company to edit a specific part of a database. I am using the ado data control for this and i have everything functioning expect for my delete button, thing is it works but it only deletes one record from the field whereas i would like it to delete all the records in the field that match the data in a text box that data is entered into by the user. Please any help would be appreciated, i've been fighting for weeks with this. I even tried using sql queries and they fail me as well, cause my delete command doesn't seem to work. Feel free to ask questions if i haven't made my self clear enough. Thank you.
|
|
|
|
|
govagedon wrote: but it only deletes one record from the field whereas i would like it to delete all the records in the field that match the data in a text box that data is entered into by the user.
What is the SQL query you are using?
|
|
|
|
|
Hi there.
There is many ways to identify data to be deleted. You can either delete data from x Value to y Value or with wildcards (*) or specific data only.
Here is some samples
DELETE * FROM Table WHERE ColumnA = Value1 AND/OR ColumnB = Value2
DELETE * FROM Table WHERE ColumnA = LIKE '%Value1' -> String Type Data (wildcard method)
DELETE * FROM Table WHERE ColumnA BETWEEN Value1 AND Value2
Hope this is helpfull
Regards, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
To chandram i've used sql queries similar to the ones that Werries has posted. And very time i try to move to the next line when i finish typing it in i get this error "compile error, expected expression" and it highlight the asterik. If i try the "delete from" command" it hightlights my table name and give the same error.
Here's the code i've wirtten
<pre>confirm = MsgBox("Are you sure you want to delete these records", vbYesNo, "CAUTION")
If confirm = vbYes Then
delete from pay_payment_history02 where process_we_date= like 'we_date.textbox'
MsgBox "Records Deleted", , "Message"
Else
MsgBox "Records not deleted", , "message"
End If</pre>
pay_payment_history02 = table name
process_we_date = field name
we_date.textbox = text box where the user selects the date to be deleted from the datafield.
Thanks for the help Werries your welcome to give any more advice if you have i'm looking for lots of it, like i said i'm new at this.So its sort of like a practice program.
|
|
|
|
|
govagedon,
Check with this sql statement
delete from pay_payment_history02 where process_we_date= like '" & we_date.textbox & "'"
This we_date.textbox is a variable you have declared in VB6/VB.Net. I hope this would solve your problem.
Regards,
Manowj
|
|
|
|
|
hello manowj,
i inserted the statment into my code, now i've encountered another error. Vb gives me the following error, "compile error, syntax error" then when i click ok it highlights the entire line of code you gave to me. any idea as to why that may be happening?
Thanks,
govagedon
|
|
|
|
|
I am using VB 2005 Express Edition and i am trying to deploy my porgram and i can publish it with no problem but when i go to run the program outside the VB environment it crashes. Anyone can tell me or direct to a sort of step by step so i can make sure i did it right?
thanks
|
|
|
|
|
Crashes with what error message?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Is the .NET framework installed on the target machine ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Swisher24 wrote: I'm having issues can anyone help?
And those would be ......?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Still not enough information. What error messages are you getting? Also, you typed the code into your post - DON'T. ALWAYS copy and paste your code into your posts here. It saves us from chasing down bugs you typed in here, but didn't type into your actual code.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Last time I'm going to ask - What's the exception and on what line of code does it show up? Copy and paste the code where the problem shows up! There is NOTHING anyone can do to help you unless you do this...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
