Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
How to do a parameterized timestamp??? |
Wed, Jun 8 2011 12:02 PM | Permanent Link |
Dale Derix | I'm trying to create a parameterized query with a start and end date, so far without success.
WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate >= TIMESTAMP :StartDate AND ivInvoiceDate <= TIMESTAMP :EndDate Anyone know how to do this? Thanks |
Wed, Jun 8 2011 12:31 PM | Permanent Link |
Dale Derix | Duhhh
WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate >= :StartDate AND ivInvoiceDate <= :EndDate Sometimes I amaze myself Dale |
Wed, Jun 8 2011 1:55 PM | Permanent Link |
Uli Becker | Dale,
<< WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate >= :StartDate AND ivInvoiceDate <= :EndDate >> or WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate between :StartDate AND :EndDate Regards Uli |
Thu, Jun 9 2011 3:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dale,
<< Sometimes I amaze myself >> A good rule to help you remember is that you never use literal prefixes, quotes, etc. with parameters. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |