AnsweredAssumed Answered

Export from SQL database

Question asked by sev0302 on Nov 18, 2014
Latest reply on Nov 21, 2014 by sev0302

I'm attempting to write a model which will select records matching a specific query and map the result. Let me start by saying that I'm completely new to doing this with a SQL database as the origin of the data. Our IT folks just gave me access to the database this morning.

 

I first wanted to test by attempting to export records satisfying a simple query and going from there. Found the table (dbo.lwmain), right-clicked, and chose Export --> To dBase (single). Using the expression builder, I built an expression to pull a single record using the unique ID (inci_id LIKE '14036678_'). The expression will verify but no records are returned. I get Warning 000117: Warning empty output generated. The record does exist and the query is valid, so I am confused.

 

Does anyone have any ideas?

Outcomes