General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only