@ud in PHP?

Walter Vaughan wvaughan at steelerubber.com
Thu Feb 16 16:14:30 PST 2006


Vivaces wrote:
> Hi,
> 
> my question may show my ignorance but
> I want to know the "@UD" equivalence in php and msSQL languages

You would define a trigger... hum i found something at experts exchange...
<code>
CREATE TRIGGER TriggerName ON [Table_Name]
INSTEAD OF UPDATE
AS
UPDATE
     [Table_Name]
SET
     field1= inserted.field1,
     --Put Here all the fields of the table
     last_modified=getdate()
FROM
     INSERTED
WHERE
     [Table_Name].id = Inserted.id
</code>

This code snippet has a MS-SQL table with a field called "last_modifed" that 
would act as the @UD field in filePro. Then using normal PHP commands you could 
read that field and do date math as required.

Google for "mssql create trigger date" and you should find enough stuff to get 
the same functionality as what filePro supplies.




More information about the Filepro-list mailing list