I have a simple Datasnap Server application and Client Application.
The server has a method ATable(int) that returns a TDBXReader* representing the result of a query.
The dataset has column types of char (40) and integer and Boolean.
My client code is able to extract the char(40) columns from the dataset using the TDBXValue->GetAnsiString()
method but any other column type always returns a value of zero when calling the appropriate type such as TDBXValue->AsInt32 for an integer column;
Is this normal ?
I have provided a sort of fix by changing the query text to convert integer column values to strings with the SQL STR function etc.
This however requires more effort on the client side in re-coding the integer columns back to integers. Is there a way to fix this ?
The relevant Server and client code is attachedDatasnapServerAndclient.txt