PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → WxLive Webinar #146 - Jeff Graham - HFSQL 101
WxLive Webinar #146 - Jeff Graham - HFSQL 101
Iniciado por guest, 15,abr. 2015 22:05 - No hay respuesta
Publicado el 15,abril 2015 - 22:05
Fri, Apr 17, 8:00 AM - 9:00 AM Central Time

https://plus.google.com/u/0/events/c0g6ssvb83kp2lo56si1lae2jq0

HFSQL features

• Query building (Reviewign Andy's class webinars, repository, bank account app)
• Simple
• file, field selection
• field removal
• modifying joins, inner/outer?
• inner, outer joins
• Two query example
• Sorting a query
• By programming
• Table - any field
• Modifying the SQL code
• Query with data modification
• UML ?
• Server triggers
• WD Server triggers
• Answers
• WDMeals (classic) - way to use either?
• Stored procedures
• How to create, update, delete
• Inventory backup and AccMealsZip example
• How to debug Server Procedures - see help page "Stored procedures and queries (HFSQL Client/Server)
• Stored queries - see same help page as above
• WD Meals query of a query for days of service
• Difference of stored query and a view?
• Functions for controlling server
• Unit example (WinDev): HsetServer?

Community Page: <a class="ExternalLink" rel="nofollow" target="_blank" href="https://plus.google.com/u/0/communities/115716915455953896388">https://plus.google.com/u/0/communities/115716915455953896388</a>