Results 1 to 12 of 12

Thread: [RESOLVED] Solutions to fldDateTime as PrimaryKey

Threaded View

  1. May 3rd, 2009, 09:10 PM #6
    dw85745
    dw85745 is offline

    Thread Starter
    PowerPoster
    Join Date
    Jul 2001
    Location
    Tucson, AZ
    Posts
    2,166

    Re: Solutions to fldDateTime as PrimaryKey

    dee-u

    The reason (IMO) they got inserted is that DateTime is really a double. If the double precision varies then the system thinks its a different datetime but shows in the DB as the same since the DB does Not show dates past seconds.

    To my knowledge not even sure if you can use VB to screen past seconds so no way to check for milliseconds for a date type.

    Just remembered GetTickCount will do milliseconds, will verify.

    jmcilhinney:

    See above.
    Last edited by dw85745; May 3rd, 2009 at 09:19 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width