Win10, LO6462, HSQL 2.51
I have a table containing a number of fields like id, date, mercedes, audi, vw and a query based on this table.
Now I want to add another field for bmw which I can do easily with running ALTER TABLE “xyz” ADD COLUMN “bmw” VARCHAR(12) from a macro using a variable.
How would I add the new field programmatically to the existing query with or without criteria and or sort order ? Is this possible ? If yes, would the coding be a combination of sql, basic and xml ?
Thanks for your thoughts