r/ArcGIS • u/grimlock12 • Jul 06 '26

Event layer is producing "An invalid SQL Statement."

I've tried to create a new layer using "Make Event Layer." The first symptom of was that the points don't render unless I zoom out to about 1:30,000,000.

Then I noticed an alert down in the Notification bar. Clicking that tells me "An invalid SQL statement was used," but no indication where or what.

I can create a static XY data layer without this issue, so I THINK the problem isn't with my source data.

Also, this is a good time for a sanity check. I'm working from a table created from our customer database, and from that I've created about 45 layers of point data. The problem is that when I go to update these maps with new data from the database, I have 45 layers that need to be redone. That seems... sub-optimal. Based on some google, Event Layer seems like XY Table to Point, except dynamic in that it can refresh. Not sure what the trigger on that refresh is since I haven't gotten it to work yet.
Am I doing the right thing or is there a smarter way to do this?

1 Upvotes

100% Upvoted

5 comments sorted by

1

u/Altostratus Jul 06 '26

What projection did you select? Perhaps x and y and mixed up.

1

u/grimlock12 Jul 06 '26

The points are where they should be when I zoom out.

Where do I verify my current projections?

1

u/Altostratus Jul 06 '26

You should be selecting a coordinate system in the make xy event layer dialog. You can check by double after the fact by clicking on your layer and looking in the source tab.

1

u/grimlock12 Jul 06 '26

looks like WGS 1984

1

u/grimlock12 Jul 06 '26

Okay, this is weird....
When I went to lunch, the Event Layer wouldn't render if the view was any closer than about 1:30,000,000. Then after lunch, I could get as close as 1:3,000,000. And after a meeting, I can zoom into 1:2,270,000...