|
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/
|
|
|
|
|
I want to display some texts on Splash Screen. How to display it?
Any samples?
Thanks
|
|
|
|
|
A splash screen, like any other form in VB.
Open the form designer and add labels etc. as required.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi, I posted earlier about a problem im having with VB code that ive taken over. Ive resorted to messing with the code. Basically theres an asp page with vb code which creates a new object. That object is a dll that i have registered with regsvr32.exe. That all works fine. But Im having a problem that when I make a change in the project and compile the dll, i cannot overwrite the old one because it is in use. I have tried unregistering it with regsvr32.exe /u but it doesnt seem to take effect until i restart.
Now i obviously cant restart everytime i want to try a change.
So how do I do this?
Thanks
p.s. visual basic 6 on windows server 2000 (i was on 2003 from my last question but ive downgraded for that mdac problem)
|
|
|
|
|
That situation was commoningly known as "dll hell". IIS is the process that is locking the dll and you will need to reset it (stop and start) it to release the dll (or reboot). if you have multiple websites hosted by the same server, it is possible to stop just the process that is controling the website that would be locking the dll. no way around it...
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Wow, the next couple days are gonna be fun then...
Thanks
|
|
|
|