On Sun, Oct 6, 2013 at 8:38 AM, Dr. Hawkins <doch...@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>
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to