Preprocessing

Preprocessing

How to read from a set of points in an SQL database and find the closest cell

    • Ivan Mendez
      Subscriber

      Hey all

      I'm trying to create a UDF which reads from a SQL file the x,y,z coordinates of a point, and then I want to find the closest cell of that point. After looking around, I found that CX_Find_Cell_With_Point can find the cell given a point. The problem is, I can't get any information of that macro anywhere.

      How do I create a UDF to read from a SQL database and find the closest cell? is there another way of doing this besides CX_Find_Cell_With_Point?

    • Rob
      Ansys Employee

      I've been pointed at this thread too: some people obviously think I need more work... ;) 

      As per the comments on  https://forum.ansys.com/forums/topic/how-do-i-add-a-sqlite-header-in-my-udf-file/  the SQL bit will be more complicated. Using a text file with columns for x, y, z and then a file read routine will be significantly easier. 

Viewing 1 reply thread
  • You must be logged in to reply to this topic.