|
OK, I since have changed my statement to:
DELETE from Agents WHERE DeletedDate < " & Date.Now.Date & ""
Now it deletes nothing
|
|
|
|
|
Did you actually read my previous reply?
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Sorry, I didnt explain well enough.
I changed the Data Type in my MS Access database to Date/Time and changed my statement to:
DELETE from Agents WHERE DeletedDate < " & Date.Now.Date & "
I would think that should work, but it doesnt delete any records.
|
|
|
|
|
Did you actually read my previous replies? 
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Obviously I am new to this and I didnt understand what you meant.
I thought that your last comment meant that I would be better off changing the data type to Date/Time, therefore I did that.
I appreciate your answers, but if you are going to be curt, please allow me to figure this out on my own or get help elsewhere rather than be insulted because I dont happen to know and understand everything that you do.
Thank you again for your assistance.
|
|
|
|
|
As you are not inclined to use DateTime.ToString() nor SqlParameter class, feel free to continue in any way you see fit.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Thank you, but
did you read MY last post?
|
|
|
|
|
The comment Luc is trying to make is that "stuff" & date.now.date & "more stuff" will call the default ToString method of the Date object returned by Date.Now. More than likely, the string output by the default is confusing the database engine because it is expecting a different order. You should look into the overloads of ToString that take an format string argument and determine the format expected by the database.
Alternatively, you could use a parameterized query. I'm not big on the syntax, but it believe it would be something like 'DELETE your stuff WHERE DateToCompare < @date'. The actual syntax varies from database to database. Then you could use the OdbcCommand (or SqlCommand, or whichever version applies to your database) along with the Parameter class to go with your command. The OdbcParameter MSDN page has a good example of this.
|
|
|
|
|
I found someone who knew the answer to me problem.
The Field needed to be a Date/Time Field and the correct Delete statement is:
DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < #" & Now.Date.AddDays(-30) & "#"
The Pound Signs made all the difference.
Thank you for your assistance.
Rick
|
|
|
|
|
hi there,
i want to create a column that increments automatically when data for other columns are inserted. The data type for this column is varchar made of the following format based on some conditons
BD/00001/99A
EX/00002/00B
PS/00003/00A
the numbers between 00001-00003 will be incrementing each time a new data is inserted. others are conditions based, usually not changing.
any help would be appreciated
|
|
|
|
|
I would use two fields, one strictly an autoincrementing number, the other (the composite field you want) fully calculated from the available data.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
u mean using stored proc
(somevariable + autonumber) as Columnname, can u give me some hint, if u have
thank u in advance.
|
|
|
|
|
I saw in Dependency walker MSchrt20.ocx depending file and I searched in internet But I can't get all file.
Wt i post last time error was clear in my system. But In client system package not opening when I add a chart otherwise it will come.
Now how can i build setup.
|
|
|
|
|
You have to add the MsChrt20.ocx file to your installation and any files that it depends on. Seriously, I'd look into a different graphing package, such as ZedGraph[^].
|
|
|
|
|
Hi All,
My application run alwase with admin rights (Previlages). Write now i m in guest account and try to run my application with admin rights.
So how to Get Current Login User Name...
Thanks
If you can think then I Can.
|
|
|
|
|
Hi,
1.
Environment.UserName
2.
eg_Anubhava wrote: Write now i m in guest account and try to run my application with admin rights.
You can't. Guest has no rights whatsoever.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
I want the name of user which is login.
I m login with Guest Account and I m running my application as administrator then how to Get the Login User Name (Guest).
If you can think then I Can.
|
|
|
|
|
Again, Environment.Username returns the name of the user that is running your code.
|
|
|
|
|
Environment.Username returns the name of the user that is running your code.
But i want to know where from i m tring to execute it.
Just Follow these step.
Goto Guest Accout then Select Exe and Right Clink on them. then Use the Option Run as administrator then enter user name and password.
In that case how can i get the login user name.
If you can think then I Can.
|
|
|
|
|
eg_Anubhava wrote: In that case how can i get the login user name.
You can't. It'll still come back as Guest because the profile for the admin account you used isn't loaded.
|
|
|
|
|
Thank you sir
If you can think then I Can.
|
|
|
|
|
Have a look at .NET security configurations. You would need to assign your account necessary privileges.
|
|
|
|
|
check my post
If you can think then I Can.
|
|
|
|
|
Dear Friends,
I hope you all will be doing well. I am working on a project of "fabric inspection machine". I am using microcontroller atmel 89c52 and I want to get the data from the pin of microntroller in visual basic 6.0 but I don't know how to interface the hardware in visual basic 6.0. Actually I intend to design a counter(forward and reverse direction both)to count the meters of fabric.Is there any of you who can guide me in this regard????
Thanks and best regards.
Asad Saeed Khan.
(PAKISTAN)
|
|
|
|
|
Good Morning Asad
I think everyone would have given you an answer to your question 1 minute after you have posted this here. The Problem with the technology that you are using is that its old and not supported by microsoft anymore. if think in .net what you request could be achieved at ease. let me ask a question to you Asad. Why are you still using VB6 in 2009?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
