Atrix and Ben, Thanks for the reply. I got rid of the text error. It is working now.
But I will tell you what I am doing. In case you are interested. The SGET function appears to be what will do this. I have a field in my OrderSummary table called Ord_OrderNumber. I assign a unique value to the field with the following: <@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs <@currenttimestamp>>"> This tag yields a 18 digit value. Later on I want to print orders for today or within a range of dates. I thought I should be able select rows from the table based on the first 8 characters of this field. I create a "Where" clause for the DBMS with the following when looking for todays orders. <@assign local$Select "( ((SGET(o1.Ord_OrderNumber,8,1))='<@currentdate format="%Y%m%d" encoding=sql>') ) "> Thanks for the help. Steve -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Saturday, August 09, 2003 10:00 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Probably SQL ? Hey, Steve can you throw me a bone here :-) I still don't see what you are trying to do :-P R:Base has some function you can use to deal with datetime data type ---- (DEXTRACT(datetime)) Returns the date portion of a value that has a DATETIME data type. In the following example, the value of vdextract is 06/12/93. SET VAR vdextract = (DEXTRACT('06/12/93 12:15:30.123')) ---- (TEXTRACT(datetime)) Returns the time portion of DATETIME. In the following example, the value of vtextract is 12:15:30.123. SET VAR vtextract = (TEXTRACT('08/09/95 12:15:30.123')) ---- select * from table where (DEXTRACT(DateTimeColumn)) = 'MM/DD/YY' --- also in my experience with R:Tango you need to treat dates like text and quote them. Ben Johansen - http://www.pcforge.com -Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm -Authorized Alt-N Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Saturday, August 09, 2003 7:44 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Probably SQL ? I tried the following with the SGET function. <@assign local$DateSelect "( (SGET(o1.Ord_OrderNumber,8,1) >= '<@arg StartYear encoding=sql><@arg StartMonth encoding=sql><@arg StartDay encoding=sql>') AND ('<@arg EndYear encoding=sql><@arg EndMonth encoding=sql><@arg EndDay encoding=sql>' <= SGET(o1.Ord_OrderNumber,8,1)) )"> Got the following error: Syntax is incorrect for the command TEXT Any ideas? Steve Fogelson -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Saturday, August 09, 2003 10:57 AM To: Witango User Group (E-mail) Subject: Witango-Talk: Probably SQL ? Win2K Server, R:Tango 2000, R:Base 6.5 I create a field in a table with the following witango code: <@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs <@currenttimestamp>>"> Later I want to do a search based strictly on the first 8 characters of the field. I use the following code to set up the Where variable for DBMS <@assign local$DateSelect "( (o1.Ord_OrderNumber >= '<@arg StartYear encoding=sql><@arg StartMonth encoding=sql><@arg StartDay encoding=sql>') AND ('<@arg EndYear encoding=sql><@arg EndMonth encoding=sql><@arg EndDay encoding=sql>' <= o1.Ord_OrderNumber) )"> I then use the following in the DBMS: Where <@var local$Select encoding=none> Some how I have to do something with o1.Ord_OrderNumber Maybe I am going to have to create a field with just the date???? Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
