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

"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

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

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

Walter

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

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

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