Solved

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

Posted on 2004-10-12
3
231 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 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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