Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Claude,
>
>I'm not sure what you are asking here. In trying to duplicate what I thought your problem was I created a table with a numeric field of len (10,2). I then populated it with 2 records with vlaues of 1.5 and 23.45. I then executed a SELECT on that table, the size of the resulting num field was 10,2 the same as the field being queried.
>
>Can you shed some light for me?
>
Ok. final report is from a table. User enters a year. If year is previous years just run the report. If year is this year then either new rows need to be entered our update. There are 3 rows dervieved from the data for the previous year and value for last field is calculated from another table. The first two fields are keys, other field 4 to n are numbers, N(12,0). Field 3 is the sum of fields 4 to n. What I find is that in resulting cursor field 3 is N(19,0), fields 4 to n-1 are N(16,0), and field n may vary. I created 3 cursors to test and may be able to create one cursor for first 3 rows. My problem is how to create row 4 (the sum of the first 3 rows) where field 1 is the same as field 1 in other rows and row 2 is a specific literal string with same lenght as other rows. Then I need to insert/update the 4 rows in the table used to create the report.
hope this help.
Thanks
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement