Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with Trigger
Message
From
08/09/2004 10:34:59
 
 
To
08/09/2004 10:30:57
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00940269
Message ID:
00940280
Views:
21
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
>*--------------------------------------------------------------------------
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform