Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with Trigger
Message
De
08/09/2004 10:37:41
 
 
À
08/09/2004 10:34:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00940269
Message ID:
00940282
Vues:
19
You're welcome. It has to happen first before you know it

>Thank you Gregory, That's what i just discovered !!!!
>
>>>I'm trying to work with triggers, I call a procedure when insert, update or delete records. It seems to work fine but.... if I create a cursor as an image of a triggered table the trigger starts working even on this cursor and that is not what i want to :-).
>>>I create the trigger with create cursor "cursorname" from array "arrayname" where the array is generated by the Afield fuction.
>>>
>>>Thank you
>>>Alessio
>>
>>Alessio,
>>
>>You have to go through the array and clean
>>
>>to avoid the triggers: elements Array[ ?, 13 to the end]
>>to avoid RecordValidation as well : elements Array[ ?, 10 to the end]
>>to avoid RecordValidation and field validation as well : elements Array[ ?, 7 to the end]
>>
>>See afields in help
>>
>>an old routine of mine
>>
>>*--------------------------------------------------------------------------
>>procedure	CreateCursor(Cursor)
>>	local x[1], i, j, s
>>	=afields(x)
>>	* Eliminate Field Validation Rules, triggers, and the like
>>	for i = 1 to alen(m.x,1)
>>		for j = 7 to alen(m.x,2)
>>			x[m.i,m.j] = ''
>>		endfor
>>	endfor
>>	s = select(0)
>>	if( used(m.Cursor) )
>>		use in (m.Cursor)
>>	endif
>>	select 0
>>	create cursor (m.Cursor) from array x
>>	select (m.s)
>>endproc
>>*--------------------------------------------------------------------------
>>
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform