Transfering data from a table to another database

[Hyperbytes]

The normal cause of this is that you have removed or renamed a field in your database so the query no longer matches the schema. This can cause the query to stop opening

If you intend to remove or rename a field then it is best practice to remove the fields from queries first

I reported this a year ago

Not really a bug as such, but an irritation with query editor

In my current project i was given a number of data tables for the basis of a project in which some of the data was relevant, some not but at the time the customer was unsure what they needed. On few few occasions (wont do that again) , i just added all fields to server actions, not by table.* but by dragging all the field names into the action as it was unclear which were needed at the time. Mainly this was to allow for sortable headers in tables which don’t work with table.* Recently i start…