New Sqlite Version with new DateTime format?

Discussion in 'Beta Versions' started by berndgoedecke, May 5, 2009.

  1. berndgoedecke

    berndgoedecke Active Member Licensed User

    Hello Erel,
    I've tested the new SQLite-Version in the B4PPC V.6.7.6, until I use this Version i have Problems with DateTime. I saved it in the table as 1990-04-21 for e.g.
    If i watch the Value in the Debuger it shows 21.04.1990 00:00:00(in german).
    The column is in DateText formated. If the entry in the table is NULL or "" an error for the reader appears that tell me, that no DateTime is detected.
    Do you know what happpened to the Date in SQLite 3.6.3 ?

    Best regards

  2. Erel

    Erel Administrator Staff Member Licensed User

    In Basic4ppc side, there was a change in ExecuteTable which now converts nulls to "" or 0 depending on the column type.

    Can you post a small program that demonstrates the change?
  3. berndgoedecke

    berndgoedecke Active Member Licensed User

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice