Repository navigation
ask touches tables
Which database tables a routine reads and writes. One of the diagram questions of the ask verb -- see Diagrams and Charts for the model, the bundle and click-to-source.
Planned engine verb -- drag-lint ask is not shipped yet. Today ask this question with the chart pipeline command below, or with Ask-Report.ps1 (see Charts and the IDE).
From RAD Studio: drag-lint > Reports > Which tables this routine touches... -- put the caret on the selection first (see IDE Menu Reference).
drag-lint ask --question touches-tables --at <file.pas>:<line>:<col> --db <project.sqlite>
The selection is the symbol under --at (resolved exactly as Type at Cursor resolves a caret). Today, ask it by name through the chart pipeline:
New-DiagramArtifact.ps1 -Question touches-tables -Target MyServer.Orders.TOrderDM.SaveOrder -DbPath <project.sqlite>
A method or routine.
The routine and the physical tables it READS, WRITES, or both.
symbol_facts.sql_reads / sql_writes, derived from the SQL a routine issues through FireDAC.
None.
A tier that owns no database connection (a thin client that asks a server over a pipe) has no SQL facts at all. Asked on such an index, the question REFUSES with that reason instead of drawing "0 tables", which would read as "does no database work". Ask the server-tier index.