SQLColumnRemove - cDbUpdateFunctionLibrary
Deletes a SQL table column.
Type: Function
Parameters: Integer hTable, String sColumnName
Parameter |
Description |
hTable |
A file handle to the table name. Same as the Filelist.cfg slot number. |
sColumnName |
The column name to delete/remove. |
Syntax
Function SQLColumnRemove Handle hTable String sColumnName Returns Boolean
Call: |
Get SQLColumnRemove TableName.File_Number "ColumnName" to bOK |
Description
Use it to remove a table column.
Note: If you want to add a field/column with the DataFlex Embedded database, use the ApiColumnRemove function instead.
Example
Procedure OnUpdate
Boolean bOK
Get SQLColumnRemove Order.File_Number "MyColumnName" to bOK
End_Procedure