AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Example: Executing and deleting a view
HDeleteView (Example)
Example: Executing and deleting a view
This example Is used to create a view and to delete it when the necessary processes have been performed.
// View on CUSTOMER file, with all the file items
// 1st item of the view as sort item
// Use the Replace() function if the string contains quotes (')
// Because the quotes in the strings must be prefixed by a backslash (\)
ResView is boolean
MyView is Data Source
ResView = HCreateView(MyView, "CUSTOMER", "", "", "COMPANY='" + Replace(CompanyName, "'", "\'") + "'")
IF ResView = 0 THEN
Error("Error while creating the view",...
  "Error #" + HError() + ", internal #:" + HError(hSubErrFirst)
ELSE
// Process on the view
...
HDeleteView(MyView)
END
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 27/05/2022

Señalar un error o enviar una sugerencia | Ayuda local