Author | Topic: 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 |