FiveTech Software tech support forums

... variable a todas las consultas SQL. Lo ideal, seria que se haga automaticamente, pero a mi me gustaria hacer la asignación por ejemplo de ntab := oodbc:query(GetParam( n, 1 )). Habria alguna forma de saber, cuando ocurre un error, toda la linea del problema para asi descubrir la variable en cuestion? ...

... error in a txt file and bypass the dialog box . How to ? oODBCK := TOdbc():New("DBNAME", "user", "password") oDbfa:=oOdbc:Query("SELECT Numobj,dtedeb,numnat,numdesc FROM Objet WHERE Modif_Dte>=date()-1 ") Thanks Philippe

... cPass) REDEFINE BUTTON ID IDCANCEL OF oDlg ACTION oDlg:End() ACTIVATE DIALOG oDlg return nil STATIC FUNCTION OpenOdbc(cDsn, cName, cPass) Local oOdbc, oDlg local aFiles local cTable local lAsync oOdbc := TOdbc():New(cDsn, cName, cPass) If !oOdbc:lSuccess oOdbc:ShowErrorList("ODBC session ...

FUNCTION CREATEDABASE()
LOCAL oOdbc
LOCAL cLogin:= "sa"
LOCAL cPass:= "123456"


oODbc:=TODBC():New("master", cLogin, cPass , .F. )

oOdbc:End()
oOdbc:=NIL

RETURN NIL

thank you, it's very useful!

excuse me, I'm use: oOdbc := TOdbc():New( cDSN, cName, cPass ) and the example use DEFINE QUERY etc..., can you explain me what is the difference?

ok, and now another question. this is my code: oDbf := oOdbc:Query( "SELECT articolo as codice, descrarticolo as descrizione, unitamisura as um, " +; "prezzo as listino "+; "FROM magazzino "+; "WHERE codice = 'AAAA' ...

... la atencion y colaboracion. Este es el codigo. #include "FiveWin.ch" #include "sql.ch" MEMVAR oSysList PROC Main() LOCA oOdbc, oDbf, aData:= {} oOdbc := TOdbc():New( OdbcDsnEntries()[ 5 ], 'sa', 'B1Admin' ) IF oOdbc:lSuccess oDbf := TDbOdbc():new( "SELECT T0.[ItemCode][PRODUCTS_MODEL], ...

... WINRUN( 0 ) Called from: .\source\classes\WINDOW.PRG => TWINDOW:ACTIVATE( 980 ) Called from: saplnk.prg => MAIN( 74 ) this is the source oOdbc := TOdbc():New( cDSN, cName, cPass ) If !oOdbc:lSuccess oOdbc:ShowErrorList("ODBC session not successfully initialized, aborting...") ...

... server with few databases. Please some help: 1. How to read a list of DATABASES which exist on server (get list of databases) Something like: oOdbc:GetTables() for getting tables from database. 2. How get a list of ROUTINES (procedures) for each of databases 3. How to read content (text) of ...

... server with few databases. Please some help: 1. How to read a list of DATABASES which exist on server (get list of databases) Something like: oOdbc:GetTables() for getting tables from database. 2. How get a list of ROUTINES (procedures) for each of databases 3. How to read content (text) of ...

... to the end of the connection string and defined password from connection string is not valid anymore. For example connection string: oOdbc := TOdbc():New( "DRIVER={Informix-CLI 2.5 (32 Bit)}; DB=MyDataBase;HOST=MyHost;SERV=MyService;SRVR=MyServer;PRO=MyProtocol;UID=MyName;PWD=MyPass") ...

... ) WORKING GOOD Thanks for sugestions but that is not what I NEED I have bigger application based on using ODBC and work good. Sample i use: oOdbc := TOdbc():New( sDsn, cUserName, cPassword ) to logon to informix. I only DONT WANT 'LogOn' window from the driver to be shown becouse user unwanted ...

Hi, This code in 16 bit version work ok ! oOdbc := TOdbc():New( cDsn, cUserName, cPassword ) IF !oOdbc:lSuccess MsgInfo("UN succesful login !") oOdbc:End() RETURN .f. ELSE MsgInfo("succesful login !") RETURN .t. ENDIF In 32 ...

Lautaro, gracias por responder.

Puse el oOdbc:end() al cerrar la ventana principal y continua el error.

Saludos.

... ejecucion del programa no se detiene en el punto del activate window, alli activa la ventana y sigue adelante, por lo que ejecuta la instruccion oOdbc:end() y se cierra tu coneccion. Lo que debes hacer es mover esa instruccion a el evento de cierre de la ventana u a otro que tu estimes, pero ...