Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread bug in finding reacords in a dataset?
Tue, Jun 17 2014 2:37 PMPermanent Link

Ronald


Hi,

Since the latetst update to 1.03 B7, I am having problems with finding
records in a dataset.

This used to work fine:

tbPlanning.InitFind;
tbPlanning.Columns['invallerno'].AsString:=GetParam('invallerno',Params);
tbPlanning.Columns['date'].AsDateTime:=StrToDate(GetParam('datum',Params));
tbPlanning.Columns['planneddaypart'].AsString:=GetParam('daypart',Params);
if tbPlanning.Find(false,true) then...

If I leave out the date column it works fine again. I have set
tbPlanning.LocalizeDateTimeColumns:=true.
It seems to be a bug. Has anyone encountered this?

Thanks,
Ronald
Tue, Jun 17 2014 3:02 PMPermanent Link

Walter Matte

Tactical Business Corporation

"Ronald" wrote:

Probably not a bug - just time localization.....


tbPlanning.Columns['date'].AsDateTime:=StrToDate(GetParam('datum',Params));



Try:

if the parameter is formatted in the right format just do

tbPlanning.Columns['date'].AsString = GetParam('datum',Params);

or

get the yy, mm  dd and    encodedatetime(yy,mm,dd,0,0,0,0)

or


tbPlanning.Columns['date'].AsDateTime:=StrToDate(GetParam('datum',Params) + (TimeZoneOffset(now) * 60 * 1000) );


Walter
Sun, Jun 22 2014 5:25 PMPermanent Link

Ronald

Unfortanatley the first and third option you suggest do not work. I did not
try the second. It should just work, because it has worked fine so far. Tim
must have changes somthing and I need tto know whator else I am in the dark
and I loose mu confidence.


"Walter Matte" schreef in bericht
news:F1E0B8BB-91AD-4FB0-B5B4-509B501971B2@news.elevatesoft.com...

"Ronald" wrote:

Probably not a bug - just time localization.....


tbPlanning.Columns['date'].AsDateTime:=StrToDate(GetParam('datum',Params));



Try:

if the parameter is formatted in the right format just do

tbPlanning.Columns['date'].AsString = GetParam('datum',Params);

or

get the yy, mm  dd and    encodedatetime(yy,mm,dd,0,0,0,0)

or


tbPlanning.Columns['date'].AsDateTime:=StrToDate(GetParam('datum',Params) +
(TimeZoneOffset(now) * 60 * 1000) );


Walter
Mon, Jun 23 2014 11:57 AMPermanent Link

Walter Matte

Tactical Business Corporation



I the field 'date' defined as dtDate or dtDateTime  in the EWB dataset?

Walter
Mon, Jun 23 2014 2:53 PMPermanent Link

Ronald

As dtDate.

Ronald

"Walter Matte" schreef in bericht
news:60670039-F75C-4914-9C05-FB922CB63945@news.elevatesoft.com...



I the field 'date' defined as dtDate or dtDateTime  in the EWB dataset?

Walter
Wed, Oct 1 2014 9:36 PMPermanent Link

Walter Matte

Tactical Business Corporation

Fri, Oct 3 2014 1:21 PMPermanent Link

Ronald

I was searching for a date. In my case it was caused by the
TDataSet.LocalizeDateTimeColumns.
I use a webbroker solution for the handling of datasets, maybe that is why I
ran into a problem. In my case I had to set LocalizeDateTimeColumns to false
and use a proper TDateTime-to-UNIX date/time function.


"Walter Matte" schreef in bericht
news:708804A2-233B-4E69-AB9F-01C9C7F5C993@news.elevatesoft.com...

I think Chris found the bug and work around....

http://www.elevatesoft.com/forums?action=view&category=ewb&id=ewb_general&page=1&msg=5210#5210

Walter
Image