AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Example: Merging views
HMergeView (Example)
Example: Merging views
WINDEVWEBDEV - Código ServidorReportes y ConsultasCódigo de Usuario (UMC)AjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBConectores Nativos Two views are created to select players from 2 different clubs. These views are merged into a final view that will be browsed.
EXTERN MyView1, MyView2, MyView_Finale
// Create the view named "MyView1"
IF HCreateView("MyView1", Club_Liverpool, "Player_Name", ...
"", "Player_Name > '" + Variable1 + "'", hViewDefault) = False THEN
Error(HErrorInfo())
END
 
// Create the view named "MyView2"
IF HCreateView("MyView2", Club_Chelsea, "Player_Name", "", ...
"Player_Name > '" + Variable2 + "'", hViewDefault) = False THEN
Error(HErrorInfo())
END
 
// Merge the 2 views into the final view named "MyView_Final"
IF HMergeView("MyView_Final", "MyView1", "MyView2", ...
hViewUnion, "Player_Name", "Player_Name" = False THEN
Error(HErrorInfo())
END
 
// Browse view
HReadFirst("MyView_Final")
WHILE HOut() = False
// Process to perform
HReadNext("MyView_Final")
END
 
// Destroy the views
HDeleteView(MyView1)
HDeleteView(MyView2)
HDeleteView(MyView_Final)
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