News:

Accounts with zero posts and zero activity during the last months will be deleted periodically to fight SPAM!

Main Menu

how to add long line to the CB Edit

Started by Borr, November 14, 2009, 10:39:11 AM

Previous topic - Next topic

Borr

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]