topic-34261

Board index FiveWin for Harbour/xHarbour Mysql/Mariadb Effect date (Mr. Rao)

dagiayunus

Posts: 85

Joined: Wed Nov 19, 2014 01:04 PM

Mysql/Mariadb Effect date (Mr. Rao)
Posted: Sat Jun 24, 2017 10:41 PM

Dear Sir Mr.Rao

How we can set and use effective dates with mysql/mariadb for example

Item A Price 60 Rs from Dt.20/06/2017
Item A Price 80 Rs from Dt.24/06/2017

Thanks & Regards

Regards

Yunus

FWH 21.02

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Mysql/Mariadb Effect date (Mr. Rao)
Posted: Sun Jun 25, 2017 03:53 AM

Code (fw): Select all Collapse

function GetPrice( cItemID, dDate )

   local cSql

   cSql  := "SELECT date,price FROM prices WHERE itemid = ? AND IFNULL( date, '0000-00-00' ) <= ? ORDER BY date DESC LIMIT 1"
   cSql  := oCn:ApplyParams( cSql, { cItemID, dDate } )

return oCn:QueryResult( cSql )[ 2 ]

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion