|
What he said.
If you want more flexibility you can also use something like
"SELECT * FROM table WHERE (reg_date > " & MyDate1 & ") and (reg_date < " & MyDate2 & ")"
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Thanks,
I tried this: Select * from FireArmsTD_View
Where (FrireArms_date > " & DateFrom & ") And (FrireArms_date < " & DateFrom & ")
I got invalid column name for both ' & DateFrom & ' and ' & DateTo & '
thanks
|
|
|
|
|
As written, your "s are not correct and DateFrom is shown twice, but I'll assume those are just typo's.
Make sure that DateFrom and DateTo are showing up as strings. I guess I forgot to mention that, and that they need to be enclosed in quotes. I usually create a string variable to check while debugging.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Try this:
select * from FireArmsTD_View
where FrireArms_date between to_date('&DateFrom','mm-dd-yyyy') and to_date('&DateTo','mm-dd-yyyy')
Btw, is better to use the 'Database Board' for these kind of questions.
|
|
|
|
|
Two warnings:
1.
IIRC the SQL BETWEEN keyword is a bit dangerous as different implementations use different definitions; the issue is inclusive versus exclusive, i.e. does an exact match with a border get included or not. Read the doc, or use explicit comparisons.
2.
Use SQLParameter to avoid all datetime formatting and regional settings issues; it's much better/cleaner/safer than string concatenation anyway.
|
|
|
|
|
Hi,
I am a novice, just don't know how. will you guide me?
thanks
|
|
|
|
|
|
Hello,everyone! Now I use the method "selectsinglenode" with xpath to search in my XML, I find a stranger question.In my project, when I used this method at first, it didn't get the node that I wanted, so I created a new project to try the xpath, it could got the node now.(The same xpath and same XML file) Then I deleted some controls in my project which was about the method(not the new one), create new, then the method could find the node!
I can't understand it, same xpath, same function,same value,why it happens?
Hope some one could tell me the reason and give me some suggestion!Thank you!
The function that I used to search a node was like below:
Dim val As String = ""
Dim xmldoc As New XmlDocument()
Dim xpath As String
Try
xmldoc.Load(Application.StartupPath + "\Flange\Nozzle-Flange-Height.xml")
Dim xmlnode As XmlNode
If Not (Standard = "") Then
xpath = "/Nozzle-Flange-Height/Standard[@value='" + Standard + "']/Flange-type[@type='" + Type + "']/PN[@PN='" + PN + "']/Height[@DN='" + DN + "']"
xmlnode = xmldoc.SelectSingleNode(xpath)
If Not xmlnode Is Nothing Then
val = xmlnode.InnerText
Else
MsgBox("Could not find!")
End If
Else
val = ""
MsgBox("Input by yourself!")
End If
Catch ex As Exception
MsgBox(ex.Message)
End Try
Return val
|
|
|
|
|
Does anyone know of any third party (i know this is where I have to go) vb library that can search the contents of a zip file without unzipping the file? This will also have to happen when I have to add a file as well.
|
|
|
|
|
Uhhh, to find out what is inside a compressed file, you will have to uncompress at least part of it. Whether you save the uncompressed files or quit before it's finished is another matter.
In the meantime, here are some options[^]
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
You could have Google Desktop[^] index the zip-files and query that. It supports .zip, but I'm not sure whether it also indexes the contents of those archives. If it doesn't, then there's probably some plug-in available that does
I are Troll 
|
|
|
|
|
crain1981 wrote: search the contents of a zip file without unzipping the file
What do you mean by that? Do you mean without unzipping the file to the file system? Because you are going to have to have access to the uncompressed data at some point to search it. You might try searching for something that allows you to uncompress zip files to a stream rather than a file... that would at least keep it in memory, then you could perform a search on that data.
This might provide some guidance. Not sure about that though, as I've not tried zipping/unzipping from .Net before.
|
|
|
|
|
You may want to have a look at this article as a heads up, and then investigate System.IO.Packaging namespace in a bit more detail.
Zip Files Easy![^]
http://msdn.microsoft.com/en-us/library/system.io.packaging.aspx[^]
I just wrote an article/tool that used this to create zip files without any problem, and did notice during this process, there were methods for interrogating the zip file, but didn't need this functionality so didn't explore these any further.
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|
|
You can use SharpZip to VERY easily query the zip file to see what filenames, the compressed size, ect... is in the zip file. If you want specific code just shoot me an email. I have a somewhat near complete example of using VB 2005 to zip/unzip .zip files which includes doing what you want as well.
Jason
|
|
|
|
|
I wonder if anyone can help or give me advice before I start this vb project. All VB systems I have done before, the printing off crystal reports direct to printer was straight forward. Now I have to put my output first to a print queue to be printed off at a later date. What would be the best way of doing this? I will be using vb.net 2008 along with SQL Server. I have a couple of ideas but in short don’t know where to start. I thought putting the text file to some area in a database but how could this be done.
Any ideas would be gratefully appreciated.
|
|
|
|
|
Personally, seems to be not really a VB.NET question but more of a general question...
Not a whole ton of details here so the suggestion is a bit week, but if all you are trying to do is delay printing a report then create a small service app that wakes up and looks in a folder on a schedule for a file (maybe a your report printed to PDF) and then if it is there sends it to the printer on schedule?
There is a bunch of details missing here though... maybe you could elaborate a bit more?
Not really sure why you would want a report generated on one day and then not printed until another latter date.
|
|
|
|
|
Thanks for the reply.
The idea is rather than print straight away put the print to a queue then print later on the day. User request and I do as I am told. Not high enough up the chain.
I like the idea of creating a PDF and then display all the prints. Then select the print you want. I would then run a procedure every couple of days to remove un printed documents.
Do you think this is the best idea?
|
|
|
|
|
'Best' can only be judged by you and the client...
To me it sounds like it 'satisfies' the requirements though.
|
|
|
|
|
How do you add a password to a file in vb.net 6.0?
The file already exist.
|
|
|
|
|
Given such a basic open question, maybe you should have searched google first, might have been quicker than waiting for an answer on here.
http://www.dreamincode.net/code/snippet430.htm[^]
NOTE: This is the most basic for of encryption (XOR) and is not really that secure by todays standards.
I suggest you search google for RSA256 as a minimum, or other encryption standards.
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|
|
First, there's no such thing as VB.NET 6.0. It's either VB.NET or VB6.
Second, you can't put a password on a file. NTFS does not support it. You'd have to write a file system extension to mimick some kind functionality like this, which cannot be done in VB6 or VB.NET.
Or, you may be able to encrypt the file, but you'd have to decrypt it again to use it, defeating the purpose of the encryption.
|
|
|
|
|
I have a user for whom a VBA application in MS Access ceased to work properly after upgrading to office 2k7. I stepped through the VB code and this is what I am seeing in the Form_Current sub:
Consider the following If Statement:
If Nz(Me!PID) = 0 Then
Me.Attachments.Form.RecordSource = "Select attach from attachments where pid = " & Me!IssID & " AND [ISSUE_ONLY]=1;"
Text114.Visible = False
Label119.Visible = False
Text128.Visible = False
Label129.Visible = False
Else
Me.Attachments.Form.RecordSource = "Select attach from attachments where pid = " & Me!PID & " AND [ISSUE_ONLY]=0;"
Text114.Visible = True
Label119.Visible = True
Text128.Visible = True
Label129.Visible = True
End If
Me.Attachments.Form.Requery
Me.Attachments.Form.AllowDeletions = False
The Me.Attachments.Form.RecordSource property, normally should change after being explicity set like that, but on this user's machine, it isn't. The propery is remaining "attachments" returning the entire table instead of what is specified in the query. This only seems to be happening for this user so far so I don't think it is a code issue. The .mdb file itself is not read-only and is up to date as far as I can tell. The Trust center settings also appear to be correct as well, allowing macros to be run. No errors are thrown when the code attempts to change the recordsource property, only that nothing happens and the property remains unchanged.
Any ideas?
|
|
|
|
|
BREdwards wrote: This only seems to be happening for this user so far so I don't think it is a code issue.
Does that mean the same code changes the form RecordSource property for other users?
|
|
|
|
|
I have a copy of the .mdb file on my own machine along with office 2k7, approximating the same environment and I have determined that the property will change as it should after stepping it. Truly bizzare.
|
|
|
|
|
i need a formula through which i can increase the font size of records in details section by passing value
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
