[RBASE-L] - Troubles updating

[Charles Parks]

 

Thanks, but MEditDateTime  is a DATETIME column not a TEXT column. 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 23, 2002 4:18 AM
To: [EMAIL PROTECTED]
Subject: [RBASE-L] - Troubles updating

In a message dated 12/23/2002 5:01:30 AM Eastern Standard Time, [EMAIL PROTECTED] writes:

   UPDATE recentqimenu SET meditdatetime = (DATETIME(.#DATE,.#TIME)) +
   WHERE stfmbr = .vuser AND primarymacro = 'qimac\cleanmn.mac'

Charlie,

Looks like you are trying to put 2 variables in one column. The proverbial 2 pounds of stuff in a one pound bag. If meditdatetime Text value, something like

UPDATE recentqimenu SET meditdatetime =  +
(DATETIME((ctxt(.#DATE)) +  ',' + (ctxt(.#TIME)))) +
   WHERE stfmbr = .vuser AND primarymacro = 'qimac\cleanmn.mac'

I don't have a running copy of RBase here, so I can't verify the code. If that doesnt work, then calculate the variable first then do the update, such as

Set var vMEditDT Text = ((ctxt(.#DATE)) +  ',' + (ctxt(.#TIME))) +
   WHERE stfmbr = .vuser AND primarymacro = 'qimac\cleanmn.mac'

UPDATE recentqimenu SET meditdatetime = .vMEditDT +
   WHERE stfmbr = .vuser AND primarymacro = 'qimac\cleanmn.mac'


This may work for you. Good way to make 2 pounds of stuff into one pound, and it will fit <g>

Damon