Vaccine Dates not recorded

Discussion in 'Bugs & Issues' started by Jason, Apr 17, 2009.

  1. Jason

    Jason Developer / Handyman Staff Member

    Vaccine Dates are not recorded.

    It would be nice to be able to both delete incorrect entries and edit old dates.

    Attached Files:

  2. Graham

    Graham Developer Staff Member

    It used to record dates .... wat version, and what steps to caus this?
  3. Jason

    Jason Developer / Handyman Staff Member

    Any version. 215 b33.

    Add an immunization.

    No date.
  4. Graham

    Graham Developer Staff Member

    Works for me ... seehttp://screencast.com/t/gJAwkB8rkI0

    Are you filling in all the fields?

    What are the exact steps you are taking?
  5. Graham

    Graham Developer Staff Member

    A videohttp://screencast.com/t/8lbdxTrA
  6. Jason

    Jason Developer / Handyman Staff Member

    I think I would have noticed it before.

    I think old immunizations that probably used to have dates ... don't now.

    Is there a IBOconsole query to see if the dates are there, but not showing ?

    Hmmm .. updated server from b33 to b38 ... no effect.
  7. Jason

    Jason Developer / Handyman Staff Member

    I noticed something.

    When I add the immunization, the date actually shows for one millisecond (in fact, it seems all the immunizations do have a date), but it seems to instantly refresh, and the refreshed screen's date is: None.

    That must be good hint ?

    Tickler dates work.

    Attached Files:

  8. Graham

    Graham Developer Staff Member

    Open your vaccinations table and look at the vdate field.
  9. Graham

    Graham Developer Staff Member

    I had a look at the code to retrieve vaccine data ... nothing there that would modify the display of data after it arrives.

  10. Jason

    Jason Developer / Handyman Staff Member

    vdate <null>

  11. Jason

    Jason Developer / Handyman Staff Member

    I added another vaccination on a test patient.


    quite clearly, the new vaccination instantly appears with a date, but it refreshes and it doesn't have a date.

    I don't think older vaccinations have a date during this refresh period, as I surmised previously.

    When I add a new vaccination ... it appears on the first line. It then refreshes to appear in order of vaccine expiry date (?guessing) (not a helpful order BTW, should be by vaccination date - maybe it does for you ! ). when I appears ... the vdate is gone and it says none. Seems the server is rejecting the date ?

  12. Graham

    Graham Developer Staff Member

    so, all your vaccinations have null dates now?

    even the ones you did before??

  13. Jason

    Jason Developer / Handyman Staff Member

    Yep.

    To be totally fair, I can't entirely remember if they ever had dates. Not 100% sure.

  14. Graham

    Graham Developer Staff Member

    Well, this is pretty odd .. the function that adds the vaccinations checks for a valid date value before it adds the vaccine.

    So, after adding a vaccine with the latest server, you are still getting null dates?

  15. Jason

    Jason Developer / Handyman Staff Member

    Yep.

    Same in my partner's REMR.fdb


    He only had 2 (me playing with it once before, and I just did another one).

  16. Jason

    Jason Developer / Handyman Staff Member

    What's the difference between TimeStamp and Date.

    Attached Files:

  17. Graham

    Graham Developer Staff Member

    timestamp includes timezone and hour/min data.
  18. Graham

    Graham Developer Staff Member

    I guess you could try changing the colum to date instead of timestamp to see if it makes any difference.

  19. Graham

    Graham Developer Staff Member

    alter table vaccinations alter column vdate type date

  20. Jason

    Jason Developer / Handyman Staff Member

    that worked.

    Attached Files:

Share This Page