Karen, I don't believe so. The fields in order are: labor_sort labor_date labor_hr_reg labor_hr_ot labor_hr_2times labor_hr_all
The values in order are: 1 .v_date .vhr_reg_t .vhr_ot_t .vhr_2times_t .vhr_all_t All the values match in type the corresponding columns. The interesting part is that the code ran perfectly in 7.5. Last night, I made sure that both versions had the same settings, did a disconnect and shut down of both versions with no luck. Today, after a computer re-start, the code runs correctly today...go figure...now I will go and comb over the few hairs I have left, get a cup of coffee and watch the World Cup. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, June 18, 2010 8:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: What is wrong with this code... Javier: In your "insert" statement, you are inserting the variable vhr_reg_t into the labor_date column, aren't you? That's the "real" variable you defined. I don't see v_date being loaded into that table.... Boy, you owe TONS to the "duh" pot.... Karen SET VAR vhr_reg_t REAL = 100.0 SET VAR vhr_ot_t REAL = 100.0 SET VAR vhr_2times_t REAL = 100.0 SET VAR vhr_all_t REAL = 300.0 SET VAR vinc_date DATE = '10/05/2007' SET VAR vmonth = (TMON(.vinc_date)) SET VAR v_date TEXT = (.vmonth + ', ' + CTXT(IYR(.vinc_date))) INSERT INTO temp_graph1 + (labor_sort, + labor_date, + labor_hr_reg, + labor_hr_ot, + labor_hr_2times, + labor_hr_all) + VALUES + (1,.v_date,.vhr_reg_t, .vhr_ot_t, .vhr_2times_t, .vhr_all_t)
