Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 7 of 7 total |
bug in finding reacords in a dataset? |
Tue, Jun 17 2014 2:37 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 AM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Walter Matte Tactical Business Corporation | 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 |
Fri, Oct 3 2014 1:21 PM | Permanent 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 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |