![]() Temp_salesdetail.cdesc, temp_salesdetail. ![]() The easiest way to avoid this problem is to create persistent TFields on your source dataset and make sure the ID column one is type ftLargeInt in both. Use existing generator If selected, an existing generator will be used for this field. For Sqlite, the source dataset field type should be ftLargeInt, not ftAutoInc, because the autoinc column size in the Sqlite database is 64-bit, not 32-bit (which is what ftAutoinc assumes). Replace dispdetail.cdinvno WITH temp_salesdetail.cinvno, ĭispdetail.cilinekey WITH temp_salesdetail.cilinekey, ĭispdetail.nprice WITH temp_salesdetail.ntotretail, ĭispdetail.cdesc2 WITH temp_salesdetail.cdesc, ĭispdetail.cdetailid WITH temp_salesdetail.cdetailid, Create new generator If selected, a new generator will be created for this field. ![]() With the append blank and replace statment's everything works correctly and the new auto increment id is correct.ĭoes anybody have any idea of what piece of the puzzle i am missing? Thank you for your response. All fields are correct in the insert sql statement however when you check the table the auto increment field is empty. with UniSQL1 do begin SQL. When inserting into this table now i am getting data type mismatch error. Razorsql firebird autoinc column creation mac os Table editing tools: insert, update and delete table data, find and replace data, preview SQL generated code Richardson Software RazorSQL 9.4.5 RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. I have added an auto incrementing field (nid) to several tables.ĪLTER TABLE dispdetail ADD COLUMN nid i AUTOINC NEXTVALUE RECCOUNT() +1 DEFAULT RECNO() Comes in handy because I'm starting to use autoinc for new tables and had it on my dolist to code a utility to handle adding this field automatically, taking into account existing records.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |