neither error nor change on internal mySQL query

Dr. Hawkins dochawk at gmail.com
Tue Jun 14 19:43:10 EDT 2016


It seems to me that I should either get an entry or an error out of this:

Where dcmd is

*BEGIN ;*

*CREATE TABLE dhdbt_testy_zeke_______001  (unqKy SERIAL PRIMARY KEY, ktyp
CHAR(1),  kywd VARCHAR(50) UNIQUE, usr VARCHAR(20), tstmp TIMESTAMP WITH
TIME ZONE, scr TEXT, dltd BOOLEAN, cmd TEXT );*

*ALTER TABLE dhdbt_testy_zeke_______001 OWNER TO hawk ;*

*INSERT INTO dhdbt_testy_zeke_______001(kywd, ktyp, cmd) VALUES ('ckDinfo',
'M',  '100000a');*

*COMMIT;*


the code snippet

* revExecuteSQL dbNum, dcmd*

 *put* *the* *result* *into** theRes*


puts 0 into theRes.

This has worked for a couple of years, and stopped when I made changes
elsewhere.

Am I missing something her?
-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462



More information about the use-livecode mailing list