Walter Meester
HoogkarspelPays-Bas
Jim,
>Yes y9ou can do that. However, you cannot ever open that table if tyhe UDF is not visible to VFP as it will cuase an error that will prevent the table from opening. Also, you must insure that the UDF always returns a value of the same type and length or else the index will become corrupt.
>
>This is one of those things that "can be done" but "shouldn't be done". Like shooting yourself in the head, of course you can shoot yourself, but it isn't a very good idea to do it.
I think you're right saying that this shouldn't be done. However, in the past I used index based on UDFs to provide some trigger functionality within FPW 2.x and I can imagine that there will be (very) exceptional cases where and UDF based index can be of any benefit. I would probably store the UDF as a Stored Procedure.
But of course you're right it souldn't be used in general.
Walter,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement