Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 7 of 7 total |
EDB - QG |
Tue, Oct 30 2007 11:03 AM | Permanent Link |
"Harry de Boer" | LS
Anyone working with QuantumGrid and EDB? I'm having troubles with filtering dates. I guess it's because the filter requires the date'yyyy-mm-dd' format. Anyone tackled this? Same for using Null (Blanks) Regards, Harry |
Tue, Oct 30 2007 11:52 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
I'm not using QuantimGrid but I'd love to re-open the argument about nulls and empty strings and ...... duck so Tim misses when he throw something at me Roy Lambert |
Tue, Oct 30 2007 12:20 PM | Permanent Link |
"Harry de Boer" | Roy,
I'll duck! Pure out of necessity; if you'll duck and I keep standing, guess who's gonna get hurt Regards, Harry "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht news:84E5C98D-A315-465C-B596-22AFE0CB6212@news.elevatesoft.com... > Harry > > > I'm not using QuantimGrid but I'd love to re-open the argument about nulls and empty strings > > and ...... duck so Tim misses when he throw something at me > > Roy Lambert > |
Tue, Oct 30 2007 5:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< Anyone working with QuantumGrid and EDB? I'm having troubles with filtering dates. I guess it's because the filter requires the date'yyyy-mm-dd' >> Yes, that is likely the issue. The DATE prefix is strict SQL adherence, which DBISAM and other database engines didn't usually include. << Same for using Null (Blanks) >> There shouldn't be an issue here, and they should be using IS NULL. Do you know what filter QG is sending to EDB that isn't valid ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Nov 1 2007 9:23 AM | Permanent Link |
"Harry de Boer" | Tim, (and users of QG)
I found a solution for filtering dates in devexpres's QuantumGrid: In the OnFilterFormatFilterTextValue event (tableview-datacontroller-filter) you must code: if VarIsType(AValue, varDate) then ADisplayValue := 'date' + QuotedStr(FormatDateTime('yyyy-mm-dd', AValue)); Hope this helps anyone, (I'm no going further with the 'is Null'story Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:A7244B0D-7DE5-462A-BBD7-3981711CCEAD@news.elevatesoft.com... > Harry, > > << Anyone working with QuantumGrid and EDB? I'm having troubles with > filtering dates. I guess it's because the filter requires the > > date'yyyy-mm-dd' >> > > Yes, that is likely the issue. The DATE prefix is strict SQL adherence, > which DBISAM and other database engines didn't usually include. > > << Same for using Null (Blanks) >> > > There shouldn't be an issue here, and they should be using IS NULL. Do you > know what filter QG is sending to EDB that isn't valid ? > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
Thu, Nov 1 2007 11:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
>Hope this helps anyone, (I'm no going further with the 'is Null'story Coward Roy Lambert |
Thu, Nov 1 2007 4:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< I found a solution for filtering dates in devexpres's QuantumGrid: In the OnFilterFormatFilterTextValue event (tableview-datacontroller-filter) you must code: >> Thanks very much. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |