repeat with

[Jim Ault]

Liam, 

One more suggestion when working with SQL strings...
try the following...

  put "'" into ap  --stands for apostrophe
  put ap & cleanSQL (field tField) & ap & "," after tRowData

which is much easier to read and type than
  put "'" & cleanSQL (field tField) & "'" & "," after tRowData

instead, you could use
put numtochar(39) into ap

Jim Ault
Las Vegas

On 1/13/06 12:45 PM, "liamlambert" <liamlambert at mac.com> wrote:

> I have not set the itemDel
> 
> on fSave
>    global gConID
> 
>    if fld "total" is empty then
>      answer error "THERE IS NO TOTAL" as sheet exit to top
>    end if
> 
>    put  
> "name1,phone,child,adult,total,credit,paymenttype,address,address1,addre
> ss2,email,seatNo,ticket,showID" into tFieldNames
>    repeat for each item tField in tFieldNames
>      put "'" & cleanSQL (field tField) & "'" & "," after tRowData
>    end repeat
> 
>