[Firebird-net-provider] Enhacement for FBCommand
Hi
I face with this situation:
Some customers want to have reports or export 'patterns' from fb database.
For that I have some possibilities as sql query or stored procedures. For
query I make all by code. For stored procedures I have 2 situation, first,
SP exist in database, second SP not exist. If SP exist , just run, etc. For
this case it would be useful to have a method to check if SP exist in
database, if not, recreate procedure. (this works only for FB2 I think, for
FB 1.x just create).
Sample code:
FBCommand fbCommand1 = new FBCommand();
fbCommand1.CommandType = CommandType.StoredProcedure;
if (!fbCommand1.Exists) {fbCommand.Recreate()};
What do you think about ???
TIA,
Paul
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] TransactionScope
Hello: Hi! I think we touch upon this before but completely abandon TransActionScope can some of your guys take a look at this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1608250SiteID=1question I've posted on MSDN? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1608250SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1608250SiteID=1 I owe you many thanks if you can solve this. Thanks in advance :-) Are you trying to use the TransactionScope with the Firebird provider ?? If yes, what version of the provider are you using ?? - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Mapping a database char column to a DataTable boolean column
I wish to map a the BOOLEANO domain column as a boolean column in a
datatable.
CREATE DOMAIN BOOLEANO AS
CHAR(1) CHARACTER SET NONE
DEFAULT 'F'
NOT NULL
CHECK (value in ('T', 'F'))
COLLATE NONE
is it posible?
thanks, sorry about my bad english...
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Mapping a database char column to a DataTable boolean column
You've to do it on client side by casting it to true/false.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enhacement for FBCommand
On 6/26/07, Mercea Paul [EMAIL PROTECTED] wrote:
SP exist in database, second SP not exist. If SP exist , just run, etc. For
this case it would be useful to have a method to check if SP exist in
database, if not, recreate procedure. (this works only for FB2 I think, for
FB 1.x just create).
Sample code:
FBCommand fbCommand1 = new FBCommand();
fbCommand1.CommandType = CommandType.StoredProcedure;
if (!fbCommand1.Exists) {fbCommand.Recreate()};
What do you think about ???
How can FBCommand (re)create procedure? FBCommand has no idea about
internal code of procedure.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Mapping a database char column to a DataTable boolean column
Andres F. Moschini escribió:
I wish to map a the BOOLEANO domain column as a boolean column in a
datatable.
CREATE DOMAIN BOOLEANO AS
CHAR(1) CHARACTER SET NONE
DEFAULT 'F'
NOT NULL
CHECK (value in ('T', 'F'))
COLLATE NONE
is it posible?
thanks, sorry about my bad english...
Jiri Cincura escribió:
You've to do it on client side by casting it to true/false.
But, then, I can't use DataAdapter to fill a DataTable with boolean
values instead char?
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Mapping a database char column to
Hello: But, then, I can't use DataAdapter to fill a DataTable with boolean = Try setting the column in the DataTable structure as boolean - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enhacement for FBCommand
Hello: How can FBCommand (re)create procedure? FBCommand has no idea about internal code of procedure. And anyway that shouldn't be responsability of the provider ... - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Mapping a database char column to
Carlos Guzmán Álvarez escribió: Hello: But, then, I can't use DataAdapter to fill a DataTable with boolean = Try setting the column in the DataTable structure as boolean do you mean that? tablasEstaticasDeUsuario.Tables.Add(Especificaciones); tablasEstaticasDeUsuario.Tables[Especificaciones].Columns.Add(UBICABLE,System.Type.GetType(System.Boolean)); this is the exception: System.ArgumentException: System.FormatException: String was not recognized as a valid Boolean. at System.Boolean.Parse(String value) at System.String.System.IConvertible.ToBoolean(IFormatProvider provider) at System.Convert.ToBoolean(Object value) at System.Data.Common.BooleanStorage.Set(Int32 record, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store F in CONTENIBLE Column. Expected type is Boolean. at System.Data.DataColumn.set_Item(Int32 record, Object value) at System.Data.DataTable.NewRecordFromArray(Object[] value) at System.Data.DataTable.LoadDataRow(Object[] values, Boolean fAcceptChanges) at System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues, Boolean acceptChanges) at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at PF.DbMm.ConexionMm.fillTablasEstaticasDeUsuario() I'm using .Net 1.1, Fb 1.5 and Firebird Net Provider 1.7 maybe it works with new versions? Muchas Gracias. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-98) FirebirdDDEX v2.0.1.0 broken after installing FirebirdClient 2.1.0.0 RC1
FirebirdDDEX v2.0.1.0 broken after installing FirebirdClient 2.1.0.0 RC1 Key: DNET-98 URL: http://tracker.firebirdsql.org/browse/DNET-98 Project: .NET Data provider Issue Type: Bug Components: DDEX Provider Affects Versions: 2.0.1 Environment: Windows XP SP2 - MS VS 2005 Express C# SP1 .NET v2.0.50727 Reporter: Mike Bluett Assignee: Carlos Guzman Alvarez After installing FirebirdClient-2.1.0-RC1.exe, and then subsequently dropping a FbConnection object onto a form, the ellipses that were present at the end of the ConnectionString property are no longer present. I then added the connection string manually and then tried dropping a fbDataAdapter onto the form. The fbDataAdapter also is broken in that with the previous version of the FirebirdClient, there was a small right-pointing arrow on the top of the fbDataAdapter instance in the tray that is no longer present. This prevents any further designer capability (i.e., creating the FbCommand strings and setting up all the database constraints, etc.). After encountering this problem, I de-installed the FirebidClient and the FirebirdDDEX, then made sure all registry entries were removed. Then I re-installed both of them and I still see the same problem. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Mapping a database char column to
I'm using .Net 1.1, Fb 1.5 and Firebird Net Provider 1.7 maybe it works with new versions? I wouldn't think so, T and F are not recognised by .NET as strings representing true or false (i.e. Convert.ToBoolean(T) or Convert.ToBoolean(F) are what is throwing that exception). You've got three options: 1. Make the column CHAR(5) and store exactly True or False, or 2. Make the column SMALLINT and store 1 or 0, 3. Leave the database as-is, and manually convert the column in the DataTable #1 is a bit silly, given that it needs 5 bytes to store rather than 1. #2 may not be ideal if you don't want to change the database schema. That leaves only #3, I'm afraid. FbDataAdapter is not really suited for what you're trying to do here. It's purpose it basically to create an in-memory copy of the database table that you can modify and then update back in the database. It's not designed to do complex data conversions (that's what an OR mapper is for). Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
