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

- November 26, 2022 at 4:47 am
  
  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?
- December 8, 2022 at 5:16 pm
  
  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.

Ansys Innovation Space

Earth Rescue – An Ansys Online Series

The climate crisis is here. But so is the human ingenuity to fight it. Earth Rescue reveals what visionary companies are doing today to engineer radical new ideas in the fight against climate change. Click here to watch the first episode.

Ansys Blog

Subscribe to the Ansys Blog to get great new content about the power of simulation delivered right to your email on a weekly basis. With content from Ansys experts, partners and customers you will learn about product development advances, thought leadership and trends and tips to better use Ansys tools. Sign up here.

Trending discussions