Basic SQL database question

Scott Kane scott at proherp.com
Tue Jan 17 15:32:17 EST 2006


David,

> Now the primary key is set to "id" - so this should work - 
> but should  
> the tool not issue an INSERT statement and not an UPDATE 
> (there is no  
> data yet in the db). _______________________________________________

I assumed the same thing.  But I could not get it to do
this.  There is an advanced Rev tutorial on the DB QB
and this may have the answer, but I don't know as I haven't
shelled out for it yet (there is a bunch of advanced tutorials
that look worthwhile getting access to).  I found I could do
everything *except* insert using the tool.  For that reason
I have pursued coding for the functionality needed.  Of course
I'd *love* to be corrected here....  ;-)

Scott





More information about the use-livecode mailing list