Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timestamp on Oracle Server
Message
 
 
To
30/07/2002 09:27:57
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00683886
Message ID:
00687506
Views:
11
>Hello all,
>
>is there an equivalent to the timestamp column of MS-SQL Server on the Oracle Server, that i can use in remote view's with UpdateType of 'KeyAndTimeStamp'?

Sergey is correct. The best you can do is add a Date column to every table and update its value with a trigger. I have a KEYID [Number(8)] and LAST_UPDATE [Date] Column in all my tables. The KEYID column is my PK column and is populated by using a sequence and the trigger as well:
create or replace trigger SCHEMA_TABLENAME_BEFORE_INSUPDT
before insert or update on Schema.TABLENAME for each row
declare
v_Id   Number;
v_Date Date;
BEGIN
 :new.Last_Update := SYSDATE;
 If :new.KeyID Is Null or :new.KeyID < 1 Then
    select s_Schema_TABLENAME.nextval into v_Id from dual;
    :new.KeyID := v_Id;
 End If;
End;
/

CREATE SEQUENCE S_Schema_TableName increment by 1 start with 1;
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform