FlushToDatasSource method of the matrix

[Former Member]

Hi,

Does the FlushToDatasSource method of the matrix work. I'm using a matrix for a user-defined table. It presents the data that's in the table. When I change one of the fields and click the update button, I run this method. It looks like it saves it to the table. But when I close the form and reopen it, the change is not there. I'm using 8.8. Anything else I need to do to get the change into the table? It just looks like this method doesn't work.

Thanks,

Mike

[former_member201110 · Accepted solution]

Hi Mike,

Is your form a user-defined form? If so, flushing to the dbdatasource will do nothing unless the UDT is part of a UDO. It will look like it's working but if you run SQL Profiler then you won't see any SQL commands to update the data. For writing back to UDTs, you've got to either use the UserTables object in the DI API or direct SQL (which is allowed if your UDT is not part of a UDO).

Kind Regards,

Owen