Search found 15 matches: orecset

Return to advanced search

Fw maria-/mysql

Buena tarde, el método oRecSet:setOrder, permite usar má de columna ...?
La idea es no gastar mas consultas a base de datos para traerla ordenado , tratando de simular al v Dbsetorder de los dbf. Gracias...
by russimicro
Sun Jun 25, 2023 10:20 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Fw maria-/mysql
Replies: 4
Views: 313

Re: New FTDN May 2018 (FWH 18.05)

... columns during runtime. At lease one of the parameters need to be provided. 1) uSource: Can be cAlias, oTDataDbf, oRecordSet, oQry, oRowSet, oRecSet If nil, present source continues to be used 2) aCols: Array of column names, expresssions. * BTNBMP - Method ShowPopUp() encounters runtime ...
by Antonio Linares
Sun Jul 22, 2018 5:01 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN May 2018 (FWH 18.05)
Replies: 1
Views: 2731

New FTDN May 2018 (FWH 18.05)

... columns during runtime. At lease one of the parameters need to be provided. 1) uSource: Can be cAlias, oTDataDbf, oRecordSet, oQry, oRowSet, oRecSet If nil, present source continues to be used 2) aCols: Array of column names, expresssions. * BTNBMP - Method ShowPopUp() encounters runtime ...
by Antonio Linares
Sat Jul 14, 2018 4:14 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN May 2018 (FWH 18.05)
Replies: 1
Views: 2731

Re: Binary file to field via SQL

If you use latest FW libraries with ADO,
it is as simple as
oRecSet:Photo := MemoRead( "john.jpg" )
or
oRecSet:Reply := MemoRead( "reply.rtf" )
by nageswaragunupudi
Thu Oct 09, 2014 7:06 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Binary file to field via SQL - SOLVED!
Replies: 7
Views: 1771

Re: TDataRow and ADO questions

... default Edit() method bOnSave : Optional cpdeblock. Executes at the end of Save() method lValidData : ReadOnly Logical. METHODS: New( [cAlias|oRecSet|oDbf|oBrw( Default Alias() )], [cFieldList (Def AllFields)], [lBlank (Def .f. )] ) Edit( [lReadOnly] ) : Default Edit dialog provided. Undo() ...
by nageswaragunupudi
Thu Jun 06, 2013 11:00 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDataRow and ADO questions
Replies: 48
Views: 11405

New FTDN May/Mayo 2013 (FWH 13.05)

... <lNew> ) Writes data into fields from the data array in TDatabase class * New: New Class TDataRow ( datarow.prg ) Reads data from Alias, oRecset, oDbf Can be used for edit/append/save * Enhancement: XBrowse: DATA lAutoSort toggles autosort feature. * New Data: XBrowse: oBrw:lReadOnly ...
by Antonio Linares
Wed Jun 05, 2013 3:09 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN May/Mayo 2013 (FWH 13.05)
Replies: 0
Views: 2822

Re: Refreshing xbrowse when dataset is closed and re-opened

Armando wrote:James:

Yes, I'm using ADO, xHarbour, MySql & FWH810. And not problem at all with
oRsHdr:Refresh()

Regards

Yes. I tested and oRecSet:Refresh() does NOT error out.
But refresh method is not documented for ADO.
by nageswaragunupudi
Thu Jul 15, 2010 1:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Refreshing xbrowse when dataset is closed and re-opened
Replies: 67
Views: 16486

ADO

... to a MYOB ( accounting software) but I would like to add a record to the table. #include "fivewin.ch" function main() local cStr,oCon,oRecSet,oRs,cn,nCnt := 0 cStr := "Driver={MYOAU0901}; TYPE=MYOB; UID=Administrator; PWD=;DATABASE=C:\Premier125\Clearwtr.myo; HOST_EXE_PATH=C:\Premier125\MYOBP.exe;NETWORK_PROTOCOL=NONET; ...
by Colin Haig
Tue Feb 09, 2010 9:15 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO
Replies: 9
Views: 1257

Re: Report Grouping Pblm using RecordSet Object

Sajith >GROUP ON oRecSet:Fields("EmpName"):value Are you saying that the above line is not working? Is the recordset sorted by empName? >i want to do grouping on Empname and Department I am still not clear. Do you have ...
by James Bott
Tue Aug 18, 2009 11:34 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Report Grouping Pblm using RecordSet Object
Replies: 14
Views: 3333

Anser,

Do it this way:

MENUITEM oRecSet:Fields("Menu_Text"):Value BLOCK &cMenuAction

Please review FWH\samples\TestMnu.prg
by Antonio Linares
Mon Dec 01, 2008 12:51 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Help : Create dynamic menu from Database
Replies: 2
Views: 622

Anser:

Intenta con oRecSet:AbsolutePosition()

Code: Select all  Expand view
oCol:bStrdata:={ || TRANSFORM(oRecSet:AbsolutePosition(),"@Z 99999") }


:AbsolutePosition() es el equivalente a la función RecNo() en DBF's

Saludos
by Armando
Wed Nov 19, 2008 2:41 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: mostrar una columna con el número progresivo en un xBrowse
Replies: 3
Views: 826

Anser:

Try with oRecSet:AbsolutePosition()

Code: Select all  Expand view
oCol:bStrdata:={ || TRANSFORM(oRecSet:AbsolutePosition(),"@Z 99999") }


:AbsolutePosition() it's like RecNo() in DBF's

Regards
by Armando
Wed Nov 19, 2008 2:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Column with progressive number with xBrowse
Replies: 8
Views: 1849

... de ejecución. 5) Mejoras a SetODbf(): (a) Nuevo cuarto parámetro lAutoCols, por defecto es .F., el objeto tiene las datas cAlias y nArea o oRs o oRecSet, lAutoCols puede ser usado opcionalmente para añadir todas las columnas al "browse". (b) Si el objeto ha definido los métodos 'KeyNo', 'KeyGoTo', ...
by Antonio Linares
Fri Aug 29, 2008 7:22 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN August / Agosto 2008 (8.08)
Replies: 1
Views: 4713

New FTDN August / Agosto 2008 (8.08)

... runtime error. 5) Improvements to SetODbf(): (a) New 4th parameter lAutoCols, defaults to .f. f the object has data cAlias and nArea or oRs or oRecSet, lAutoCols can be used optionally to add all column data automatically to the browse. (b) If the data object has defined methods 'KeyNo', 'KeyGoTo', ...
by Antonio Linares
Wed Aug 20, 2008 6:23 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN August / Agosto 2008 (8.08)
Replies: 1
Views: 4713

Aqui es el codigo perdon

... Driver};SERVER=localhost;PORT=3306;DATABASE=comandas;UID=root;PWD=root;OPTION=1;" ) CATCH oErr ? oErr:Description RETURN NIL END TRY // oInspect( oRecSet) //Inspector( oRdd , "oRdd") DEFINE FONT oFontBrw Name "Ms Sans Serif" SIZE 0,-11 //DEFINE DIALOG oDlg RESOURCE "DLGMANDB" FONT oFontBrw DEFINE ...
by fsandoval
Tue Mar 07, 2006 9:36 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ADo oRs:MoveLast() Errror
Replies: 3
Views: 1188

Return to advanced search