Questions tagged [datasnap]

DataSnap is a Delphi technology that allows the development of multi-tier applications

DataSnap is a Delphi technology that allows the development of multi-tier applications, most notably multi-tier database applications.

DataSnap offers the possibility to create Client-Server applications that communicate through the Internet, the local network, or the local host.

The main feature of DataSnap is the ability of the Client application to invoke methods that are implemented on a Server. DataSnap automatically generates the necessary interface for the Client to communicate with the Server, containing the prototypes of the Server methods.

http://docwiki.embarcadero.com/RADStudio/en/DataSnap_Overview_and_Architecture

501 questions
4
votes
3 answers

Delphi datasnap RESTful URL if contain parameter with character T/F/Y/N will convert to boolean True and False

I have a server method "CustomerLookup" that accept a string parameter "CompanyName", user may enter any characters and CustomerLookup method will return a list of customers that partially match the criteria. My REST URL is something like below, the…
Sherlyn Chew
  • 189
  • 1
  • 2
  • 8
4
votes
1 answer

Obtain Trigger generated values after ApplyUpdates with a TClientDataSet

I have a (Firebird) DB. For most of my tables I have a trigger which fires before insert which will create the Primary Key (PK) for me via a generator as well as write to the newly inserted records a Created Date value and a Created By value. I…
Jason
  • 2,572
  • 3
  • 34
  • 41
4
votes
1 answer

IntraWeb / DataSnap?

I'm a hobby programmer trying to build a client/server application suite, using Delphi XE. I write stand-alone applications occasionally, for my personal use. The problem is I don't know ANYTHING when it comes to networking / multi-tier. I am…
cipnec
  • 147
  • 1
  • 10
3
votes
2 answers

Delphi XE2 DataSnap Server - HTTPS 'Could not load certificate'

I have an existing DataSnap server (Windows service) which is running fine on HTTP, and I now want to add HTTPS as an additional protocol. I've obtained and installed an SSL certificate and generated a certificate file (.crt) and private key file…
Jonathan Wareham
  • 3,357
  • 7
  • 46
  • 82
3
votes
1 answer

Delphi XE2 DataSnap - Access REST connection properties in server methods module

I'm building an XE2 DataSnap server which will serve connections from REST clients. My DSServerClass LifeCycle property is set to 'Invocation'. The REST connection properties will include username and password, which are handled through the…
Jonathan Wareham
  • 3,357
  • 7
  • 46
  • 82
3
votes
2 answers

REST Datasnap override URI mapping

I wrote a small REST server with the REST datasnap in delphi XE2. There is a default mapping between HTTP methods (POST, PUT etc.) and the functions defined in delphi, this is done by a delphi component. This wiki entry describes the URI mapping but…
MBulli
  • 1,659
  • 2
  • 24
  • 36
3
votes
0 answers

There is some kind of DataSnap XE TServerMethods setup?

I'm trying some TServerMethods and all of those interact with my Firebird DB. I don't want to get the SQLConnection.DBXConnection in every method that I'll create, but I want to inherit that behavior from a superclass that will setup a protected…
Eduardo Maia
  • 587
  • 1
  • 5
  • 10
3
votes
2 answers

Why is OnUserAuthenticate being called twice on a DataSnap REST server?

I have created a REST Web service using DataSnap in Delphi XE. I am calling server methods using the XMLHttpRequest JavaScript object. I am passing the username and password for authentication in the fourth and fifth optional parameters of the…
Cary Jensen
  • 3,751
  • 3
  • 32
  • 55
3
votes
1 answer

How to find out current delta record in TPacketDataSet point to which record in TClientDataSet?

Let said i have a ClientDataSet1 link with TDataSetProvider to access database for data and i have opened the ClientDataSet1 ready for edit and did some changes, so at the end i have some delta. The delta being assigned to TPacketDataSet for easy…
Sherlyn
  • 41
  • 1
  • 3
3
votes
2 answers

Delphi datasnap callback - BroadCast question

I'm again in a situation where I've spend an obscene amount of time on trying to customize datasnap callback samples to my needs. I'm old school OOP programmer and have several very large Object hierakies in my "toolbox" PODO style :-) .. and having…
Bimmer_R
  • 588
  • 9
  • 18
3
votes
0 answers

Error loading MIDAS.DLL only in certain machines

So my applications in Delphi 2007 use TClientdataset features and i need to deploy MIDAS.DLL with it. I put the library in the same folder the EXE file is located. Usually it runs fine but in some machines (and i don't know what these machines had…
delphirules
  • 6,443
  • 17
  • 59
  • 108
3
votes
1 answer

TDictionary via DataSnap crashes, FComparer is nil

I have a dictionary crash in the DataSnap client because its FComparer is somehow nil. Server side code: TColorNames = TDictionary; function TServerMethods.DictionaryTest: TColorNames; begin result := TColorNames.Create; …
Milos
  • 63
  • 1
  • 9
3
votes
1 answer

How to change the Content-Type response in the REST DataSnap

I have a project made from WebBroker REST, running as a service, I need to change theCotent-Type response to application/json and by default WebBroker REST brings me as a result the Content-Type 'text/html; charset=ISO-8859-1' I change the…
Jefferson Rudolf
  • 161
  • 2
  • 11
3
votes
1 answer

How to update Delphi Datasnap server?

I have build a few apps that receive and send data over a Datasnap server. I have multiple Datasnap servers running on my customers servers. The Datasnap server runs as a Windows Service on their machines. How can I remotely update those servers or…
Remi
  • 1,289
  • 1
  • 18
  • 52
3
votes
2 answers

File delete after datasnap server method call in Delphi XE6

I have a Datasnap client server application written in Delphi XE6. I am calling a server method that creates temporary file using a TFileStream, fills it with my report in TStream format from my http post, and returns it to my client. This all…
John
  • 507
  • 3
  • 13