FiveTech Software tech support forums

METHODS: RecCount(), LastRec(), KeyCount(),RecNo(), KeyNo() GoTop(),GoBottom(),GoTo(nRec),KeyGoTo(nKey),Skip(n) FCount(),FieldPos(c),FieldName(),FieldLen(),FieldDec(),FieldType() FieldGet(),FieldPut() SetOrder(cSort,,lDescend) Save() Close() or End() --------------- NOT SUPPORTED: Seek(), Filter(),Delete(),Append() ...

This is how I change colums, sizes on the fly. I put some extra data in (index, fieldlen, ....) that is easy while running and programming at the same time. Most of my xbrowses are generated from a dbf-layout. https://maveco.be/fivewin/xbedit.jpg oBrwSel:bRClickHeaders ...

... be glad if you patiently help me to make xbrowse fully compatible with TMSQuery Do these methods also work as expected? fieldpos(), fieldname(), fieldlen(),fieldtype(),fielddec() ? MR Rao, in this way works Ok    @ 0,0 XBROWSE oBrw OF oWnd ;      LINES CELL AUTOSORT         WITH OBJECT oBrw  ...

... be glad if you patiently help me to make xbrowse fully compatible with TMSQuery Do these methods also work as expected? fieldpos(), fieldname(), fieldlen(),fieldtype(),fielddec() ?

... a oDbf:Load(). - Nuevo: Método Browse( [cTitle], [acFields] ) --> Self * adofuncs.prg, xbrowse.prg, datarow.prg: Mejorada la comprobación de fieldlen, fielddec en caso de los tipos adDouble y adSingle en ADO, dónde los atributos "Precision" y "NumericScale" no se especifican. ...

... calls Load() also. - New method Browse( [cTitle], [acFields] ) --> Self * adofuncs.prg, xbrowse.prg, datarow.prg: Improved ascertainment of fieldlen, fielddec in case of types adDouble and adSingle in ADO, where attributes Precision and NumericScale are left unspecified. * New function FW_ArrayAsRecordSet( ...

... field : DBCREATE(cDbfFile , {{"ID","+",10,0}} , "DBFCDX" , .T. ) DBG DbStruct() // gives ID , + , 4 , 0 ? FieldLen("ID") // 4 WHY TRUNCATED TO 4 ????????????????????????? FOR i := 1 TO 10001 DBAPPEND() NEXT ? Recno() , FIELD->ID // 10001 , 10001 ...

... field : DBCREATE(cDbfFile , {{"ID","+",10,0}} , "DBFCDX" , .T. ) DBG DbStruct() // gives ID , + , 4 , 0 ? FieldLen("ID") // 4 WHY TRUNCATED TO 4 ????????????????????????? FOR i := 1 TO 10001 DBAPPEND() NEXT ? Recno() , FIELD->ID // 10001 , 10001 ...

... FieldGet(<nField>)->ValueField FieldGetArr([<nRecNo>])-><aFieldValues> FieldLen(<nFieldPos>)->nFieldLength FieldName(<nPosition>)->cFieldName FieldNum(<cFieldName>)->nFieldPos FieldPos(<cFieldName>)->nFieldPos ...

... Eval ExeName Exp Expand Exponent Fact Fahrenheit FClose FCount FCreate FErase FError Field FieldBlock FieldDec FieldDeci FieldGet FieldGetArr FieldLen FieldName FieldNum FieldPos FieldPos FieldPut FieldPutArr FieldSize FieldType FieldWBlock File FileAttr FileCopy FileDate FileDelete FileMove ...

... Answer to your question: oRs:aStructure  In addition you have all methods like DBF functions oRs:Fieldname() oRs:FieldLen() oRs:FieldType() oRs:FieldDe() etc

Hello RAO , there is in MariaDb an equivalent of FWAdoFieldStruct , FWAdoFieldSize ? I found FieldLen (), fieldName ecc ... but I don't understand how to use . It would be interesting to have a full list (in one place) of the methods of MariaDB, now you have to look into ...

... of which DBF we are showing. From this information XBrowse examines the DBSTRUCT() of the alias and determines: a) Column size depending on FIELDLEN() b) Alignment depending on FIELDTYPE() c) Picture clause depending on FIELDTYE(), FIELDLEN() and FIELDDEC() and also depending on the Global ...

... in the latest version: DefinedSize, ActualSize, Precision, NumericScale, OriginalValue Proposed to implement: UnderlyingValue Now the methods FieldLen(), FieldType(), FieldDec() accept field number or field name. In addition, FieldName() also accepts fieldname as paramter. This might sound ...

... tabla debe tener un indice principal 3) DefinedSize logitud campo Precision longitud campo numerico NumericScale cantidad de decimales Uso oRcs:FieldLen(oRcs:FieldPos(cCampo)) oRcs:FieldDec(oRcs:FieldPos(cCampo)) La pregunta pueden hacer algo equivalente a ADO oRcs:Fields(cCampo):Precision oRcs:Fields(cCampo):NumericScale ...