with an existing record, and a fieldname that is in a column that has a
UNIQUE INDEX, if I do sqlite_exec("UPDATE database SET
fieldname="&sqlite_escape("get calculator batteries")&" WHERE
fieldname=sqlite_escape("get hp50g calc cells")&";"
this code actually deletes the record. it should not. I don't ever
remember seeing this happen in any database like pgsql or mysql. I can
test again to see for sure.
the test code can be seen at
http://www.autoitscript.com/trac/autoit/ticket/2012
I used escape on the strings. existing examples do not put single
quotes on the strings. if single quotes are required to mske strings
work as I think they do, please tell me. I am not getting errors.
--
Jim Michaels
j...@jimscomputerrepairandwebdesign.com
http://JimsComputerRepairandWebDesign.com
http://JesusnJim.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
