sss2000
Posts: 1
|
Posted: 12/15/2014, 8:25 AM |
|
Can somebody help , I want to populate a table through insert query however I want that the table should truncate or delete all rows so that only new rows are inserted.
Thanks
|
|
|
eratech
Posts: 513
|
Posted: 12/16/2014, 10:09 PM |
|
In something like the 'Before Show' or 'Before Submit' of the record, you can execute custom SQL and do that.
Check the manual for 'Execute Custom SQL' for some examples.
E
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|