You might also want to change the "quote value" setting in your Tango IDE.
Its been a while since I worked with Tango, but I remember the default value was set in a way that it was not compatible with R:Base. Any time I had to use a date value in the construction of a query, I had to change the 'quote value' to the opposite of its default setting. If this doesn't make sense, try using the builder to build an insert statement that includes a date. The columns (I'm working from memory, so this may be a bit flawed) you will see are your db column, value to be inserted, and quote value. You will need to change the quote value to make the insert work. This MAY be what is causing your problem. At least it might be worth a look-see, what-the-heck-nothing-else-is-working-so-why-not-try-it. Dale Thomas --- Claudine Robbins <[EMAIL PROTECTED]> wrote: > Since you asked for ideas and not solutions, how > about using BETWEEN value1 > AND value2? Also, you need to match the date and > time format to the actual > data or change the format before your select > statement SET DATE FOR, SET > TIME FOR... > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Fogelson, > Steve > Sent: Wednesday, March 17, 2004 12:01 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - [No Subject] > > Windows 3002 Web Edition, R:Tango 5, Oterro update 3 > > Can't figure out what is wrong with the following > DBMS action: > > SELECT B2.B_ID, B2.B_ShopperID, P1.P_Name, > B2.B_Quantity, P1.P_Price1, > B2.B_TimeStamp FROM Products P1, Basket B2 WHERE > ((P1.P_ID=B2.P_ID) AND ( > (b2.B_TimeStamp >= '2004/01/01 00:00:01') and > ('2004/12/01 23:23:59' <= > b2.B_TimeStamp) )) > > 2418 [RBTI][Oterro ODBC Driver][Catalog]-ERROR- > Invalid DATETIME value > (2418) S1000 > > I have tried 2004/12/01, 12/01/2004, 12/01/2004 > 23:23:59. Nothing seems to > work. > > b2.B_TimeStamp is a field with the Timestamp > Datatype. > > Any ideas? > > Steve Fogelson > Internet Commerce Solutions > > --- 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. > ================================================ > ===== Dale W. Thomas [EMAIL PROTECTED] Veteran, USAF, 1972-76 ===== "Anything your mind can conceive and believe, it can achieve." __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/
