Skip to Content
avatar image
Former Member

SDA virtual table on SQL Server view/money field as integer

Hello experts,

We just created a Virtual table on an SDA connection over a SQL server view which consists of a SELECT containing few fields and a couple of them derived from a function call (returning "money" type value), defined like this:

create view zvw_mysql_view as(
select 
   my_date,<br>   my_docnr,<br>   my_line,<br>   my_kf001,<br>   my_kf002,<br>   (call function my_function(my_date)) as exchange_rate
from dbo.some_table);

field "exchange_rate" receives the "my_function" output which in SQL server is a "money" type...

At the Virtual table side I expect to get lines like these:

my_date my_docnr my_line my_kf001 my_kf002 exchange_rate

20180201 100001 1 100 1810 18.10

20180202 100002 2 100 1980 19.80

however I am getting "exchange_rate" as:

my_date my_docnr my_line my_kf001 my_kf002 exchange_rate

20180201 100001 1 100 1800 18

20180202 100002 2 100 1900 19

Any suggestions? Is virtual table fully compatible with SQL server money and/or function calls from selects/views? any workaround?

Any clue is welcome.

Thanks in advance.

Cheers

Bernardo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers