FiveTech Software tech support forums

Please use oCn:Execute( <yourquery> ) to get multi-dim array not oCn:QueryResult() whose purpose is dfferent.

I use this function regular in some apps. It would be great if it can be possible that we add a 2 dim. array that would/could change the headers in the excel file in order to match these of the dbf. The dbf fields are defined, but the exels that I get are always differend ...

... esta para abrir un puerto de impresora Public Function AbrirPuerto(ByVal wPuerto As UShort, ByVal dwBaudios As UInteger) As UInteger [Ejemplo] Dim iRet As UInteger iRet = DFiscal.AbrirPuerto(1, 9600) Me pueden indicar como lo haria y si existen tipo de datos como estos en FWH Saludos Desde ...

... Second parameter is an array of fieldnames or list of fieldnames. Third parameter is an array of values. Fourth parameter can be 1) an multi-dim array of fieldnames and values. 2) Literal where condition. In the above example, the fourth parameter can also be: "`numercli` = '" + ...

First convert any multi-dim array into string cString := FW_ValToExp( aArray )  and save to INI file or to any text file or to a memo field. After you read back from the INI file or other file as cText, convert into array ...

byron.hopp wrote:Dim sheet As Worksheet
Set sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count))

Try

Code: Select all  Expand view

oSheet := oExcel:ActiveWorkbook:Sheets:Add( oExcel:ActiveWorkbook:Worksheets( oExcel:ActiveWorkbook:Worksheets:Count() ) )

All, I am puzzeled on how to use some of the methods in Excel, because the parameter passing is unusual. Dim sheet As Worksheet Set sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count)) Is there a way to make this work in Harbour ...

With this code, not working because multi dim. arrays are not easy for me, I want to find all values of the selected record Result shoud be the values of the folowing fields... aData[1,1] = Code .or. aData[1] = code aData[1,2] = Naam ..... rest ...

... function of fingerprint verification and specifies a comparison decision based on the requested FAR set by the FARRequested property. Syntax Dim oVerificationResult As DPFPVerificationResult Set oVerificationResult = object.Verify( ByVal oVerificationFeatureSet As Object, ByVal oFingerprintTemplate ...

Hi Uwe ,

Need 3 different arrays to process invoice data into our database.

Looking for a function which returns an array (single dim) for each record during .CSV line read then I can copy /add record into relevant main array

Thanks
shridhar

... } }   :GoTo( nDstRec )   :Paste( aVals )END  aVals can be a list of values of all fields Or a 2-dim array with fieldnames and values.

... sql statement, b) Numeric: In case of insert, update, etc indicating the affected rows c) If the result is a result-set, it is returned as Multi-Dim array Saludos

... blank record and returns success This usage is consistent with all previous versions. Usage 2: Append( aFldsAndValues ) aFldsAndValues is a multi-dim array in the form of { { fld1, val1 }, ... { fldN, valN } }. fldN can be field name of field number. Append( flds, aVals ) flds can be nil ( all ...

... Syntaxes: Update( cFieldList, aVals ) --> lSuccess Update( aVals ) // aVals written to fields 1,2, .etc Update( aFldVal ) // aFldVal can be 2 dim array of fields and vals Fields can be by number or names. - Append() method now returns lSuccess and as usual appends blank - Append( aFlds, aVals ...

... Syntaxes: Update( cFieldList, aVals ) --> lSuccess Update( aVals ) // aVals written to fields 1,2, .etc Update( aFldVal ) // aFldVal can be 2 dim array of fields and vals Fields can be by number or names. - Append() method now returns lSuccess and as usual appends blank - Append( aFlds, aVals ...