Home
Discussions
Blogs
Community
Jobs
Welcome To T24All
+++ Newsticker requires javascript +++
Index
Recent Topics
Rules
Help
Search
Tweet
Welcome,
Guest
Username
Password:
Forgot your password?
Forgot your username?
Create an account
t24All
Globus/T24 Topics
jBASE
Changed records / Audit fields
(1 viewing) (1) Guest
Reply Topic
New Topic
Page:
1
TOPIC: Changed records / Audit fields
Changed records / Audit fields
1 year, 5 months ago
#5522
Lior
OFFLINE
Expert Boarder
Posts: 107
Karma: 0
Hello,
What is the best & most reliable way to find out what records have been changed in a specific table since a specific date?
For example, all the records that have been added / changed in CUSTOMER table since 1/8/2010.
Reply
Quote
Re: Changed records / Audit fields
6 months, 1 week ago
#8534
oscarramol
OFFLINE
Fresh Boarder
Posts: 11
Karma: -1
USE something like
SSELECT FBNK.CUSTOMER$HIS WITH DATE.TIME GE 20110101
and
SSELECT FBNK.CUSTOMER WITH DATE.TIME GE 20110101
Reply
Quote
Re: Changed records / Audit fields
5 months, 3 weeks ago
#8661
jpb
OFFLINE
Platinum Boarder
Posts: 754
Karma: 35
@oscarramol
Seems you're not on a jBase-only environment ?
In a 'normal' installaton DATE.TIME has the format YYMMDDhhmm, so it should be GE 1101010000.
Reply
Quote
The following user(s) said Thank You:
armin
Reply Topic
New Topic
Page:
1
t24All
Globus/T24 Topics
jBASE
Board Categories
General Topics
... Anouncements
... Feedback
Globus/T24 Topics
... T24-Technical
... T24-Functional
... jBASE
... Training/Learning
... Operating System
... Others
Gossip
... Gossip
Powered by
Kunena
Scroll To Top
[
Reset Settings
]
