Basic SQL database question

[David Bovill]

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