mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 8:19 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: How can I run a trigger by pressing a button inside Navision
PostPosted: Tue Jan 17, 2012 2:13 pm 
Offline

Joined: Thu Jan 14, 2010 12:01 pm
Posts: 124
Country: Albania (al)
Hi all

I have created a trigger that I want to execute it every time I press a button in Navision.

Can anyone please tell me shortly how to accomplish that?

The trigger is created and also the button is created. I want on the click of this button to run the trigger which is on the database.
Please help me on this.

Thank you and best regards


Top
 Profile E-mail  
 
 Post subject: Re: How can I run a trigger by pressing a button inside Navi
PostPosted: Tue Jan 17, 2012 2:15 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Feb 03, 2006 10:15 pm
Posts: 2272
Location: Houston, TX
Country: United States (us)
A SQL trigger? A Navision function? Please be specific about what you have done.

_________________
Matt Traxinger - ArcherPoint
Microsoft Dynamics NAV 2009 Programming Cookbook
Do you have an idea to improve NAV? Submit it at I Love NAV


Top
 Profile  
 
 Post subject: Re: How can I run a trigger by pressing a button inside Navi
PostPosted: Tue Jan 17, 2012 2:16 pm 
Offline

Joined: Thu Jan 14, 2010 12:01 pm
Posts: 124
Country: Albania (al)
Sorry for not specifying that.

A sql trigger.

Regards


Top
 Profile E-mail  
 
 Post subject: Re: How can I run a trigger by pressing a button inside Navi
PostPosted: Wed Jan 18, 2012 11:44 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12265
Location: Brno
Country: Czech Republic (cz)
If it is trigger, it is triggered when some event in SQL is fired. Depends on which event you want to fire from NAV... ;-) if it is trigger, which is fired when record is inserted into some table, just insert the record into the table... you can use ADO Automation to interact with the SQL. Search for examples how to run e.g. Stored Procedure.

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: