V1 problem with select and timestamps

[Ruslan Zasukhin]

On 10/17/06 10:29 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian,

> Sorry, it is V1 again. (server/V4MD)
> 
> Look at this result:
> 
> c= valselectreturncursor("SELECT BP_MEISOLsync_TS FROM
> buchungen_pointstable")
> put valgetallrecordsofcursor(c)
> 
> -- [[#BP_MEISOLsync_TS: "00.00.0000 00:00:00"], [#BP_MEISOLsync_TS:
> "00.00.0000 00:00:00"]]
> 
> 
> So the timestamp is all zeros, ok?

ok
 
> Now I try to find timestamps with all zeros:
> 
> c= valselectreturncursor("SELECT BP_MEISOLsync_TS FROM buchungen_pointstable
> WHERE BP_MEISOLsync_TS='00.00.0000 00:00:00'")
> 
> put valgetallrecordsofcursor(c)
> 
> --[]
> 
> Zero results? Impossible. Where is the problem?

* May be in fact they are NULL ?

* may be you have other date format for db.
    although unlikely you have YMD

* try from Valentina Studio

* you work local or remote ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]