?
Solved

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

Posted on 2004-10-12
3
Medium Priority
?
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Expert Comment

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

Author Comment

by:mSchmidt
ID: 12286546
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 2000 total points
ID: 12286563
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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 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