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 --

[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 se

Re: [Firebird-net-provider] RoleProvider

2006-11-08 Thread Le roy Arnaud
Steve Ramacher a utilisé son clavier pour écrire : >> 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. > Hello in the cvs i have put your changes but i have

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

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 quic

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. > -- Car

Re: [Firebird-net-provider] Whitespaces in datafields

2006-11-08 Thread VS-Polis
Title: Jürgen Thomas Hello, you could use the property DataGridView.AutoGenerateColumns. By the way: this is a problem of the user interface, therefore C# or NET-SDK and not of Firebird or provider. Regards Juergen Daniel Hahn schrieb: Hello, my dataset - connected by bindingsource to a co

[Firebird-net-provider] Whitespaces in datafields

2006-11-08 Thread Daniel Hahn
Hello, my dataset - connected by bindingsource to a control or directly to a datagridview - contains several records filled with strings. E.g. column1 = ID, column 2 = NAME. In the datagridview and in the control the values from column 2 are shown BUT the strings are filled up with whitespaces u

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Jiri Cincura
Le roy Arnaud wrote: > Nothing i want said fbmembership provider.cs. i have correct some bug : :P -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to su

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 pro

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: http://www.nabble.com/Databa

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] 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 to

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
Jiri Cincura a couché sur son écran : > Le roy Arnaud wrote: >> it could be a good idea but for exemple in the membership provider >> delete function have a parameter ("deleteAllRelatedData") that define >> if all related data of the users should be delete and if we put an fk >> the related dat