Insert Data into Detail Table
I recently discovered the Lacerte SDK and am excited by the promise. I am having no trouble reading data, but cannot get data written.
I am using Python with the pyodbc driver to connect to the database.
For example, trying to add to the Dividend Screen (Series=13) a value for Capital Gains (Code=3) for an existing entry (Prefix=1)
import pyodbc
cnxn = pyodbc.connect(r'driver=LacerteDSIIDriver; DataDir=L:\19TAX\IData;', autocommit=True)
cursor = cnxn.cursor()
cursor.execute("INSERT INTO [ZZZDEV2-Detail] (Series, Prefix, Code, Suffix, StateAbbr, Amount, Description) VALUES (13,1,3,1000,'IL',69,'DAN');")
cnxn.commit()This executes without error, but no data is written to the table.
The Lacerte SDK manual indicates the ODBC driver can write to the Detail table, but I could not find any examples.
Has anybody written to the Detail table? Care to show the code?
