Re: [Firebird-net-provider] RC3 Bug Report, Example Included

2006-05-03 Thread Jiri Cincura
On 4.5.2006 0:25 Eduardo Alvarez wrote: Hi there, I'm getting the following exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." But the above error message does not apply to my case, so I think this is a bug. Hi,

Re: [Firebird-net-provider] How to create a Membership provider with FBclient for .net

2006-05-03 Thread Jiri Cincura
On 4.5.2006 4:35 Charles Urbina wrote: Jiri, Once again thanks I will look into that demo. Have a great day. Well, MSDN or SDK is your friend. :) Where are you located (Country/City) just curiousity. I'm in New York City Czech Republic/Europe, Central European Summer Time (GMT+2) -- Jiri

Re: [Firebird-net-provider] How to create a Membership provider with FBclient for .net

2006-05-03 Thread Charles Urbina
Jiri, Once again thanks I will look into that demo. Have a great day. Where are you located (Country/City) just curiousity. I'm in New York City Regards Charles   From:  Jiri Cincura <[EMAIL PROTECTED]>Reply-To:  firebird-net-provider@lists.sourceforge.netTo:  firebird-net-provider@lists.sour

[Firebird-net-provider] RC3 Bug Report, Example Included

2006-05-03 Thread Eduardo Alvarez
Hi there, I'm getting the following exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." But the above error message does not apply to my case, so I think this is a bug. To reproduce, follow this simple steps: 1) Cr

RES: [Firebird-net-provider] Error Stored Procedure

2006-05-03 Thread Luiz Carlos Sant'Ana Junior
Thks, but what in my coda cause this error ?   Sds,   Luiz Carlos Sant’Ana Junior Gennari & Peartree Projetos e Sistemas Programmer - Divisão 29 Centro de Desenvolvimento e-mail:   [EMAIL PROTECTED] Telefone: 0xx11 3208-4338 Celular:  0xx11 9757-7565   0xx11 9527-7983

RES: [Firebird-net-provider] Error Stored Procedure

2006-05-03 Thread Luiz Carlos Sant'Ana Junior
No, because this procedure have two parameters. Via isql, works. Sds, Luiz Carlos Sant’Ana Junior Gennari & Peartree Projetos e Sistemas Programmer - Divisão 29 Centro de Desenvolvimento e-mail: [EMAIL PROTECTED] Telefone: 0xx11 3208-4338 Celular: 0xx11 9757-7565 0xx11 9527-7983 www

RE: [Firebird-net-provider] Error Stored Procedure

2006-05-03 Thread Paul Mercea
Hi Error 335544569 means Dynamic SQL Error And 335544512 means Parameter mismatch for procedure   Regards Paul M     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Luiz Carlos Sant'Ana Junior Sent: Wednesday, May 03, 2006 9:48 PM To: firebird-net-provider@lis

Re: [Firebird-net-provider] Error Stored Procedure

2006-05-03 Thread Jiri Cincura
On 3.5.2006 20:48 Luiz Carlos Sant'Ana Junior wrote: command = New FbCommand("EXECUTE PROCEDURE SP_APONT_VLD_FUNCIONARIO(@CODFUNCIONARIO,@CODSETOR,@ERRO,@DSCFUNCIONARIO)", FireBirdConnection()) Is the procedure returning something? 'select * from SP_APONT_VLD_FUNCIONARIO' works? The 33554456

[Firebird-net-provider] Error Stored Procedure

2006-05-03 Thread Luiz Carlos Sant'Ana Junior
Hi,   I have a problem :   This is my code :   Dim command As FbCommand     Dim da As FbDataAdapter     Dim ds As New DataSet     Dim param As FbParameter     Dim rd As FbDataReader     Try command = New FbCommand("EXECUTE PROCEDURE SP_APONT_VLD_FUNCIONARIO(@

Re: [Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread paha
I was supposing something like that ;-) So, if you have integer field (i hope smallint) , add DataGridViewCheckBoxColumn and assosiate it with this Field - that should work just fine out-of-the-box. For me works :-) Even if you have had strings like "Yes" and "No" - you could handle Cellormating

Re: [Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread Amanda Kabak
You can configure your check box column to take 1 and 0 for true and false. Takes a little fooling around, but that's what I've gotten to work. Something like this: this.colFocus.FalseValue = 0; this.colFocus.HeaderText = "Focus"; this.colFocus.MappingName = "Fo

Re: [Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread Alex Jankowski
Hi paha, I want to use the DataTable in a DataGridView which has a DataGridViewCheckBoxColumn. Therefore the column in the DataTable needs to contain boolean values. /Alex -Original message- From: paha [EMAIL PROTECTED] Date: Wed, 3 May 2006 13:45:10 +0200 To: firebird-net-provider@lis

Re: [Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread paha
If I understood you correct, you should retrieve DataTable as always and then just convert the integer value of the field with Convert.ToBoolean(object) I'm pretty noob, so i'm not sure if i may advise you but... I usually do so public static class DBConvert { public static bool isNu

[Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread Alex Jankowski
Hi, I have a DataTable with a column that contains boolean values. I have no problem saving this data to the firebird database. The problem arises when I want to retrieve the data again using the FbDataAdapter as these boolean values now are integers. How do I get this column as boolean values i

Re: [Firebird-net-provider] Charset

2006-05-03 Thread paha
Sorry for previous POST, got it in HTML without Hi, need help, i'm s stupid, but i can't solve it: I have next function to execute SQL command public bool ExecSQL(string SQL) { bool result = true; try { if (m_fbConnection.State ==

[Firebird-net-provider] Charset

2006-05-03 Thread paha
Hi, i need help, i'm s stupid, i can't solve the problem: I have next function to execute SQL command public bool ExecSQL(string SQL) { bool result = true; try { if (m_fbConnection.State == System.Data.ConnectionState.Open) m_fbConn