🚀 go-pugleaf

can you explain what that is

i am  building up a query in the code manually and ftp to a server where it is run thru isql 

how do i do i 

sample here


        filename := 'c:\dsmout\DSMADD-'+ controlcontrol_dsm.text + account_number.Text + formatdatetime('yyyy-mm-dd-hh.ss',now()) + '.sql';
        s:= tstringlist.create;

        try

           s.add ('CONNECT /data/dsmdata/interbase/amends/AMENDS.GDB user "SYSDBA" password "masterkey";');
           s.add ('DELETE FROM customers where cust_number = ' +'"' + account_number.text + '";');
           s.add ('INSERT INTO customers(cust_number,cust_dsm,cust_date,cust_status,');
           s.add ('cust_cfname,cust_cad1,cust_cad2,cust_cad3,cust_cad4,cust_cadpc,');
           s.add ('cust_mobile,cust_contact,cust_phone,cust_fax)');

           s.add (' VALUES ("' + account_number.Text     + '","'
                               + controlcontrol_dsm.Text + '","'
                               + sqldate                 + '","O","'
                               + account_name.Text       + '","'
                               + acc_address1.text       + '","'
                               + acc_address2.text       + '","'
                               + acc_address3.text       + '","'
                               + acc_address4.text       + '","'
                               + acc_postcode.Text       + '","'
                               + acc_sec_mobile.text     + '","'
                         


"Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> wrote:
>	The easiest solution is to use a parameterized query. This *always*
>works.
>
>-- 
>Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>Please read and follow Borland's rules for the user of their 
>  server: http://support.borland.com/entry.jspa?externalID=293