Re: [firebird-support] Save decimal data type
On Tue, May 28, 2013 at 10:26 AM, franchessko wrote: > Hi, I'm a new firebird user. I joined here to ask for help. > I develop in DotNet Technologies, and I have this problem: > > > And the problem is: > --- > When I send a Query with a decimal data type like '25.80' -without quotes- > the data is saved in firebird like this 2580, > (the database field was created as Decimal 18,4) > Without seeing the actual queries you used, I'm guessing about why you see what you see, but I can tell you what Firebird is doing. When you store 25.80 in a column that's defined as decimal 18,4, Firebird stores the value as in integer, which in this case would be 258000 (two hundred fifty eight thousand). The scale is part of the field definition. Firebird uses the scale when doing comparisons, so 258000 scale 4 is more than 257 scale 5 and less than 260 scale 1. All that is fine, internally. However, the SQL numeric and decimal types are based on data types used in COBOL. Those data types are not generally supported in more modern languages. When you retrieve a decimal or numeric value with a non-zero scale, you should probably ask for it as a floating point number or a string. You'll get better information from the Firebird .NET driver list on exactly how to push decimal and numeric values through that interface. > I tried sending the same number, but with the comma '25,80' but firebird > says: "Dynamic SQL Error. SQL Error code = -804. Count of read-write > columns does not equal count of values" > Firebird does not use the locale to choose the separator between the integral and decimal portions of a number, so it's reading 25,80 as two values 25 and 80. Good luck, Ann [Non-text portions of this message have been removed]
Re: [firebird-support] Save decimal data type
At 07:52 a.m. 29/05/2013, Mark Rotteveel wrote: >On 28-5-2013 21:45, Francisco José Scheffer wrote: >> >> Gracias W O; pero el problema sigue... >> Si envío en mi consulta el valor con punto, es decir: 25.80, firebird >> ingresa 2580,; ¿entiendes? >> no se ya que configurar... >> gracias por tu ayuda > >Walter and Francisco, could you please use English. This is an English >language support list. Better, if English is a problem for you, use the Spanish support list. You can find the link at http://www.firebirdsql.org/en/mailing-lists/ ^ heLen ^ (Moderator)
Re: [firebird-support] Save decimal data type
On 28-5-2013 21:45, Francisco José Scheffer wrote: > > Gracias W O; pero el problema sigue... > Si envío en mi consulta el valor con punto, es decir: 25.80, firebird ingresa > 2580,; ¿entiendes? > no se ya que configurar... > gracias por tu ayuda Walter and Francisco, could you please use English. This is an English language support list. Mark -- Mark Rotteveel
Re: [firebird-support] Save decimal data type
On 28-5-2013 16:26, franchessko wrote: > Hi, I'm a new firebird user. I joined here to ask for help. > I develop in DotNet Technologies, and I have this problem: > > First OS info: > -- > ->OS = Windows 7 Enterprise SP1 > ->System type = 64b. > ->Original languaje = English. (But I've installed the spanish pack languaje) > ->Regional settings are all set to Spanish-Argentina. > > Firebird Info: > -- > Version = 2.5.2.1 > .Net Provider = Version 3.0.2 for .NET 4.5 > > > And the problem is: > --- > When I send a Query with a decimal data type like '25.80' -without quotes- > the data is saved in firebird like this 2580, > (the databse field was created as Decimal 18,4) > > I tried sending the same number, but with the comma '25,80' but firebird > says: "Dynamic SQL Error. SQL Error code = -804. Count of read-write columns > does not equal count of values" > > what do I have to set up? what to do? > thanks a lot to all. This question is probably more suited for the Firebird .NET driver mailing list. See http://www.firebirdsql.org/en/mailing-lists/ for subscription details. It might important to mention how you set the value in your query. Mark -- Mark Rotteveel
Re: [firebird-support] Save decimal data type
Gracias W O; pero el problema sigue... Si envío en mi consulta el valor con punto, es decir: 25.80, firebird ingresa 2580,; ¿entiendes? no se ya que configurar... gracias por tu ayuda Francisco José Scheffer De: W O Para: firebird-support@yahoogroups.com Enviado: martes, 28 de mayo de 2013 16:21 Asunto: Re: [firebird-support] Save decimal data type No puedes enviar valores numéricos con comas porque el Firebird entiende que estás enviando dos valores distintos, la coma se usa para separar valores. Y el punto se usa para separar la parte entera de la parte decimal de un número. Si quieres leer sobre Firebird en castellano y preguntar las dudas que tengas puedes visitar mi blog: http://firebird21.wordpress.com Saludos. Walter. On Tue, May 28, 2013 at 10:26 AM, franchessko wrote: > ** > > > Hi, I'm a new firebird user. I joined here to ask for help. > I develop in DotNet Technologies, and I have this problem: > > First OS info: > -- > ->OS = Windows 7 Enterprise SP1 > ->System type = 64b. > ->Original languaje = English. (But I've installed the spanish pack > languaje) > ->Regional settings are all set to Spanish-Argentina. > > Firebird Info: > -- > Version = 2.5.2.1 > .Net Provider = Version 3.0.2 for .NET 4.5 > > And the problem is: > --- > When I send a Query with a decimal data type like '25.80' -without quotes- > the data is saved in firebird like this 2580, > (the databse field was created as Decimal 18,4) > > I tried sending the same number, but with the comma '25,80' but firebird > says: "Dynamic SQL Error. SQL Error code = -804. Count of read-write > columns does not equal count of values" > > what do I have to set up? what to do? > thanks a lot to all. > > Francisco Scheffer > Argentina > DotNet Developer. > > > [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] Save decimal data type
No puedes enviar valores numéricos con comas porque el Firebird entiende que estás enviando dos valores distintos, la coma se usa para separar valores. Y el punto se usa para separar la parte entera de la parte decimal de un número. Si quieres leer sobre Firebird en castellano y preguntar las dudas que tengas puedes visitar mi blog: http://firebird21.wordpress.com Saludos. Walter. On Tue, May 28, 2013 at 10:26 AM, franchessko wrote: > ** > > > Hi, I'm a new firebird user. I joined here to ask for help. > I develop in DotNet Technologies, and I have this problem: > > First OS info: > -- > ->OS = Windows 7 Enterprise SP1 > ->System type = 64b. > ->Original languaje = English. (But I've installed the spanish pack > languaje) > ->Regional settings are all set to Spanish-Argentina. > > Firebird Info: > -- > Version = 2.5.2.1 > .Net Provider = Version 3.0.2 for .NET 4.5 > > And the problem is: > --- > When I send a Query with a decimal data type like '25.80' -without quotes- > the data is saved in firebird like this 2580, > (the databse field was created as Decimal 18,4) > > I tried sending the same number, but with the comma '25,80' but firebird > says: "Dynamic SQL Error. SQL Error code = -804. Count of read-write > columns does not equal count of values" > > what do I have to set up? what to do? > thanks a lot to all. > > Francisco Scheffer > Argentina > DotNet Developer. > > > [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Firebird database
Hi, So you found 640Gb of information. Is it related with recent leaks of account form BVI offshore companies? :) Regarding your questions - see gbak manual here http://www.firebirdsql.org/en/reference-manuals/ Regards, Alexey Kovyazin IBSurgeon > I found a database that weighs 640G, > this basis consists of seven files. fdb ie > > datos_1.fdb > datos_2.fdb > datos_3.fdb > datos_4.fdb > datos_5.fdb > datos_6.fdb > datos_7.fdb > > as I can generate a backup of the database and how I can perform > restore, thanks. > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
[firebird-support] Save decimal data type
Hi, I'm a new firebird user. I joined here to ask for help. I develop in DotNet Technologies, and I have this problem: First OS info: -- ->OS = Windows 7 Enterprise SP1 ->System type = 64b. ->Original languaje = English. (But I've installed the spanish pack languaje) ->Regional settings are all set to Spanish-Argentina. Firebird Info: -- Version = 2.5.2.1 .Net Provider = Version 3.0.2 for .NET 4.5 And the problem is: --- When I send a Query with a decimal data type like '25.80' -without quotes- the data is saved in firebird like this 2580, (the databse field was created as Decimal 18,4) I tried sending the same number, but with the comma '25,80' but firebird says: "Dynamic SQL Error. SQL Error code = -804. Count of read-write columns does not equal count of values" what do I have to set up? what to do? thanks a lot to all. Francisco Scheffer Argentina DotNet Developer.
[firebird-support] Firebird database
I found a database that weighs 640G, this basis consists of seven files. fdb ie datos_1.fdb datos_2.fdb datos_3.fdb datos_4.fdb datos_5.fdb datos_6.fdb datos_7.fdb as I can generate a backup of the database and how I can perform restore, thanks. [Non-text portions of this message have been removed]