I need to add long SQL QUERY to CB editor for wxString.
Execute Block
(FistDate Date = :FistDate, LastDate Date = :LastDate)
returns(CurID integer, VPID integer, Name VarChar(500), val Numeric(15,2))
as
begin
FOR SELECT VP.Parent, Water.VP, VP.Name, SUM(Water.Water) FROM Water
..................
TO
..................
"Execute Block"
" (FistDate Date = :FistDate, LastDate Date = :LastDate)"
" returns(CurID integer, VPID integer, Name VarChar(500), val Numeric(15,2))"
" as"
" begin"
" FOR SELECT VP.Parent, Water.VP, VP.Name, SUM(Water.Water) FROM Water"
How quickly can be stamped quotes? I even had to make a plugin to solve this problem.
[attachment deleted by admin]