El lunes, 3 de octubre de 2022 a las 14:29:26 UTC-5, Claudio H escribió:
Hi all
I have no problem connecting to the DB (Ariel), using MSSQL with {ODBC Driver 17 for SQL Server}
The workstation running the xHb app (David) has windows 10 OS, the server where MS-SQL is installed is a windows server machine.
I'm inserting a value in a numeric column [importe numeric (15,2)] for example 2000 (no decimals, no decimal separator included)
When retrieving the data via SQLRDD:
cSQLCommand:="SELECT SessionID, Importe FROM MOBINVSE"
aAlivios:=ARRAY(0)
nSQLRet:=oSQL:Exec(cSQLComm,,.T.,@aAlivios,,,,,,,.F.)
If windows' numeric local setting for decimal separator is "." (point) aAlivios[1][2] value is 2000 but if decimal separator is "," (comma) the returned value in the array element is 200000
I can change this setting back and forth as many times as I wish and the result changes according to this setting.
I'm guessing it has to do with an internal SQLRDD setting but couldn't find any helping reference in the docs.
Any idea?
Regards
Claudio H
Try
cSQLCommand:="SELECT SessionID, Importe FROM MOBINVSE"
aAlivios :={}
oSql := SR_GetConnection()
*** nSQLRet:=oSQL:Exec(cSQLCommand,,.T.,@aAlivios,,,,,,,.F.) nSQLRet:=oSql:exec(cSQLCommand,,.t.,@aAlivios) <- here
****************
*Read here
****************
Method Exec()
Executes a SQL statement, optionally retrieving the result set
› Syntax
Exec( <cCommand>, [<lMsg>], [<lFetch>], [<aArray>], [<cFile>, [<cAlias>]], [<nMaxRecords>], [<lNoRecno>], [<cRecnoName>], [<cDeletedName>], [<lTranslate>] ) ==> NIL
› Arguments
<cCommand> SQL command to execute
<lMsg> If .T. (default) generates a run time error if there is an error in SQL
<lFetch> If .F. (default), the result set is not recovered. If .T., the result set is retrieved as the parameters
<aArray> Array that will receive the result set if he informed reference, and if lFetch be with .T.
<cFile> DBF file name that will be used to store the result set in the case lFetch is .T.. This option has priority over the parameter <aArray>, ie, if informed of the name of the file is not written in the result set array of the previous one. <cFile>
will be created with the structure of the result set of the SQL statement and will be opened exclusively after the implementation of the Method.
<cAlias> Alias of DBF file to be created in the option above.
<nMaxRecords> Maximum number of rows of result set to recover
<lNoRecno> If .F. (default) includes the Recno() column in the result set. If .T., does not add
<cRecnoName> Recno() Column Name
<cDeletedName> Deleted() Column Name
<lTranslate> If .T. (default) returns the information contained in Multi Language in the current language
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)