Forum > Databases
Select returning Wrong Field Date
sidon:
Hi!
I'm working with UIB on lazarus, all works fine, except Date fields in a select sql statement, all Date fields are returning :
31/12/0000
But work fine in a insert and update sql statment, I have tested with FBLib and the same error occurred!
This is a Lazarus bug?
matthijs:
Did you define a displayformat for this field? If so then you should check this.
Sidon without pwd :-/:
--- Quote from: "matthijs" ---Did you define a displayformat for this field? If so then you should check this.
--- End quote ---
Where? the UIB lib don't has a "Field Editor" OTOH, i don't believe that this is the question.
matthijs:
But it might be the answer. :) If you defined the display format like 'dd/mm/0000'. And a lazarus bug it would not be, because then it would happen in other database components as well. So it might be a bug in the UIB components or you made a error yourself. But based on the information you are giving, it is guess work, because it is very little.
Anonymous:
--- Quote from: "matthijs" ---But it might be the answer. :)
--- End quote ---
We never know ;-)
--- Quote from: "matthijs" ---
If you defined the display format like 'dd/mm/0000'. And a lazarus bug it would not be, because then it would happen in other database components as well.
--- End quote ---
But... it happen in other database components, as i said:
"I have tested with FBLib and the same error occurred!" and now i tested with FIBL and the same error happened.
Navigation
[0] Message Index
[#] Next page