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