Search found 24 matches: artikel

Return to advanced search

Re: DBF to Excel Sheet, without Excel, using ADO ?

... )   aStruct := FWAdoStruct( objRS )fwlog var2char(aStruct) and got var2char(aStruct) = "{{ARTNR, C, 255, 0, 202, .T.}, {ARTIKEL, C, 255, 0, 202, .T.}, {VERPACKUNG, C, 255, 0, 202, .T.}, {EINHEIT, C, 255, 0, 202, .T.}, {APREIS, N, 17, 2, 5, .T.}, {BESTAND, N, 17, 2, 5, ...
by Jimmy
Wed Aug 09, 2023 2:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2585

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... i have "dump" (big) Array of PG-Structure ( have split it for better reading) var2char(::aStructPG) = "{ {artnr, C, 5, 0, 16820, 1, artikel, __lock_owner, NIL, NIL}, {artikel, C, 30, 0, 16820, 2, artikel, bpreis3, NIL, NIL}, {verpackung, C, 10, 0, 16820, 3, artikel, lagerein, NIL, ...
by Jimmy
Thu Aug 03, 2023 8:12 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 762

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... 1795 ) var2char(aTest) = "__record" TDATAROW:SAVEPQQ( 1804 ) ::aStructPG[ n, 10 ] = "PRI" ::aStructPG[ n, 7 ] = "artikel" cSeq = "artikel___record_seq" The issue according to you is when client and server encodings are different, hm ... how can encoding ...
by Jimmy
Thu Aug 03, 2023 6:06 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 762

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... is UTF8 it work when Table use WIN1252 wrong using UTF8 Table TDATAROW:SAVEPQQ( 1787 ) var2char(::aStructPG[1]) = "{artnr, C, 5, 0, 16820, 1, artikel, __lock_owner, NIL, NIL}" TDATAROW:SAVEPQQ( 1848 ) cSql = "UPDATE public.artikel SET vkgesamt = 'sss' WHERE __record = 0.00" ...
by Jimmy
Wed Aug 02, 2023 11:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 762

METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... aKey from ::aStructPG but ::aStructPG does NOT contain "my" PRIMARY KEY var2char(::aStructPG[1]) = "{artnr, C, 5, 0, 16820, 1, artikel, __lock_owner, NIL, NIL}" p.s. __lock_owner is "last" FIELD ... i guess while not found "id" so it did not work when ...
by Jimmy
Wed Aug 02, 2023 8:29 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 762

FiveDBU + PostgreSQL using ADO

... Table (Database) but i use a "Catalog" for all Table of a Client so how to access "Catalog mdidemo" and open Table "artikel" using FiveDBU :?: --- Picture show my HMG Version https://i.postimg.cc/VkT3vcQp/HBPGU.jpg after connect to Server-IP (?) ...
by Jimmy
Sat Jun 24, 2023 3:21 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FiveDBU + PostgreSQL using ADO
Replies: 0
Views: 145

Disk activity when using a record

... is not accessible, to much hits at this time ))))) When a dbf is on a record I have the (BAD) habit of doing calculations like : nAankoop = artikel->new_bruto - (artikel->new_bruto * artikel->korting)/100 nAankoop = nAankoop - (new_bruto * artikel->korting2)/100 replace artikel->new_aankoop ...
by Marc Venken
Fri Feb 03, 2023 3:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Disk activity when using a record
Replies: 1
Views: 226

Re: fwdbu request

Hello Antonio, I did following test. use ( "artikel" ) new artikel->( FW_CdxCreate( niL, .T. ) ) It seems Harbour can handle more Indexes than 15. for n = 1 to 15 Errorsys does also use only 15. Best regards, Otto use ( "artikel" ...
by Otto
Tue Mar 27, 2018 12:41 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: fwdbu request
Replies: 35
Views: 6544

Re: Tsbrowse to Xbrowse conversion of a function

Now you are preparing an array like this // Titel Field Size Edit Indexen Align 0-L,1-M,2-R,3-V You can change it to prepare the same array in this way: // Field, Title, Picture, Size Eg: AADD(aTmp,{ "artikel_nr", "Code", nil ,70 } After preparing aTmp array: @ r, c XBROWSER oBrw...
by nageswaragunupudi
Fri Nov 24, 2017 3:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Tsbrowse to Xbrowse conversion of a function
Replies: 5
Views: 1137

Tsbrowse to Xbrowse conversion of a function

... NTX format for indexes) REDEFINE BROWSE oLbxCol CELLED COLORS CLR_BLACK, CLR_WHITE ALIAS "kleuren" ID 3333 OF oDlg NewLbx(oLbxcol,"ARTIKEL") and this is the function, that I want to convert to Xbrowse. Can someone help me with this function? I think that the indexes are not ...
by Marc Venken
Thu Nov 23, 2017 11:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Tsbrowse to Xbrowse conversion of a function
Replies: 5
Views: 1137

Re: To Marc -> A xBrowse-image colorpicker

... all colors from a selected scope), so when pressing on a color, that colorcode is put into the cell of a Xbrowse that has his pointer to the right artikel. Thanks.
by Marc Venken
Fri Nov 10, 2017 12:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: A Colorpicker and RGB-tools
Replies: 53
Views: 7993

Final conversion 16 bit to FWH

... OFF BLINKER CLIPPER SYMBOL ON BLINKER EXECUTABLE CLIPPER F220 packdata packcode ##noextdic fi maveco FI functies,afdruk,ingeven,klanten,lever,artikel,statistiek,dagtaak,Users,prosp,Makefile,index,finddata,browsers fi tsmtp,tsocket,tphdial fi errsysw fi wbrowse,wbrwline,tget,scrllbar,TSbrowse ...
by Marc Venken
Thu Jul 06, 2017 1:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Final conversion 16 bit to FWH
Replies: 26
Views: 5078

Change field in get

Hello, How can I change a getfield in a dialog on the fly? I have a code like REDEFINE GET ovar VAR artikel->omschrijv   ID 202 OF oDlg I want to change artikel->omschrijv to artikel->omschrijv1 when I press a button. I have try ovar:oGet:bSETGET( artikel->omschrijv1) ...
by Marc Vanzegbroeck
Fri Mar 16, 2012 8:03 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Change field in get
Replies: 2
Views: 464

Barcode lib (Cayetano's BarLib)

Hello,

If FW 16bit I used a library 'barlib.lib' where I was able tu print barcodes with the command

@ 1,1 EAN13 artikel->barcode of oPrinter

Is there a simular library for FWH?

I saw there is a 'Cayetano's BarLib enhanced by Enrico', but I can't find the link to download
Thanks,

Marc
by Marc Vanzegbroeck
Thu Aug 05, 2010 1:34 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Barcode lib (Cayetano's BarLib)
Replies: 11
Views: 2413

Barcode lib (Cayetano's BarLib)

Hello,

If FW 16bit I used a library 'barlib.lib' where I was able tu print barcodes with the command

@ 1,1 EAN13 artikel->barcode of oPrinter

Is there a simular library for FWH?

I saw there is a (Cayetano's BarLib enhanced by Enrico', but I can't find the link to download
Thanks,

Marc
by Marc Vanzegbroeck
Thu Aug 05, 2010 12:03 pm
 
Forum: Utilities / Utilidades
Topic: Barcode lib (Cayetano's BarLib)
Replies: 1
Views: 947
Next

Return to advanced search