Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
yes, in fact they must be an index on each provider's table OK, nice. Will you commit new sql script? I have look to add primary key on each table but there is a problem with the role and usersrole tables because this table have not column that accept primary key because their size is too

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Jiri Cincura
Le roy Arnaud wrote: I have look to add primary key on each table but there is a problem with the role and usersrole tables because this table have not column that accept primary key because their size is too big so i must change the struct of these tables and change the role provider !

Re: [Firebird-net-provider] Database Shutdown

2006-11-08 Thread paha
Ok, i tried it with newer version 1.5.3, it survived 3-4 shutdowns/onlines, and i switched off Database restart during debugging, so hope the problem is partially solved. really looking forward to firebird 2.0 version. Thanks, anyway -- View this message in context:

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
Well, with 8k page size, the table roles is OK... But I think the 4k page size we should handle as base. But changing the implementation isn't good. Maybe we should way, if somebody will report this as a problem and then make final decision. OK? Ok. What's wrong with membership provider

Re: [Firebird-net-provider] FbDataAdapter problem

2006-11-08 Thread Carlos Guzmán Álvarez
Hello: If command is an Insert FbDataAdapter should call row.AcceptChanges() before UpdateParameterValues The update method is implemented following the steps explained in the microsoft docs, the AcceptChanges call gets done as the last step and thats is not going to change. --

Re: [Firebird-net-provider] FbDataAdapter problem

2006-11-08 Thread Carlos Guzmán Álvarez
Hello: Please, can you make a test using the CVS sources ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Using Tomcat but need to do more? Need to support web services, security? Get stuff done

Re: [Firebird-net-provider] RoleProvider

2006-11-08 Thread Steve Ramacher
Nothing I want said fbmembership provider.cs. i have correct some bug : 1) when you create an user IsOnline is not set so a exception is raised because the domain's bool is NOT NULL. I have a script that was corrected and forwarded to Le roy Arnaud about 3 weeks ago that correct these concerns.

[Firebird-net-provider] Stored Procudure

2006-11-08 Thread Pham Huu Le Quoc Phuc
Hi all! In Sql Server, I can write stored procedure which return records, with no output parameters. In firebird, I can do the same? Ex: ALTER PROCEDURE [dbo].[st_BALANCE_ASSETSelect] ( @BALANCE_ASSET_KEY uniqueidentifier ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result

Re: [Firebird-net-provider] Stored Procudure

2006-11-08 Thread Carlos Guzmán Álvarez
Hello: Hi all! In Sql Server, I can write stored procedure which return records, with no output parameters. In firebird, I can do the same? You can't. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com