FiveTech Support Forums

I have to import from SqlExpress.
Database is not mine anc cannot modified

Tables do not have a date_time field in thir structure.

How can I import records modified today?
Any hints?

marco

Marco

Hopefully there is a unique RowId column ( preferably auto number ) that perhaps you can use to determine ( guess ) when a record was added to the table based on its relative position to all the other RowId's

Just a long shot there

Rick Lipkin

And what about date & time?
In this way I can only import new records but not records modified for instance yesterday
Excuse me for my bad english
marco

Marco

To be honest with you .. I do not know a way to determine when a row went into a table .. especially without a datetime column .. Google did not tell me much either.

Sorry
Rick Lipkin

Rick,
It's true no information such like this
I am disappointed that in a very important (and famous) application and we have not sold will be a date time field

I am disappointed that in a very famous application program does not exist a date and time field in every table.
It's incredible!
I have to import every day all tables?
More than 150!
Now I invent something

Marco,

If the tables have an unique auto-increment ID-field, you can import for each table the records with a higher ID-number than the highest ID-number that you imported the day before of that table.
Then you only add the new records...

Marc,
some tables have one date type field but is not the same concept
In my dbf tables I have two field utemodi , datmodi User and date time of last replace performed