Were you using PostGreSQL?

I got an INSERT to work now by coding a raw SQL exec:

Now even using the standard Database Query Builder for automatic updating of these 2 fields I get the following error:

UPDATE failed on SQL command: UPDATE roles SET diz = :1 WHERE id = 1
    RevDb error:

Is this a bug with the RunRev implementation for PostGreSQL?

Trevor - I get similar errors with your library - guess this is because it sits on top of RunRev stuff?


On 17 Jan 2006, at 21:32, Scott Kane wrote:

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
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to