Hi!
i never used Data Abstract so i’ m m learning it. I have many difficults because Examples doesn t works and all examples are only for advanced users.
Examples give problem about decimal. Please check screenshot.
I have a simple server and open 2 clients. when i change record and Applychange, it is not update in second client…Why? This is my testcase.
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?
your sample doesn’t use decimal. can you attach correct example, pls?
you can implement event by yourself that will inform all clients that record of table or table was changed.
Data Abstract doesn’t inform clients about such changing yet
you can use our TDAMemDataTable for such purpose. setting table.RemoteFetchEnabled to false allows to store data in memory w/o using remote sources.
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.
Hi,
variant type isn’t supported, but you can store your variant as blob. uROBinaryHelpers unit has some methods that allow to convert Variant to Binary (i.e. stream) or TBytes and vice versa