Re: Mysql y tipo de dato decimal
Posted: Tue Jul 14, 2020 4:40 pm
You can definitely read decimal data type also from mysql tables with ADO.
Code: Select all | Expand
#include "fivewin.ch"
function Main()
local oCn, oRs
? "Connecting to FWH cloud server"
oCn := FW_OpenAdoConnection( "MYSQL,208.91.198.197,fwhdemo,gnraofwh,Bharat@1950", .t. )
if oCn == nil
? "Connect fail"
return nil
endif
? "Connected." + CRLF + "Reading structure of customer table"
oRs := FW_OpenRecordSet( oCn, "SHOW COLUMNS FROM customer" )
XBROWSER oRs TITLE "customer table : columns"
oRs:Close()
? "Reading customer table"
oRs := FW_OpenRecordSet( oCn, "customer" )
WITH OBJECT oRs:Fields( "salary" )
? :Type, :Precision, :NumericScale // Result: 131 (adNumeric), 8, 2
END
XBROWSER oRs
oRs:Close()
oCn:Close()
return nil
Anyone having FWH (not very old version) can build this sample and run from any computer having internet connection.
