Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread EDB - QG
Tue, Oct 30 2007 11:03 AMPermanent 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 Smiley

Roy Lambert
Tue, Oct 30 2007 12:20 PMPermanent 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 Smile

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 Smiley
>
> Roy Lambert
>

Tue, Oct 30 2007 5:43 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 Smile

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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Harry

>Hope this helps anyone, (I'm no going further with the 'is Null'story Smile

Coward

Roy Lambert
Thu, Nov 1 2007 4:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image