H
H. Martins
We can create Queries in Objects->Queries window.
I suppose it makes sense that the SELECT code generated here can be
used elsewhere.
Also, if we edit a Query and right-click SQL View, we see code lines
starting with SELECT, FROM, WHERE, ORDER BY, etc.
Indeed, it seems this must have some functionality. I would guess we
could link ListBoxes, whatever, to predefined queries or parts of a
query code (like SELECT & FROM from a saved query, then adding a
local WHERE string, etc).
Indeed I lost quite some time looking around this matter and ... so
long no luck.
Could I have some hints, links, whatever, please?
I am defining (each form) some public string variables carying the
parts of the SQL code needed to build a complete SELECT statement.
This works OK but seems nor very clever.
Thanks
Henry
I suppose it makes sense that the SELECT code generated here can be
used elsewhere.
Also, if we edit a Query and right-click SQL View, we see code lines
starting with SELECT, FROM, WHERE, ORDER BY, etc.
Indeed, it seems this must have some functionality. I would guess we
could link ListBoxes, whatever, to predefined queries or parts of a
query code (like SELECT & FROM from a saved query, then adding a
local WHERE string, etc).
Indeed I lost quite some time looking around this matter and ... so
long no luck.
Could I have some hints, links, whatever, please?
I am defining (each form) some public string variables carying the
parts of the SQL code needed to build a complete SELECT statement.
This works OK but seems nor very clever.
Thanks
Henry