In Italy we have ‘,’ like decimal character but in other countries decimal character is ‘.’
Can you answer some questions?
1)Can i use Tvirtualtable(mydac) or any other memory table for remote database or i must to use absolutedb,mysq,mssql,nexusdb,etc databases?
How can i update all clients database from server? or i must to use refresh from client side?
3)I need to have extra field in client database, it is possible? For example in remote Database i have NAME,SURNAME,AGE fields in client database can i have extra field for example NAME,SURNAME,AGE,TELEPHONE NUMBER but when i use refresh it update only NAME,SURNAME and AGE?
simple case - use Refresh method. it just closes and reopens table.
complicated mode - use RefreshFromServer method. it allows to update table according to specified DynamicWhere. Data rows will be updated w/o closing table.
imagine that your table has UpdateTimeStamp field that is filled by trigger so you can specify DynamicWhere that will contain expression like UpdateTimeStamp > :lastupdate. so it will return all rows that were changed after specified date.
yes, it is possible. you need to declare TELEPHONE NUMBER as calculated on client-side
I need in remoteServer to use TDaMemTable for example table1 and clients connects with table1. With DataAbstract i must to use mysql,mssql or other sql database or i can use only memtable? In ConnectionManager i can use only third party sql server but i can t use memory table. I try to use memorytable in server but it is not possible. I send test case but there is no option to use local memorytable.