RobPouwelse
Technical User
Hi,
I've been trying to read records from an omnis database (from raining data) into delphi for editing and inserting into an access database. The problem that I've run into is that as soon as I try to retrieve the value of a date type field, the program stops with the error "Translate error: Value out of bounds"
From what I understand delphi has its own take on what the date field is like. For instance delphi might interpret 12/30/2000 as day:12 month:30 year:2000 which would be impossible (out of bounds). What I can't seem to figure out is how to make a workaround to the problem for instance reading the data in a raw form so I can specify it as a string and string-format my way through it myself.
for specifics:
- empty field is either "null" or "0/0/0" (not sure about that)
- omnis date notation is d-m-yyyy (day and month without a leading 0)
Thanks in advance,
Rob Pouwelse
I've been trying to read records from an omnis database (from raining data) into delphi for editing and inserting into an access database. The problem that I've run into is that as soon as I try to retrieve the value of a date type field, the program stops with the error "Translate error: Value out of bounds"
From what I understand delphi has its own take on what the date field is like. For instance delphi might interpret 12/30/2000 as day:12 month:30 year:2000 which would be impossible (out of bounds). What I can't seem to figure out is how to make a workaround to the problem for instance reading the data in a raw form so I can specify it as a string and string-format my way through it myself.
for specifics:
- empty field is either "null" or "0/0/0" (not sure about that)
- omnis date notation is d-m-yyyy (day and month without a leading 0)
Thanks in advance,
Rob Pouwelse