Which prawn to know three layers of the database structure in the android mobile phone client:
Delphi DataSnap MSSQL
Using structure statement
Append.
Post;
ApplyUpdates (1);
Add records to the mobile terminal line command has triggered a PC server event BeforeApplyUpdates
In this may have to add some code, just as the query inspired BeforeGetRecords event, to be articulated ADOQuery1. SQL code, such as

On the mobile end ClientDataSet1 has put add rows in the Grid1 shows.
But remote MSSQL database and not added success, due to server errors happened.
Remote error: Access violation at address 006 d2d57 module in '* * * *. Exe'. Read of address 00000000
How to deal with?
Please master, Thx.

CodePudding user response:

Mobile phone App using DataSnap, basically consistent with the PC,
This should be the ApplyUpdates (1); The problem on the update,
My experience, write their own Updates, instead of it, mainly through the SQL statement to update upload data,

CodePudding user response:

reference 1st floor lyhoo163 response:

phone App using DataSnap, basically consistent with the PC,
This should be the ApplyUpdates (1); The problem on the update,
My experience, write their own Updates, instead of it, mainly through the SQL statement to update upload data,

ApplyUpdates (1)
; The return value processing,,,,,,,,

CodePudding user response:

 procedure TForm3. DataSetProvider1UpdateError (Sender: TObject; 
The DataSet: TCustomClientDataSet; E: EUpdateError; UpdateKind: TUpdateKind; 
Var Response: TResolverResponse); 
The begin 

end; 

the event there is an error message

CodePudding user response:

Whether the view operation, you check it

CodePudding user response:

Just a simple database containing the view

CodePudding user response:

This should be the ApplyUpdates (1); The problem on the update,

In dealing with the Access and the SQLite database, do not have this problem!
Maybe you're right, but in addition to the platform, such as upgrades, are there any other better way?

CodePudding user response:

Don't wait for the new version, or teach yourself to write an update letter please,

CodePudding user response:

Himself wrote a update function

I try to improve the Edit system controls in version 10.2 the copy of the cut function, only the results of his paster paste destroyed.
10.2.2 version only for improved (of course the compatibility with system has yet to be upgraded).

The ability to upgrade system - male and female servants couldn't do it!

Help me!!!!!!

CodePudding user response:

refer to 7th floor lyhoo163 response:

don't wait for the new version, and taught himself to write an update letter got

Where to get the relevant data can be reference?
Or who wrote a similar code?

CodePudding user response:

Update statement to realize a try

CodePudding user response:

Through learning, good open ticket.