Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timestamp on Oracle Server
Message
 
 
À
30/07/2002 09:27:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00683886
Message ID:
00687506
Vues:
13
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform