Re: [Gusdev-gusdev] sql change table

[Michael S. <msa...@pc...>]

Hi Federica,

It sounds like the row doesn't exist...   Did you do the preliminary insert?

select count(*) from core.userinfo;

This should be >= 1.  If not, refer back to the documentation about 
populating these tables.

--Mike


fed...@bi... wrote:
> Thanks Poliana,
> I tried as you suggest; no error appeared but I had always the same reply:
> '0 rows updated'.
> I connect to Oracle as 'sys/password as sysdba'.
> Any other ideas about how to solve the problem?
> Thanks
> Federica
> 
> 
> 
>>Hi Federica,
>>
>>Try
>>
>>UPDATE core.userinfo SET login='your_login', password='your_password'
>>WHERE user_id = 1;
>>
>>Poliana
>>
>>
>>On Wed, 9 Feb 2005 18:32:14 +0100 (CET), fed...@bi...
>><fed...@bi...> wrote:
>>
>>>Hi guys, I'm Federica! Some months ago I had some problems with GUS
>>>installation; then I had to perform other tasks, and after that I
>>>decided
>>>to delete everything and restart all!!
>>>I have got a new problem. I've never used sql before: I can't change the
>>>login, password and group in the core.userinfo, core.groupinfo,
>>>core.projectinfo tables! For example when I try to select or update some
>>>rows of core.userinfo table the replay is always: 0 rows
>>>selected/updated.
>>>Anyone can help me?
>>>Thanks, Federica
>>>
>>>-------------------------------------------------------
>>>SF email is sponsored by - The IT Product Guide
>>>Read honest & candid reviews on hundreds of IT Products from real users.
>>>Discover which products truly live up to the hype. Start reading now.
>>>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>>_______________________________________________
>>>Gusdev-gusdev mailing list
>>>Gus...@li...
>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>
>>
>>
>>-------------------------------------------------------
>>SF email is sponsored by - The IT Product Guide
>>Read honest & candid reviews on hundreds of IT Products from real users.
>>Discover which products truly live up to the hype. Start reading now.
>>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>_______________________________________________
>>Gusdev-gusdev mailing list
>>Gus...@li...
>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>
> 
> 
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev