Alaska Software Inc. - ODBC, dsXBrowse of ds-Datasoft and Advantage Database Server. I put this in news generic but I think is better here.
Username: Password:
AuthorTopic: ODBC, dsXBrowse of ds-Datasoft and Advantage Database Server. I put this in news generic but I think is better here.
César Calvo ODBC, dsXBrowse of ds-Datasoft and Advantage Database Server. I put this in news generic but I think is better here.
on Sun, 24 Jul 2016 05:35:33 +0200
Hi friends.
I don´t know why with a data type numeric or money, if I make a Browse when 
the cell is edited, the program exit.
I mean if I only do cSQL := "SELECT MAN,SOC,CUE  FROM MAYOR ORDER BY CUE;" 
and edit a cell, the browse change the value of the cell an is refreshed but 
with the source code below always EXIT.
Also I have keep in mind oSession:setProperty( ODBCSSN_DATATYPES  ).
Could somebody help me?
Thanks.
César.

cCon := "DBE=ODBCDBE;DRIVER={Advantage StreamlineSQL ODBC};"
cCon += "DataDirectory=" + cRut + cDic + ";" + "SERVER=" + cSrv + ";" +
"UID=" + cUsu  + ";" + "PWD=" + cPas + ";"
cCon +=
"Compresion=;DefaultType=Advantage;Rows=False;Language=ANSI;AdvantageLocking=OFF;Locking=Record;MemoBlockSize=524288;MaxTableCloseCache=100;ServerTypes=6;"
cCon +=
"TrimTrailingSpaces=False;EncrytionType=RC4;FIPS=False;RightsChecking=OFF;"

IF ! oSes:isConnected()
   Infobox("No Conectado")
   RETURN
   ELSE

   oSes:setProperty(ODBCSSN_INDEX_AUTOOPEN, .T.)

    cSQL := "SELECT MAN,SOC,CUE,MNL,MND FROM MAYOR ORDER BY CUE;"

    oSrv := OpenOdbcServer(cSQL,oSes)

    oSrv:DAC_Activate(.F.,.T.)

    ::oBro:Connect(oSrv)
    ::oBro:AddColumnDB()
    ::oBro:QuickEdit(.T.)
ENDIF

MNL is a Data Type Money and MND Numeric, rest of filed are Type character
César Calvo Re: ODBC, dsXBrowse of ds-Datasoft and Advantage Database Server. I put this in news generic but I think is better here.
on Mon, 25 Jul 2016 17:44:24 +0200
Hello, it works fine.
The problem was in the definition of datatype inside of the database of ADS.
When is money o numeric, if it is curdoble or double any problem.
I exported two table to Microsoft Access and Microsoft Sql Server and in the
second there was problems for to import the structure.
Regards.
César.

"César Calvo"  escribió en el mensaje de 
noticias:786902cd$79af4496$2104f@news.alaska-software.com...

Hi friends.
I don´t know why with a data type numeric or money, if I make a Browse when
the cell is edited, the program exit.
I mean if I only do cSQL := "SELECT MAN,SOC,CUE  FROM MAYOR ORDER BY CUE;"
and edit a cell, the browse change the value of the cell an is refreshed but
with the source code below always EXIT.
Also I have keep in mind oSession:setProperty( ODBCSSN_DATATYPES  ).
Could somebody help me?
Thanks.
César.

cCon := "DBE=ODBCDBE;DRIVER={Advantage StreamlineSQL ODBC};"
cCon += "DataDirectory=" + cRut + cDic + ";" + "SERVER=" + cSrv + ";" +
"UID=" + cUsu  + ";" + "PWD=" + cPas + ";"
cCon +=
"Compresion=;DefaultType=Advantage;Rows=False;Language=ANSI;AdvantageLocking=OFF;Locking=Record;MemoBlockSize=524288;MaxTableCloseCache=100;ServerTypes=6;"
cCon +=
"TrimTrailingSpaces=False;EncrytionType=RC4;FIPS=False;RightsChecking=OFF;"

IF ! oSes:isConnected()
   Infobox("No Conectado")
   RETURN
   ELSE

   oSes:setProperty(ODBCSSN_INDEX_AUTOOPEN, .T.)

    cSQL := "SELECT MAN,SOC,CUE,MNL,MND FROM MAYOR ORDER BY CUE;"

    oSrv := OpenOdbcServer(cSQL,oSes)

    oSrv:DAC_Activate(.F.,.T.)

    ::oBro:Connect(oSrv)
    ::oBro:AddColumnDB()
    ::oBro:QuickEdit(.T.)
ENDIF

MNL is a Data Type Money and MND Numeric, rest of filed are Type character