FiveTech Software tech support forums

Using InsertTable( nRows, nCols )method of Trichedit
How insert data info on each cells?

For a sample I have an array aschema is 3 rows with 10 columns
How create a table on Rtf with this array ?

... oBrw:bRClicked := { |r,c,f,oBrw| aResult := XbrToArray( oBrw, [ aCols ] ) } ) errorline = aData := Array( nRows, Len( aCols ) ) Error description: Error BASE/1111 Argument error: LEN Args: [ 1] = B {|| ... } Stack Calls =========== Called from: => LEN( ...

bProgress recibe dos parámetros:

Eval( bProgress, 0, nRows )

el primero es siempre cero y el segundo parece ser nRows := oRange:Rows:Count

puedes revisarlo en source/function/dbffunc2.prg

... aData, [aHead], [cTrue], [cFalse] ) --> cHTMLScript (valtostr.prg) * Nuevas funciones ADO ( adofuncs.prg ) - FW_ADORsToText( oRs, [nRows] ) --> Testo delimitado por tabulaciones - FW_AdoRsToHTML( oRs, [nRows] ) --> Testo cHTML mostrar la tabla - FW_AdoRsToCSV( oRs, [nRows] ...

... FW_ArrayToHTML( aData, [aHead], [cTrue], [cFalse] ) --> cHTMLScript (valtostr.prg) * New ADO functions( adofuncs.prg ) - FW_ADORsToText( oRs, [nRows] ) --> Tab delimited text - FW_AdoRsToHTML( oRs, [nRows] ) --> cHTML text to display the table - FW_AdoRsToCSV( oRs, [nRows] ) --> CSV ...

... * Nueva clase FW_Matrix (para cálculos matriciales) CLASS FW_Matrix: DATAs de sólo lectura y métodos de acceso: DATA aMatrix READONLY DATA nRows, nCols READONLY ACCESS lSquare INLINE ( ::nRows == ::nCols ) ACCESS Determinant INLINE If( ::nRows == ::nCols, m_determinant( ::aMatrix ), 0 ) ...

... * New CLASS FW_Matrix (for matrix calculations) CLASS FW_Matrix: READ ONLY DATAS AND ACCESS METHODS: DATA aMatrix READONLY DATA nRows, nCols READONLY ACCESS lSquare INLINE ( ::nRows == ::nCols ) ACCESS Determinant INLINE If( ::nRows == ::nCols, m_determinant( ::aMatrix ), 0 ) ...

CLASS FW_Matrix: READ ONLY DATAS AND ACCESS METHODS: DATA aMatrix READONLY DATA nRows, nCols READONLY ACCESS lSquare INLINE ( ::nRows == ::nCols ) ACCESS Determinant INLINE If( ::nRows == ::nCols, m_determinant( ::aMatrix ), 0 ) ACCESS IsIdentity CONSTRUCTOR METHODS: ...

... first dimension of acHeader is considered as head and second dimension is considered as data. - ArrToJson( acHeader, aData ) - RsToJson( oAdoRs, [nRows], [nStart], [aFields] ) --> Json Array - FW_RecToJson( [acFields], [acNames] ) // for dbf record - FW_DbfToJson( [cFieldList], [bFor], [bWhile], ...

... tema parece estar por el lado del tercer parámetro, que a este momento sigo sin entender, es el mismo parámetro que recibe la función oRs:GetRows( nRows, nStart ), pero sigo sin comprender para qué sirve. :shock: oVar:="SELECT * FROM clientes"oRsFtr := FW_OPENRECORDSET(oCnFtr,oVar,adLockOptimistic,adOpenKeyset)hDatos ...

... la publicación que mencionas, hay varias funciones alli, pero creo que la que mas se adapta a lo que necesito es la función RsToHash( oAdoRs, [nRows], [nStart], [aFields] ) --> Matriz hash oVar:="SELECT * FROM clientes"oRsFtr := FW_OPENRECORDSET(oCnFtr,oVar,adLockOptimistic,adOpenKeyset)hDatos ...

... already made a query (we call it RowSet), then you can use method GetRows(), which is similar to FillArray() of Dolphin. aData := oRs:GetRows( [nRows], [nFromRow], [aFieldNames] ) Example: oRs := oCn:RowSet( "customer" )aDataFull := oRs:GetRows()aDataPart := oRs:GetRows( ...

... already made a query (we call it RowSet), then you can use method GetRows(), which is similar to FillArray() of Dolphin. aData := oRs:GetRows( [nRows], [nFromRow], [aFieldNames] ) Example: oRs := oCn:RowSet( "customer" )aDataFull := oRs:GetRows()aDataPart := oRs:GetRows( ...

... (por defecto .F.) Si es .T., entonces devuelve "datetime" como "YYYY-MM-DDTHH:MM:SS" * adofuncs: - Función RsGetRows( oRs, [nRows], [nStart], [aFields] ) -> aRows Mejorada con tres parámetros opcionales nRows: Número de filas. Por defecto toadas las filas. nStart: 0 : ...

... [lISO8601] ) Optional 2nd parameter lISO8601 (default .f.) If .t., returns datetime as YYYY-MM-DDTHH:MM:SS * adofuncs: - function RsGetRows( oRs, [nRows], [nStart], [aFields] ) -> aRows Enhanced with 3 additional optional paramters nRows: Number of rows. Default all rows rest. nStart: 0 : Default ...