Well the problem is that the date is being fed into Firebird as "10/11/2007" but firebird is reading it as "11/10/2007"
Even constructing the dates as you suggest does not help. :( Anyone here ever struck these bazaar locale errors where I only have the one locale on my machine, (US locale removed at install) and yet I am having these US date problems (same problem within SQL Server). I have strolled through the registry and the only items with language set to US are: my graphics card (where userlanguage is set to Eng(nz) anyway), My dotnet compact frameworks, HKEY_LOCAL_MACHINE\SOFTWARE\ITConcepts\onecard SETUPLANGUAGE, whatever that is (possibly my credentials management or something), HKEY_ USERS\.DEFAULT\Software\Microsoft\Windows\CurrentVersion\ThemeManager LASTUSERLANGUAGEID And HKey_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\ThemeManager LASTUSERLANGUAGEID ARRGGGHHHHHHH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Peacocke Sent: Tuesday, 10 July 2007 12:50 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] firebird query parameters behaving oddly On 10/07/07, Tracey <[EMAIL PROTECTED]> wrote: > Difficult. > > I use a javascript calendar picker to populate dates formatted dd/MM/yyyy > (user requirements) which is passed via "textbox.value" to a javascript > function which in turn passes the value directly back to my Delphi app. > Good Afternoon Tracey, Could you use EncodeDate(), which will ensure that you are passing the actual date as you would like. E.g. ... // sDate = your date string = dd/mm/yyyy = '10/07/2007' // d, m, y : Word; Try d := StrToInt(copy(sDate, 1, 2)); m := StrToInt(copy(sDate, 4, 2)); y := StrToInt(copy(sDate, 7, 4)); MyDate := EncodeDate(y, m, d); except ShowMessage('Not a date'); end; Steve -- Steve Peacocke http://stevepeacocke.blogspot.com/ _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
