Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
What's wrong with this?? |
Tue, Sep 24 2019 11:19 PM | Permanent Link |
Ian Branch | Hi Team,
Given the following.. {sql} update jobtickets set JobStatus = 'CL', DatePaid = CURENT_DATE where jobstatus = 'RP' and dateout is not null and dateinvoiced is not null and daterepaired is not null and datepaid is null {sql} In edbmgr it keeps erroring saying that "The column CURENT_DATE does not exist in the table JobTickets)" Huh? I knew that.. Why isn't CURRENT_DATE valid? The Help says it is.. Regards & TIA, Ian |
Wed, Sep 25 2019 12:37 AM | Permanent Link |
Ian Branch | I should add that the field DatePaid is a Date field.
|
Wed, Sep 25 2019 12:40 AM | Permanent Link |
Ian Branch | OK. Inter digital Interface error. Commonly known as Finger Fault.
It seems I can't spell. CURENT_DATE is NOT the same thing as CURRENT_DATE. All sorted. |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |