>>loGather = createobject ("empty") >>insert into a cursor, >>for lnRun = 1 to fcount() >> lcFild = fieldnum(lnRun) >> lcVal = eval (lcFld) && some tricks with nvl ?? >> if !isnull(lcVal) >> = addproprty(loGather, lcFld, lcVal) >> endif >>next >>insert from name loGather>>or similar tricks....
>procedure ExecuteSQL(SQLstatement) >set null off >execscript(SQLStatement)>Now the question is what kind of security holes does this create? Any thoughts? If I knew how to set null off by default maybe I wouldn't need the SP.