[Firebird-net-provider] Character Set Confusion For Spanish Characters
Im sure this has been discussed a thousand times but Im clueless. I have a database that contains Spanish text in both VarChar and BLOB (sub_type 1) fields. Im using C# and the .NET connector v2.6.5.0 in a .NET v4.0 application. I can insert data into the database using UTF8 and view it in FlameRobin to verify its correctness. However, if I try to read it back using UTF8, I get character substitutions that are incorrect for some of the Spanish characters (like the á). I have to read it back using character set NONE to get back correct results. The database has no default character set defined. What character set should I be using for English and Spanish text and why doesnt the same character set used to write the data read it back correctly? Thanks -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Pivot result set
Hi All, We need to pivot some rather large result sets so that the columns become the rows for our statistician to use the data in SAS. Is there an easy way to do this? Thanks, Steve -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Update database from DataSet
I have a class method that returns a DataSet to my application. I bind the DataSet to an DataGridView and would like to do the Add/Edit/Delete stuff This is just done by any basic grid by default (when not disabled). Just bind your DataSet to Grid and you're done. I'm using a DataGridView. When I add a record with auto-insert and then move off the new record, it isn't saved and no exceptions are thrown. There seem to be several ways to bind a DataSet to a grid. I've tried it assigning the DataSet directly to the grid.DataSource property and using a BindingSource assigning the DataSet to it's DataSource property and then assigning the BindingSource to the grid.DataSource. There are probably other ways as well. Can you give me an example of settings that will allow the grid to perform the updates? from within the grid. How do I update the database from the DataSet? The only examples I've seen use a DataAdapter but all I have access to in my application is a DataSet. Is it possible to update a DataAdapter from an existing DataSet or is there another way to update the database? If you have instance of DataAdapter, you just specify Update-, Delete- and InsertCommand and call Update method for this particular table. Or you can go thru DataTable in DataSet and check inserted, deleted and modified rows and performs correspondent steps to update DB. I don't have access to the DataAdapter unless I can create one and populate it from the DataSet. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Update database from DataSet
HI All, I have a class method that returns a DataSet to my application. I bind the DataSet to an DataGridView and would like to do the Add/Edit/Delete stuff from within the grid. How do I update the database from the DataSet? The only examples I've seen use a DataAdapter but all I have access to in my application is a DataSet. Is it possible to update a DataAdapter from an existing DataSet or is there another way to update the database? Thanks, Steve - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Help with SQL
HI All, I'm trying to get invoice totals to show item totals and payments. I have 3 tables; Invoice, InvoiceDetail, and InvoicePayment. I first tried a join like this. select i.SiteID, i.InvoiceID, NULLIF(Sum(d.Charge), 0) AS Itm, NULLIF(Sum(p.Amount), 0) AS Pmt, (NULLIF(Sum(d.Charge), 0) + NULLIF(Sum(p.Amount), 0)) AS Total from Invoice i join InvoiceDetail d ON (d.InvoiceID = :InvoiceID) join InvoicePayment p ON (p.InvoiceID = :InvoiceID) where (i.InvoiceID = :InvoiceID) group by i.SiteID, i.InvoiceID order by i.SiteID, i.InvoiceID This multiplies each sum of charges by the number of payments and each sum of payments by the number of charges. Secondly, I tried sub-queries like this. select (Select NULLIF(Sum(Charge), 0) from invoicedetail where InvoiceID = :InvoiceID) AS Itm, (Select NULLIF(Sum(Amount), 0) from invoicepayment where InvoiceID = :InvoiceID) AS Pmt, ((Select NULLIF(Sum(Charge), 0) from invoicedetail where InvoiceID = :InvoiceID) + (Select NULLIF(Sum(Amount), 0) from invoicepayment where InvoiceID = :InvoiceID)) AS Tot from Invoice i where (i.InvoiceID = :InvoiceID) This gives me the correct results and works fine in IBExpert but craps out with the .NET provider with the error message: 08d26y2008 16:15:06 - FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error SQL error code = -206 Column unknown INVOICEID No message for error code 336397208 found. --- FirebirdSql.Data.Common.IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown. at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector() at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse() at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse() at FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String commandText) at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavio r behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBeh avior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, 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) Any ideas? Steve Harp - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Unsupported On-Disk Structure
Yes, it's in the C:\Program Files\Firebird\Firebird_2_0\examples\empbuild folder and was installed with the Firebird installation. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, November 27, 2007 10:08 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Unsupported On-Disk Structure On 11/27/07, Steve [EMAIL PROTECTED] wrote: This is not an issue with the database file. As I said in my original post, I get the same error when trying to connect to the sample Employee.Fdb that installs with Firebird. Are you sure, that it's from Firebird distribution? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Unsupported On-Disk Structure
Bingo! I had renamed the gds32.dll but the Interbase service was still running. Apparently, the .NET provider doesn't use the client dll. Thanks very much... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Julio Saucedo Sent: Tuesday, November 27, 2007 10:35 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Unsupported On-Disk Structure Maybe is that you still have Interbase installed and it's using the default port GDS_DB (3050) for the incoming connections. So, the message is sent by Interbase and not Firebird. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider