Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone have the proper way to do an easy comparison with my Progress DB's DATETIME? I need to pull anything updated in the "sku-whs-spf" table over the last 2 days.
vStartDate=Date(now()-2, 'DD/MM/YY.ffff')
FROM PUB."sku-whs-spf"
WHERE "LastUpdate" >= '$(vStartDate)';
But all I get is the error
SQL##f - SqlState: S0002, ErrorCode: 4294947291, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Table/View/Synonym not found (7519)
SQL SELECT
As if I'm doing an improper comparison, or the field is not there (but it definitely is). I've even tried harcoding my vStartDate
TIA
Does it load without the where clause?
FROM PUB."sku-whs-spf"
I am wondering what happens if you remove the two double quotes, does that change anything
FROM PUB.sku-whs-spf
WHERE "LastUpdate" >= '$(vStartDate)
I think this error to me "There is no file loaded from Source". What source u used for?
Does it load without the where clause?
FROM PUB."sku-whs-spf"
I am wondering what happens if you remove the two double quotes, does that change anything
FROM PUB.sku-whs-spf
WHERE "LastUpdate" >= '$(vStartDate)
I am embarrassed to say you are correct. It does NOT load without the WHERE clause. I spent hours trying to fix this WHERE clause, but the problem was that I broke my CONNECT statements right above. Sorry for wasting everyone's time. Thanks!