destructive "SELECT" query for SQL?

Peter Haworth pete at
Sun Oct 6 13:39:39 EDT 2013

On Sun, Oct 6, 2013 at 8:38 AM, Dr. Hawkins <dochawk at> wrote:

> But is there a way to do a SELECT sot that it wipes a field?
> INSERT/RETURNING doesn't seem to be compatible with having a subsequent
> SELECT (if I could, I could return the original argument as a string while
> setting the field to NULL).

Not sure I fully understand but you can use the literal NULL in a SELECT
statement, eg SELECT col1,col2,NULL FROM.....

lcSQL Software <>

More information about the Use-livecode mailing list