Search found 352 matches

by ADutheil
Sat Dec 12, 2020 8:29 pm
Forum: FiveWin for Harbour/xHarbour
Topic: OT: Winter
Replies: 3
Views: 903

Re: OT: Winter

Meanwhile in Bahia, 7AM.
https://youtu.be/qcmiuaSLdgs
by ADutheil
Tue Nov 24, 2020 1:49 pm
Forum: FiveWin for Harbour/xHarbour
Topic: fieldWBlock
Replies: 13
Views: 1401

Re: fieldWBlock

As you want to print a barcode the function may be expecting a string of numbers not letters.
by ADutheil
Sat Nov 21, 2020 8:18 pm
Forum: FiveWin for Harbour/xHarbour
Topic: fieldWBlock
Replies: 13
Views: 1401

Re: fieldWBlock

My FWH version is old and I'm not aware of the AS BARCODE command so I can't help you further.
by ADutheil
Wed Nov 18, 2020 8:34 pm
Forum: FiveWin for Harbour/xHarbour
Topic: fieldWBlock
Replies: 13
Views: 1401

Re: fieldWBlock

This works perfectly for me. #include "fivewin.ch" REQUEST DBFCDX Function main()  local acampi :=   {"FIRST"   ,;                       "LAST"    ,;                       "STREET"  ,;                       "CITY"    ,;                       "ST...
by ADutheil
Wed Nov 18, 2020 8:27 pm
Forum: FiveWin for Harbour/xHarbour
Topic: fieldWBlock
Replies: 13
Views: 1401

Re: fieldWBlock

I took your initial example and rewrote a little: #include "fivewin.ch" REQUEST DBFCDX Function main()  local acampi :=   {"FIRST"   ,;                       "LAST"    ,;                       "STREET"  ,;                       "CITY"    ,;          ...
by ADutheil
Wed Nov 18, 2020 4:58 pm
Forum: FiveWin for Harbour/xHarbour
Topic: fieldWBlock
Replies: 13
Views: 1401

Re: fieldWBlock

FIELDWBLOCK("FName", 1) is the same as &( "{ |setVal| IF( setVal == NIL, 1->FName, 1->FName := setVal ) }" ) If you don't eval the block you'll not retrieve the content of the field. @ nRiga, nColonna PRINT TO oPrn TEXT eval( FIELDWBLOCK( aFields[ncampo], SELECT( "CUST&q...
by ADutheil
Tue Nov 17, 2020 2:10 pm
Forum: FiveWin for Harbour/xHarbour
Topic: fieldWBlock
Replies: 13
Views: 1401

Re: fieldWBlock

Try
eval(fieldWBlock(aCampi[nFor],nArea ))
by ADutheil
Sun Oct 11, 2020 11:56 am
Forum: FiveWin for Harbour/xHarbour
Topic: How to get http response text
Replies: 18
Views: 1135

Re: How to get http response text

Could the failure be connected to the popup that shows the cookies acceptance message when one loads the page for the 1st time?
by ADutheil
Fri Sep 25, 2020 4:11 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1369

Re: Question about FWH and Excel

oExcel := win_oleCreateObject( "Excel.Application" ) oWorkb := oExcel:WorkBooks:Add() oSheet := oWorkb:Sheets( number of the sheet you want to work with 1 2 3... ) oSheet:Name := "the name you want for your sheet"   PM me your mail I'll send you a code you can use to learn more ...
by ADutheil
Fri Sep 25, 2020 12:55 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1369

Re: Question about FWH and Excel

I don't have a recipe but there are a lot of similarities: VAB Cells(x, y).Interior.ColorIndex <-> FWH Cells(x, y):Interior:ColorIndex.
by ADutheil
Thu Sep 24, 2020 3:43 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1369

Re: Question about FWH and Excel

Anytime I need something new I search Excel VBA examples and adapt them to FWH. As for RGB colors I don't know. Check below.

https://www.automateexcel.com/excel-for ... lor-index/
by ADutheil
Thu Sep 24, 2020 10:43 am
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1369

Re: Question about FWH and Excel

Try this
oSheet:Range( oSheet:Cells( 1, 1 ), oSheet:Cells( 1, 7 ) ):Interior:ColorIndex := Violeta
by ADutheil
Thu Aug 06, 2020 4:20 pm
Forum: FiveWin for Harbour/xHarbour
Topic: conditional formatting excel
Replies: 9
Views: 1444

Re: conditional formatting excel

I'd try something like this: oRng := oSheet:Range( oSheet:Cells( 1, 1 ), oSheet:Cells( 1, 7 ) ) oCond1 := oRng:FormatConditions:Add(xlCellValue, xlGreater, "=80") oCond2 := oRng:FormatConditions:Add(xlCellValue, xlLess, "=50") WITH OBJECT oCond1     :Font:Bold := .T.     :Font:Co...
by ADutheil
Thu Aug 06, 2020 2:33 pm
Forum: FiveWin for Harbour/xHarbour
Topic: conditional formatting excel
Replies: 9
Views: 1444

Re: conditional formatting excel

Do you mean this kind of code?     oSheet:Cells( nL,  4 ):Interior:ColorIndex := if( hora->HSAI < "04:00", Verde, Vermelho )     oSheet:Cells( nL,  5 ):value := hora->H1PV     oSheet:Cells( nL,  6 ):value := hora->HUPV     oSheet:Cells( nL,  6 ):Interior:ColorIndex := if( hora->HUPV < &quo...
by ADutheil
Wed Jun 24, 2020 7:44 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Introducing FiveTech's fivedit
Replies: 537
Views: 86189

Re: Introducing FiveTech's fivedit

Solved with a full reinstall. Thanks.