Tried that too with no luck. Today, after a computer re-start the code, with no changes, seems to be working correctly.
Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ben Petersen Sent: Friday, June 18, 2010 8:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: What is wrong with this code... Shouldn't the text be enclosed in single quotes? SET VAR v_date TEXT = ('''+.vmonth + ', ' +(CTXT(IYR(.vinc_date)))+''') Ben On Thu, Jun 17, 2010 at 11:26 PM, Javier Valencia <[email protected]> wrote: > The following code runs correctly on 7.5 > ==================== > SET ERROR MESSAGE 2038 OFF > drop table Temp_graph1 > SET ERROR MESSAGE 2038 ON > CREATE TEMP TABLE `Temp_graph1` + > (`labor_sort` INTEGER , + > `labor_date` TEXT 15 , + > `labor_hr_reg` REAL , + > `labor_hr_ot` REAL , + > `labor_hr_2times` REAL , + > `labor_hr_all` REAL ) > > 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) > > RETURN > ==================== > > The code simply creates a table, defines a few variables and loads them into > the table. > > When I run the same code on Extreme64 I get the message: > > ERROR - Column labor_date must be a valid TEXT. (122) > > Obviously the variables are the correct type as they are freshly defined and > verified while tracing. The code has been R:Styled and does not show any > errors. > Can anyone duplicate this issue? > I am running the latest R:Base Extreme 9.0(64) Version 9.0.1.10604 > > Any help will be greatly appreciated. > > Javier, > > Javier Valencia, PE > 913-829-0888 Office > 913-915-3137 Cell > 913-649-2904 Fax > [email protected] > > --- RBASE-L > ================================================ > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > ================================================ > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > ================================================ > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > ================================================ > > >
