-- Formatted output .output report.html SELECT '<tr><td>' || block_name || '</td><td>' || COUNT(*) || '</td></tr>' as html_row FROM attributes GROUP BY block_name;
# Add data for row_idx, row in enumerate(data, start=1): for col_idx, value in enumerate(row): table.SetText(row_idx, col_idx, str(value)) sqlite autocad
Here are some tips and best practices for using SQLite with AutoCAD: -- Formatted output
(sqlite:close db) (princ "Attributes exported to SQLite") ) ' || block_name || '<
for date, count in cursor.fetchall(): text += f"date: count changes\n"
;; Create table in AutoCAD (command "_.TABLE" "10,10" "20,15") (foreach row result (command (itoa (car row)) (rtos (cadr row) 2 2) (caddr row)) ) (sqlite:close db) (princ) )
using System; using System.Data.SQLite;