Mysql y tipo de dato decimal

[nageswaragunupudi]

You can definitely read decimal data type also from mysql tables with ADO.

[nageswaragunupudi]

Simple test:

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.

[nageswaragunupudi]

First, please clarify whether it worked with customer table on the Cloud server?

Depending on your answer, we can help you with your table on your own server.