Bug: Save crashes when more than a couple of edits

[oisbosslady]

Describe the bug

Use left nav to use the option to open to open 1,000 rows (no edit x rows option listed in nav)

SELECT TOP 1000 * FROM dbo.tablename;

After 3 or 4 cell edits. hit save

Get this error and have to start all over again:

incorrect syntax near the keyword 'TOP'

Tried to remove Top and run qry again. Same error.

SELECT * FROM dbo.tablename;

Constant having to start 100% over after a couple edits - and maybe the save works again

Product

SQLPro for MySQL

App version

2026.07 115707.5

Platform

macOS

Installation source

App Store

[oisbosslady]

[hankinsoft]

I'm not quite understanding the steps here. Is there any chance you could send a video of whats going on? Or, is it reproducible with the sample database? If so, could you send a set of steps which reproduces it?

[oisbosslady]

Go into the app
Select table -> Select 1,000 Rows -> Opens table
Make like 5 simple cell edits
Click Apply and get that error like 80% of the time and have to start over by clicking on the Run SQL on top right
Find the fields I need to edit again and try to hit Apply again

[hankinsoft]

Can you reproduce the issue and hit 'preview and apply' rather than just apply? That should show me the query which is getting generated. If you could post that here, that would help me figure out whats going on.