[lancaster]

I have a desktop application that saves a ticks value into a column in a table control (and also into a column value in a SQL Lite database).

I then use this value when filtering records.

On Windows 2000, the TicksColumn value is reported as an 18 digit string (as expected) however on XP the value is reported as a floating point value (e.g. 6.33432093 E+17). A simple MsgBox is used to determine this.

Now when I compose a SQLlite Select statement with

"... WHERE TicksColumm > '" & Calendar1.value & "'" the select doesn't return the expected records on XP but works as expected on Win 2000.

Any ideas where the difference is introduced?

Do I need set the TickColumn value with Format(Now,"D18") to ensure it is always held as a string?

Are there other known gotchas with desktop apps on different platforms?

T.I.A.
Dave Lancaster