Maybe by the end of the year.
http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.htmlPostgresql does support them now however.
Bob Lee
As far as the programming I get envolved with these days, using stored procedures I have not found a drawback. using a copy / paste into my code, works just fine. (I did figure out how to sort of use a stored procedure by storing sql statment in a text field of a mysql database, then recall it, and send it back as querry.
Not the most efficient way of doing things, but it works.
goes like this
call the table with stored procd get the record you want and turn the text field in the record into a command which is sent back.
Bob Lee (motor mouth)
>>I would love to hear the outcome. By the way, there are about 75 readers who have signed up for a yahoo site I started about a year ago, Sometimes its active, sometimes quiet
>>But the its all about VFP+Myslq
>
>I have an additional question on MySQL: I heard it doesn't support stored procedures. Does this apply to the latest versions? If yes, do you consider it a serious limitation?
>
>Hilmar.
In the beginning, there was a command prompt, and all was well.