I have the sample project, but there is no option available to include attachment. so i explain my project here.
I created server application with two units
On TDSServerModule1 i dropped TSQLConnection and added parameters to connect to SQL Server database "master" (using MSSQL driver)
On mainform I dropped TDSServer, TDSTCPServerTransport, TDSServerClass and connected them with TDSServer.
I added the following code in the OnGetClass event of the TDSServerClass
PersistentClass := TDSServerModule1;
Next I created client application with Only one form
i dropped TSQLConnection connected to server application (using DataSnap driver)
i right clicked and generated 'Client Classes' using 'Generate Datasnap Client Classes' menu
i dropped TDSProviderConnection component and connected to TSQLConnection
i dropped TSqlQuery component and connected to TSQLConnection. I write the following query
Select * from sysdatabases
I want to select all rows from table "sysdatabases" which is exist in master database.
When i execute the Open command, it is throwing the following error
"Remote error: Dbx.SQL is an unrecognized command type."
My objective is to create multi tier data snap application. But i want to add TSqlQuery in the client application and to execute select, insert, update, and delete commands directly from the client application.
Usually we put tsqlconnection (dbconnection) and tsqlquery on the server side, and clientdataset on the client side.
But I want to use database connection on the server side, but TSqlQuery on the client side of the datasnap multi tier application.
The reason behind is i created one sample application using TMS workflow studio component, when I use that component in the multi tier datasnap application it throws the same error. It seems that they are executing the query on the client side.
So I want to make sure the possibility to use TSQLQuery in the client application of the multi tier datasnap application
Is there any way to send my sample project to you thru email. my email id is email@example.com
I am using FastReport VCL 5 to export PDF report file with Delphi source code.
FastReport VCL 5 has Compression function.
I want ask about this function as below:
When i use this function to compress report file, what will be compressed?
Exp: Compress font, image or what?