Forum Discussion

VGaur's avatar
VGaur
Contributor
9 years ago

Unable to use sql functions JDBC steps

Hey,   I am trying to write a JDBC query to insert/update a location field in a table but seems like Ready!API is not able to  insert/update record.The connection settings to the database are good ...
Nastya_Khovrina's avatar
Nastya_Khovrina
Icon for Alumni rankAlumni
9 years ago

Hi Varun,

 

Thank you for your post. As we have found out in the corresponding support case not all SQL functions don't work. For example, the DATEADD function works fine.

Let's continue working in the support case regarding the issue.  

Nastya_Khovrina's avatar
Nastya_Khovrina
Icon for Alumni rankAlumni
9 years ago

Varun,

 

Currently, it's not possible to use queries with geometry::STGeomFromText or geography::STGeomFromText in Ready! API. We have registered a feature request in our DB to implement this functionality.