T
tim
Guest
We're getting there, but we haven't fully arrived. New online operations in 12.2 (e.g., database triggers, rename field) do automatic notification of all connected clients so they automatically update their schema cache. Unfortunately, the automatic notification for the already existing online schema changes (add new table, add new field, etc.), which are more common, did not make it under the wire for 12.2. So you still have to rely on the compile of an empty .p to cause the refresh of the schema cache. In 11.7.6 (coming soon) and in 12.1, the client will also refresh its schema cache if you prepare a dynamic query.
Continue reading...
Continue reading...