General information
Category:
Coding, syntax & commands
Another solution is to simply overwrite the old table with a new iteration with the same name.
Use in ( Old Table )
Select ( field list ) from ( table and join code ) into Table ( Old Table's name )
>We use Coldfusion with a vfp datasource and run a query that deletes all records in a vfp table:
>delete * from vfptable
>
>However, as would be expected, it marks all records for deletion, rather than physically deleting them.
>
>How would we pack the table as part of the query? Would it be a stored procedure? If so what might that look like and where would it be placed?
>
>Thanks in advance.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only