De acuerdo con la documentación, si la entiendo bien si yo quisiera abrir una conexión a una base Mysql, MSSql u Oracle, bastaría con escribir: oCn2 := FW_OpenADOConnection( "MSSQL,192.168.120.206,Sarubbi,sa,Came0303", .t. ) xBrowse( oCn2 ) //para ver el objeto conexión ...
De acuerdo con la documentación, si la entiendo bien si yo quisiera abrir una conexión a una base Mysql, MSSql u Oracle, bastaría con escribir: oCn2 := FW_OpenADOConnection( "MSSQL,192.168.120.206,Sarubbi,sa,Came0303", .t. ) xBrowse( oCn2 ) //para ver el objeto conexión ...
... not have access to your tables are its contents. I am providing a sample implementing a similar solution with 'customer' table on the FWH provided MSSQL cloud server. We can all use this server to post examples and problems. Sample program: #include "fivewin.ch"function Main() ...
[quote="don lowenstein"]I have a Harbour / Fivewin application that uses MSSQL tables via Mediator (3rd party RDD from OTS software). Don, where can I found a trial version or pricing of Mediator?
You are going to have come up with a timer that does some sort of oLbx:ReFresh() and or oRs:Requery() at some selected interval .. Hopefully someone will chime in here with a timer code example ..
Hi, With standard DBF open in SHARED mode, when a table is open and displayed with XBROWSE on 2 computer in the network, if 1 user update a record , the change is visible on the xbrowse on the other computer . (There is an automatic refresh) How is it possible with RecordSet ? I think i have to chan...
Trabajo con mssql pero debe ser similar en MARIADB cSQL := "CREATE TABLE pcaj" cSQL += "(" cSQL += "lote varchar(6) NOT NULL, " cSQL += "ineto NUMERIC(12,3)," cSql += "idmat ...
Ciao a tutti Non riesco a sapere il modo per leggere il nome dell'oggetto creato con la clausola constraint associato ad una certa colonna in MSSQL sia utilizzanto un comando SQl o una qualche proprietà legata alla colonna es.: cNameContraist := oRs:fields( cNameField ):constraint() mi serve ...
Ciao Enrico grazie in realtà ero io che commettevo un errore nel costruire il comando SQL poichè non inserivo uno spazio fra STRTRAN( DTOC( DATE() ) , "/", "-") e TIME() ovvero : cSql := "UPDATE " + alltrim( cNomeTabella ) + "SET DataReg = '&qu...