Solved

Method on table within Axapta, can it be reached from SQL serveR ?

Posted on 2004-10-12
3
214 Views
Last Modified: 2012-05-05
Hi i have a method which is bound to a table from within AXAPTA, this table is to be easily found in the SQL server, is there someway to call a tables method from SQL servER ??

0
Comment
Question by:mSchmidt
  • 2
3 Comments
 
LVL 18

Expert Comment

by:ShogunWade
Comment Utility
"is there someway to call a tables method from SQL servER ??"    what do you mean?
0
 

Author Comment

by:mSchmidt
Comment Utility
Well in Axapta the Tables have methods connected to them, are these methods stored within Axapta or is it possible to create methods for tables in SQL server, and if how do you call them ?
0
 
LVL 18

Accepted Solution

by:
ShogunWade earned 500 total points
Comment Utility
SQL Server os not an object oriented database so no it is not possible to create a method on a table.   But you can create Stored Procedures which as essentially a set of instructions which are executed as one command.   This would be ne nearest approximation.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now