Vb6 file timestamp

How about this: Dev X : get datetime in VB6. DrLazer DrLazer 2, 3 3 gold badges 34 34 silver badges 50 50 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Archived Forums. The Official Scripting Guys Forum! If your answer is "yes," you know what to do. Dive in and help somebody! If your answer is "no," welcome to our fun little world! We'd recommend that you first head over to the Script Center, get your feet wet, and then come back to either ask or answer questions.

We can't be everywhere at once we know—shocking! The Microsoft Scripting Guys 7 2. Sign in to vote. Tuesday, September 4, PM. Here you go: 1. Saturday, September 8, PM. Wednesday, September 5, PM. It is customary in this forum to mark key responses as "answers" to your question. Thursday, September 6, PM. The column name of tmStmpCol was only a logical name. Not necessarly a pointer to the datatype. Hope that clears any missunderstanding.. I've lost track of who is talking to whom The timestamp type is 8 bytes of binary data.

This data is automatically incremented not necessarily by 1 every time the row containing this field gets updated. It is safe to say that larger a timestamp field, the more recently his row was updated.

SQLBill, I have no need to convert this timestamp data to a different format. Your sample code will work, but requires access to both tables each time a SYNC is possibly needed. I'm hoping for one further efficiency.

I wish to keep track of the last-timestamp-value-used-for-a-SYNC in a local location. Then I won't have to nail-up a connection to my remote ASP every single time every minute I want to see if new rows have been added to the local DB. I can't use the number of records as an indicator since old records will be deleted as a maintenance routine.

I'm not sure that you should rely on timestamp being a larger value. The help says it is guaranteed to be unique across the database, but there is nothing about it incrementing. Do you know for sure that it's an incremental sort of thing and not a more random one? I've hit too many sites to easily find this again, but I will try It would hold information on the tables that have been 'replicated'.

For example, one table per table in the original database. Put a trigger on the original table that copies the timestamp to this new db whenever it changes. Then when you are ready to replicate, compare the timestamps in this database and use them and the tablename to copy only the rows that changed in the original.

I do believe we've come full circle. You're describing exactly what I am trying to do. I need an intermidiate variable to hold the binary timestamp value Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! This is fine for comparing timestamps, but sometimes you may want to artificially alter the timestamp of a file programmatically.

Alternatively, you can force an installation program to overwrite a file by assigning a very futuristic file date. If you want to preserve the date and you are using an Internet Client ActiveX control, you can usually find out the date of the file on the server, download the file, then set the file date after it has been downloaded so that the downloaded file's date is in synch with the file on the server.

Programming with Microsoft Visual Basic , Fourth Edition by the best-selling author, Diane Zak, is designed for a first course in programming. Using the most recent version of the software, Visual Basic , this book teaches individuals how to Why not write for us?