I use the server-side TFDConnection - TFDQuery - DataSetProvider server-side () can be easily found online tutorials
The client use the TSQLConnection - ClientDataSet - BindSourceDB - grid to query and display data
This part I have succeeded and imitate tutorials in AnZhuoDuan run successfully,
Update the data by ClientDataSet insert, edit, post, ApplyUpdates,
But the update data with this a few for a can be used for loading and unloading end of android code is too weak
1. Do you have any other data update method can recommend for me to learn? Or similar PC that is flexible in the SQL query is written on the client to server directly implement way, I wish to consult
2. Because my AnZhuoDuan is LAN environment, excuse me what method can let AnZhuoDuan SQL database operation is not directly connected through datasnap to? Isn't this supposed to be more efficient and better operate? (my own AnZhuoDuan try DriverID=MSSQL or DriverName=MSSQL cannot be compiled by the android can only be used for PC)

3: I have always been a development of PC, accustomed to the similar:
Query2. Edit;
Query2. FieldByName (' kind '). AsString:='manual single;
Query2. Post;

Query1. Close;
In query1.sql. The clear;
In query1.sql. Add (' update tb1 set... ');
Query1. ExecSQL;
Such a database operation mode and DBGRIDEH to control the recordset
Do no similar DBGRIDEH AnZhuoDuan this tripartite control available?

CodePudding user response:

Use DataSnap, this is a mature technology, but it needs to connect to the database server, this cloud database, bad connection, its advantage is rich server, thin client,
Abandon DataSnap, can use the cloud database, data processing, the need to deal directly with the APP,

Each have advantages and disadvantages,

CodePudding user response:

Direct manipulation SQL pull
More convenient

CodePudding user response:

1. There is no limit to use SQL, you can directly write SQL in TFDQuery
(2) the mobile end direct Interbase, FireBird is ok, but the oracle, ms SQL server, other did not test

CodePudding user response:

PS: third-party components UniDAC and MyDAC can direct from the mobile end most database systems

CodePudding user response:

reference 4 floor DelphiGuy response:

PS: third-party components UniDAC and MyDAC can direct from the mobile end most database systems

Have installed the UniDAC, put up a UniConnection1 results AnZhuoDuan will not pass the compilation, has not to connect with it?

reference DelphiGuy reply: 3/f

1. There is no limit to use SQL, can directly write SQL in TFDQuery
(2) the mobile end direct Interbase, FireBird is ok, but the oracle, ms SQL server, other untested

I need the ms SQL server,,,,,,,

refer to the second floor lsh341999 response:

directly manipulate SQL,
More convenient

The great god, and I didn't understand how to operate the SQL, it seems not safe ZhuoDuan?

CodePudding user response:

May be you install UniDAC version of the problem (or part is cracked version to streamline the function), look at its description: https://www.devart.com/unidac/features.html
Can be from AnZhuoDuan direct database,

CodePudding user response:

refer to 6th floor DelphiGuy response:

may be you install UniDAC version of the problem (or part is cracked version to streamline the function), look at its description: https://www.devart.com/unidac/features.html
Can be from AnZhuoDuan straight even database

See tutorial is directly connected with this control database, but not found or is my complete cracked versions of how to install to support AnZhuoDuan,,, I continue to look for them, if there is still hope to share resources, greatly

CodePudding user response:

refer to 7th floor aoxiaomin response:

Quote: refer to the sixth floor DelphiGuy response:

May be you install UniDAC version of the problem (or part is cracked version to streamline the function), look at its description: https://www.devart.com/unidac/features.html
Can be from AnZhuoDuan straight even database

See tutorial is directly connected with this control database, but not found or is my complete cracked versions of how to install to support AnZhuoDuan,,, I continue to look for them, if there is still hope to share resources, greatly

I was under the:
UniDac 7.0.1 [D7 ~ XE10.2] source version of the download
此为源码,来之不易,请低调使用,如果用于商业用途,推荐购买正版 安装步骤请参考: http://blog.csdn.net/zengcong2013/article/details/12191631 unidac是一个功能强大的支持多数据库的引擎,可以安装在Delphi, Delphi for .NET, and C++Builder ,unidac的目的是帮助程序员更快的开发跨数据库应用软件, unidac是一个完整的标准数据库连接解决方案,可以支持 Oracle, SQL Server, MySQL, InterBase, 和 Firebird, unidac的技术亮点 支持最流行的数据库 全力支持最新的服务器版本 支持最新的IDE版本 的VCL和vcl.net两个版本 高性能 易于部署 支持所有标准和第三方数据感知控件 先进的连接管理 灵活的数据更新 uniscript组件,可以执行脚本 监测的能力,命令执行 先进的连接池 Unicode和字符集支持 包括数据库的独立数据存储 cachedupdates运作模式 计算和查找字段可以本地的排序和筛选 支持主从表 能全文检索 支持使用SQL宏 可定制的连接对话框 先进的设计期编辑

CodePudding user response:

Unidac has been successfully installed, the original is to add the Library Path this step I add less, installation guide is not written for android development, so there is no written add android Lib Path,,,, or install the tripartite control enough not familiar with the law

CodePudding user response:

UniDAC can be connected directly,