@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