| View previous topic :: View next topic |
| Author |
Message |
lambcutlet
Newbie
Joined: 06 May 2006
Posts: 3
|
 Posted: Mon Mar 19, 2007 11:11 pm Post subject: Mysql OOo unknown type '246 |
 |
|
I am running FC6 and have installed mysql (5.0.27-1) with a java connection(3.1.12-3) to open office (2.0.4).
I have set myself a challenge to keep the scores of my local club, using a database I thought it would be simpler in the long term than a spreadsheet.
Anyway all was going well until I tried to use the 'Sum' or 'Average' function under the query section (design view). Every time I try either 'Sum' or 'Average' I get this error
| Code: | | SQL Status: S1000 Unknown type '246 in column 0 of 1 in binary-encoded result set. |
Does any one have a solution to this?
The format of the column is 'number general' |
|
| Back to top |
|
 |
lambcutlet
Newbie
Joined: 06 May 2006
Posts: 3
|
| Posted: Wed Mar 21, 2007 1:29 pm Post subject: sorted |
|
|
To help others, I have found a solution.
The format of the column in question was set to INTEGER when I changed it to Real(FLOAT) the SUM and AVERAGE functions now work.
I do not have a reason why it now works, but possibly others could comment. |
|
| Back to top |
|
|
|
