This is the very first time i've joined and posted in this forum... I'm looking forward lot of gurus here whom they can share their intellectual property with respect of course honoring what they can contribute..
For the gurus kindly check my problem below 'bout Delphi and MS SQL 2000 Server...
I'm trying to develop a three-tier system using borland studio 2006. I've designed my database application server & have establish a connection to MSSQL 2000 database example "NORTHWIND" using dbExpress objects (in remote data module). I'm using TSQLDataSet to access tables and Stored Procedures.
Now in my client application, i'm using DCOM Connection and a Local Connection (in datamodule). It works fine to access the tables i've defined in my application database server as well as executing queries using commandtext properties of a clientdataset obtaining the expected results returned. What my problem is that, i know how to access STORED PROC with input parameters i've defined in my application database server but i don't know what object/s to use in my client side application executing the said SP. Accessing Tables & Queries work fine to me both in my app server and client app... Please help me by providing an example codes utilizing stored proc in ms sql passing input parameters in client side app.. please....
Thank and best regards,