Im not sure itds SQL as this is OCI layer finctions it parces params to a prepared SQL statement. They came with a quote that BAAN uses its on format for null dates. I gess they just don't want to write the is not null against the = nuldate. Still I think this should be something the database should take care of. Then I asked them if they could make it a parameter so I can relay on correct date entrys and this guys starts ratteling about the test they would need to preform to make this change. Well I hope than now the BDE is out its not going to happen again. (Lest assume that messed up the parameters).
Met vriendelijke groet, Pieter Valentijn Delphidreams http://www.delphidreams.nl -----Oorspronkelijk bericht----- Van: Michael Van Canneyt [mailto:[EMAIL PROTECTED] Verzonden: zondag 25 februari 2007 23:01 Aan: [email protected] Onderwerp: RE: [lazarus] StrToDate error On Sun, 25 Feb 2007, Pieter Valentijn wrote: > :-0 > Is it? > I never know. > I think it should come from the system locale. It should, yes. > In that case this routine still works. Normally, yes. > I gess the hardest part is the MM-DD-YYYY against DD-MM-YYYY. I have > seen that theres anly 3 combinations posible in Delphi. DD-MM-YYYY > MM-DD-YYYY > And > YYYY-MM-DD > > Where - is anny date seperator. > > I tried once to set it to something like DD-YYYY-MM. > In Windows this worked(display time etc) but Delphi StrToDate choked > on it. > > Now I know no one will use this format it was just for me to see what > format was used. As in a Terminal server enviroment the defaul > settings of the system sometimes was set in a user session (I still > don't know why) and as the server is usaly English and the masks are > all in Dutch this happened sometimes. When we where still deling with > The bde and oracle this error made the date insert of oracle go wrong > and it inserted absurd dates. I logged a call at Oracle complaining > about the strange data insert. They said it was not there problem. > They don't check the dates for validity. Sounds like sqlite which also doesn't check validity of the data you feed it. Nice going for a multi-billion-dollar company. :-) Michael. _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
