Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2004-10-12
3
Medium Priority
?
270 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
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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

607 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