destructive "SELECT" query for SQL?
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.....
lcSQL Software <http://www.lcsql.com>
More information about the Use-livecode