I’m thinking of buying RemObjects for Delphi because I need to support Document/literal or RPC/literal in one of my projects.
Right now I have the free trial installed.
What I have to do is, basically, give access to specific records in an user database. My question is where can I find a demo or tutorial showing how to return a record or a list of records?
I understand how to return a value, or a string, but what about a whole record or list of records?
You should use Data Abstract for working with databases. In order to develop DA SOAP server you need just create DA application with the help of our wizard (http://wiki.remobjects.com/wiki/Easy_Steps_to_Create_a_Data_Abstract_Application_(Delphi)) and replace default TROBinMessage component with the TROSoapMessage one. Also if you are going to access data from non-Data Abstract clients you should replace TDABin2DataStreamer with the TDAXmlDataStreamer component. You could use standard DA service methods to get data (GetData, SQLGetData - http://wiki.remobjects.com/wiki/TDataAbstractService_Class) or write your own service methods.
I have attached such standart DA server/client project, it uses PCTrade SQLite database that is a part of DA distribution.