destructive "SELECT" query for SQL?

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


On Sun, Oct 6, 2013 at 8:38 AM, Dr. Hawkins <dochawk at gmail.com> 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.....

Pete
lcSQL Software <http://www.lcsql.com>



More information about the Use-livecode mailing list