FiveTech Software tech support forums

I'd like to know more about FiveODBC classes. Opening the file help file of FiveWin Classes i find the class TdbOdbc, TOdbc, ecc. but the manual suggest "Please consult FiveODBC Documentation". Where i can find it? I search online into "Fivetech Software Wiki" ...

... MYC_FLAGS = MYDEFINES = MYPRG_FLAGS = [Source\Classes\tdbfcomp.prg] MYC_FLAGS = MYDEFINES = MYPRG_FLAGS = [Source\Classes\tdbodbc.prg] MYC_FLAGS = MYDEFINES = MYPRG_FLAGS = [Source\Classes\tdbodbcd.prg] MYC_FLAGS = MYDEFINES = MYPRG_FLAGS = [Source\Classes\tddemlcl.prg] ...

... "Obj\tcompone.obj" "Obj\tctrsock.obj" "Obj\tdbase.obj" "Obj\tdbfcomp.obj" "Obj\tdbodbc.obj" "Obj\tdbodbcd.obj" "Obj\tddemlcl.obj" "Obj\tddemlsv.obj" "Obj\tdict.obj" "Obj\tdosprn.obj" ...

... 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], T0.[ItemName][PRODUCTS_NAME], T0.[SuppCatNum][REF], T3.[FirmName][MARCA], " + ; " ...

Simon, Tienes razon ( hace tiempo que no trabajo con odbc ), pero tambien recuerdo que el tdbodbc solo soporta skip hacia adelante no hacia atras y es ahi donde te da el error, cuando obtiene la linea, que es en el metodo fetch(), el que hace la llamada a sqlextendedfetch. ...

Ese no es el problema,

Funciona en un dialogo y/o un entorno sdi.

El metodo open es para la clase tdbodbcdirect, y yo estoy usando tdbodbc.

el metodo open si la memoria no me falla mete el resultado del query en una tabla dbf/cdx lo que la hace sumamente lenta con tablas grandes.

Saludos.

Estoy construyendo una aplicación y me sale un error cuando trato de usar un xbrowse (con un recordset creado con tdbodbc) en una ventana mdi, el error es SQLExtendFetch on Goto() method [#4626092] class: (y una serie de caracteres aleatorios). Si quito las clausulas mdi y creo ...

... ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;" * Enhancement: Class TDbOdbc and TDbOdbcDirect are made compatible with XBrowse. These objects can be browsed like any other object like TDataBase, etc. * New: Class TMeterEx, ...

... TCColumn TCheckBox TClipBoard TComboBox TComm TcomObject TComponent TControl TCover TCtrlSocket TCursor TDatabase TDatePick TDbfComp TDbm TDbms TDbOdbc TDDE TDDEMLClient TDDEServer TDict TDlgFind TDosPrn TEnhMetaFile TExStruct TFGet TField TFile TFileGTF TFLine TFolder TFTP TFTPSession TGet ...

Wzaf,

You can also use Class TDbODBC in 32 bits if you need it

Hi all, I'm porting my applications from FW to FWH . I use MySql , and in FW I used class TDbOdbc in this way : oDbf := TDbOdbc():new("SELECT * FROM mytab....... " , oOdbc) and then I scan ODbf structure to retrieve data . I use this method also in FWH and ...

Es preferible que uses ADO en vez de ODBC, que Microsoft ya desaconsejo su uso hace tiempo.

En estos foros tienes muchos ejemplos de como usar ADO

... mensagem , pq nao da erro algum. agradeço as ajudas. Parte do codigo abaixo: l_ope3:=TOdbc():New(l_odb,"","") //Itens l_tait=TDBOdbc():New("SELECT * FROM "+"SD1010 ORDER BY d1_doc+d1_emissao",l_ope3,3,"SEL_003") l_notnum="123456" l_notdde="20091101" ...

... is trying to create a DBF. This might fail if the user doesn't have the proper rights. If that isn't the problem, then I suggest compiling the TDBODBC.PRG and linking it into your program. This way you can put msgInfo()'s into the Open method until you find the exact line that is causing the ...

... 'tdbfcomp.prg'... Lines 118, Functions/Procedures 7 Generating C source output to 'tdbfcomp.c'... Done. C:\classes>c:\xharbour\bin\harbour tdbodbc.prg /n /ic:\fwh\include;c:\xharbour\include xHarbour Compiler build 1.1.0 (SimpLex) (Rev. 6195) Copyright 1999-2008, http://www.xharbour.org ...