BC ExternalSql

Answers

• Options

  jordi79 Member Posts: 272

  2022-12-01

  Create a view based on the external SQL table. In this view, you can cast the datatype from original ext sql table to the type of datatype supported by NAV. Then use this view as external table to your BC installation.

  1
• Options

  eredax Member Posts: 3

  2022-12-04

  Great ,
  
  it works.
  
  In reading I have no more problems but now I cannot write, as it tells me that the field to be edited is part of a function.
  
  However I think I will use two different recordsets; one pointing to read and one to write.
  
  Thank you very much
  Emilio
  

  0