Windev Forum - WinDev Solutions

Any windev 28 dongle for sale

Jojo K — Tue, 16 Jun 2026 12:15:38 +0200

Any one have windev 28 dongle for sale , possible trade also

Re: Printing/sending invoices with correct line sequence

Mike James — Sat, 02 May 2026 00:23:41 +0200

Thanks for your comments Al, much appreciated. Totally agree with all of it, especially your first sentence!

Re: Printing/sending invoices with correct line sequence

Al — Thu, 30 Apr 2026 02:32:27 +0200

Hello Mike,

Over the years I have found Windev functions that work perfectly and those that don't as I am sure you have.
One function that randomly causes issues for me is the For Each construct, especially if you do some process inside the loop so now I never use it.

For an invoice, I load all the line records into a memory table with an incrementing numeric counter field, then sort the table on the counter field and use it to supply the body section of the invoice report.

Regards
Al

Re: Printing/sending invoices with correct line sequence

Mike James — Thu, 30 Apr 2026 02:19:29 +0200

Option 3 worked in development but not in production. Error: unknown. A small change fixed it:

"ON LineNumber" (a field name from the table/data source) replaced by "ON sFieldName" (a string containing the fieldname).

It's not the first time we've had to make a similar change.

Printing/sending invoices with correct line sequence

Mike James — Thu, 19 Mar 2026 23:52:08 +0100

I generate invoice as PDFs or files of various types, eg XML, CSV. I had trouble retaining the original line sequence as per the source transaction.

Typically I scan a data source of invoice headers, and within the scan I filter another data source for all the invoice lines for that invoice, then scan those lines to generate the output:

FOR EACH
- Using HFilter, filter the invoice lines data source for that invoice (ordered by invoice and linenumber)
- FOR EACH
- - Print the invoice report or create the output file

I tried 3 different ways to filter the invoice lines data:

1. FOR...EACH - did not return the correct set of data, even though a display of the data source in the debugger showed the correct set of lines.

2. WHILE HOut() - correct invoice set but the lines were in random order

3. FOR EACH where "saleid = '" + .saleid + "'" ON LineNumber

#3 worked correctly. The "where clause" created the correct subset of data, and "ON linenumber" retained the correct line sequence.

See [doc.windev.com].

This may be well known but not to me. Shared for anyone who can benefit!

Re: C# example using WD 16 .NET assembly

DJ — Thu, 16 May 2024 15:07:32 +0200

I would like for source code of your C# project and a bit help on my project for connecting HFSQL DB with asp .net web api

Re: How to make a treeview with parents

crowntb — Thu, 08 Feb 2024 10:12:30 +0100

can you please explain it more clear did not understood.. :(

Re: Available Windev Dongles for Sale (V21 and V26)

Harnek — Thu, 23 Nov 2023 18:13:47 +0100

Hi,

I could use one. Lost mine moving to a new country :-(. Fortunately it was for personal learning in early stages and I'm using something else at work.

Do you have an email I can contact you on? Or you can contact me at harnek.remove_this_and_the_dots.sandhu at gmail.com

Cheers,

HS

Re: How to Run a MS SQL Store Procedure and get the Value from it to a Variable

blainephoebe — Tue, 22 Aug 2023 12:29:41 +0200

Hey there!
If you have any queries about the store procedures of ms sql then you can check in to the official website of ms sql.

Available Windev Dongles for Sale (V21 and V26)

mitchlove — Wed, 09 Aug 2023 07:56:16 +0200

Dear Windev Coders,

I am selling my Windev dongle version 21 and version 26.
Name your price.

for interested you can message me directly..

Ciao!

Re: How to Run a MS SQL Store Procedure and get the Value from it to a Variable

renko — Thu, 23 Mar 2023 10:46:56 +0100

Ok here goes,

You make a new connection and execute it see below:

datasourcemyprocedure is Data Source

if hopenconnection( your connectionvar) then
Hcanseldeclaration(dsMyProcedure)

IF HExecuteSQLQuery(dsMyProcedure,"MyConnection", hQueryWithoutCorrection, "dbo.sp_yourstored procedure @o_RKey out") THEN

//.o_RKey out is the variable you are gettting out of you sp
the key = dsMyProcedure.o_RKey out

hclose(dsMyprocedure)
Hcloseconnection(your connectionvar
else

end

Re: lost password *.fic file HFSQL

amiolodev — Wed, 22 Mar 2023 18:48:08 +0100

thank you for reply

Re: lost password *.fic file HFSQL

gpredl — Wed, 22 Mar 2023 17:40:58 +0100

Sorry, there's no way to get at your lost password. Good luck!

lost password *.fic file HFSQL

amiolodev — Wed, 22 Mar 2023 15:42:03 +0100

Hello everyone and Thank you in advance for the Help
i forget my password for *.FIC files HFSQL server and i also lost the analyse file for programming a new password for those FIC files, is there a way to retrieve the data ? how i can resolve this problem ? X(

Re: How to Run a MS SQL Store Procedure and get the Value from it to a Variable

Allard — Mon, 20 Mar 2023 22:56:06 +0100

Hi we use that all the time. It is not realy complicated. I will see If I can get you some code . I can not copy past as the software is commercial stuff. ok

It is quite easy so no worries . I will get back at you as i will have to look at the source and make a bit of code for you ( none tracable to hou software . Ok

regards

Renko

PS PCSoft help should be able to help you out as well

api webservice REST cals

Allard — Mon, 20 Mar 2023 22:50:48 +0100

Hi I have been looking at webservices in windev and I was wondereing if they do support : "Asynchronous" webserice calls ?

Any body any Idea . I can not foind it on the help

regards

Renko Allard

Re: HFSQL Export Tool for PostgreSQL, MySQL and MariaDB

yoann — Wed, 23 Nov 2022 16:46:03 +0100

Hi,

This tool can help my to migrate the data of my HFSL server to a new database in mysql ?

Thanks a lot for sharing your work

Re: Printing labels on a Zebra LP 2844 using Zebra EPL

paulapphillips — Wed, 10 Aug 2022 09:02:16 +0200

The thermal transfer label market is made of sales connected with thermal airport transfer label products by entities

The Thermal Paper market is made of sales regarding thermal transfer label equipment by entities (organizations, lone traders, and partnerships) which produce long-lasting in addition to durable photos on lots of materials. Thermal transfer labels refer to a ribbon that may be printed through a thermal copy printer where, at that point on the print mind, a layer of ribbon is placed on top of the content label.

The main varieties of printers in thermal transfer labels are desktop computer, industrial, plus mobile. Desktop thermal transfer printers are correct for long-term marking applications that should be used to get more than six months or uncovered to severe conditions for example chemicals, lighting, high temperature, or h2o. The several materials incorporate paper, polyester, polypropylene (pp), polyethylene (pe), along with other materials and are also used inside food as well as beverages, healthcare, tracking, logistics, plus transportation, conventional goods in addition to products, semiconductors & technology, retail music labels, and additional end-users.

The Shipping Labels market research report is one of a a line new reports in the Business Investigation Company to deliver thermal airport transfer label industry statistics, like thermal transfer label market global market size, regional shares, competitors having a thermal transfer label marketplace share, in depth thermal transfer label market segments, current market trends in addition to opportunities, and any additional data you would like to thrive in the thermal exchange label sector. This energy transfer label researching the market report delivers a whole perspective of creams, with a good in-depth analysis belonging to the current in addition to future scenario on the industry.

The global thermal transfer labels market size is supposed to grow coming from $2. 41 million in 2021 to $2. 65 thousand in 2022 with a compound total growth quote (CAGR) of 10. 3%. The global thermal transfer label market size is supposed to grow in order to $3. 45 billion in 2026 with a CAGR regarding 6. 7%.

Rapid growth while in the e-commerce sector is significantly causing the growth in the thermal airport transfer label marketplace. E-commerce comes from the exchanging of products creating an online business. It comprises of internet-based activities like product purchasing and marketing, as good as economic transactions. With the rise regarding online searching, there is often a greater demand for loads of labels in addition to packaging. As an example, according on the India Company Equity Base (IBEF), a great India-based federal agency, the e-commerce market is supposed to increase through $46. 2 billion within 2020 to $111. 40 billion in 2025 in fact it i expected to arrive $350 million by 2030. Thus, rapid growth while in the e-commerce market is travelling the growth on the thermal copy labels marketplace.

Strategic partnerships would be the key trend gaining popularity inside Thermal Labels market. Major businesses operating while in the thermal shift label industry are undergoing partnerships to help reinforce their particular position. As an example, in January 2022, Brother Mobile Answers, a US-based issuer of energy transfer labeling, partnered having TEKLYNX, your US-based issuer of barcode name software alternatives. Through the following partnership, Brother delivers numerous industrial in addition to commercial thermal barcode name printers which are compatible along with TEKLYNX software solutions. Furthermore, in September 2021, Recognise Andy, your US-based innovator of narrow- in addition to mid-web printer and a finish equipment, combined with UPM Raflatac, your Finland-based energy transfer name provider. By way of this venture, both businesses would provide best-in-class handheld label printing methods to flexographic and also digital converters.

In January 2019, TSC Automotive ID Technologies Co.,your Taiwan-based corporation operating within AIDC barcode name printing, acquired Diversified Labelling Answers Inc.,pertaining to an undisclosed total. With this specific acquisition, TSC expands its name portfolio while in the U. VERTS. market which consists of own printer manufacturing along with label changing facilities. Diversified Labelling Options, Inc. is usually a US-based corporation that products thermal shift labels.

Major players while in the Direct Thermal Labels market tend to be 3M Company, Constantia Flexibles Number, CCL Market sectors Inc, Coveris Holdings VERTS. A, Henkel AG & Co, Honeywell Worldwide Inc, Away from the coast Label in addition to Marketing Products LLC, LINTEC Firm, Multi-Color Firm, WS Packaging Group, TSC Automotive ID Technologies Co. Ltd.,Ricoh Holdings, Zebra Firm, SATO Number, and Avery Dennison Company

North The united states was number one region in the thermal airport transfer label market in 2021. Asia pacific is supposed to be that fastest-growing region inside global energy transfer content label market in the forecast period. The locations covered while in the global energy transfer content label market report are Asia-Pacific, Traditional western Europe, Northern Europe, North america, South North america, Middle Far east and Africa.

The locations covered while in the thermal shift label industry report tend to be Australia, South america, China, France, Germany, India, Indonesia, Japan, Russia, Southwest Korea, BRITISH ISLES, USA.

The particular global energy transfer name market is actually segmented -

1) By way of Material: Paper, Polyester, Polypropylene (PP), Polyethylene (PE), Others

2) By way of Printer Sort: Desktop, Conventional, Mobile

3) By way of End-User: Nutrition and Beverages, Healthcare, Pursuing, Logistics, plus Transportation, Conventional Goods in addition to Products, Semiconductor plus Electronics, Full price Labels, Others.

WinDev LPR (DOS) Function

erich45 — Tue, 30 Mar 2021 16:39:47 +0200

Hello

My solution will not work:
For a exotic Labelprinter I have to send Binary data direct to the printer.
I do this creating a File with the data.
Then I create a DOS Batch file as follow:
Cmd is string = "c:\windows\system32\LPR.exe -S " + Computername + " -P " + Printername + " " + Filename + " -ol"
an write it to my disk: fSaveText("C:\Temp\Batch.bat", Cmd)

This Batch can I start manualy without any problems, it works.
But unfortunately I am not able to start the batch by WinDev
I tryed 'exerun', 'DDEstart' (DDEStart("C:\Temp\Batch.bat"))
whatever i try, it does'nt work

Anybody can help me ?

Thanks in advance
Erich

How to Run a MS SQL Store Procedure and get the Value from it to a Variable

MPD_For_Life — Tue, 09 Feb 2021 02:32:41 +0100

Hello everyone and Thank you in advance for the Help

I have this stored procedure inside a Microsoft Sequel Database which gets me the Date and Time of the Server.

Name of the Procedure: Get_The_Date_And_Time

Structure of the Procedute

CREATE PROCEDURE dbo.Get_The_Date_And_Time
AS
BEGIN
/* Procedure body */
DECLARE @Date_And_Time as date SELECT Date_And_Time = GETDATE();
END

The result of the Procedure if executed is the following:
Under the Column Name "Get_The_Date_And_Time" The result is the Following

2/8/2021 8:10:19 PM <-------- This is the Date and Time of the Server when the stored procedure is Executed

My question is: How can I run this store procedure from within WinDev or WebDev and put the result in a Variable, for Example varServerDate.

I have tried different things HExecuteProcedure() This does not work with ODBC Connection
I Have tried with HExecuteSQLQuery Get errors
I have tried SQLExec got errors too

Nothing works

I would really appreciate it you can give me a hand on this and perhaps a code Example can be provided since I have no clue where to start.

Thank you so Much

Best regards,
Carlos

Re: NOTE: This forum is for WinDev SOLUTIONS only, please, post your questions to the WinDev Forum!

norfolk-reg — Thu, 14 Jan 2021 15:13:21 +0100

Sorry, posted in wrong forum, please ignore

HFSQL Export Tool for PostgreSQL, MySQL and MariaDB

apredl — Mon, 03 Feb 2020 13:31:06 +0100

HFSQLExport

HFSQL analysis and data exports a SQL script for MySQL, MariaDB and PostgreSQL.

Direct export for PostgreSQL is not ready, but can be done (needs time)

If anyone wants to extend this little tool, sources are available at request.

Replacement for IsNumeric()

Sebastian Arnold — Tue, 09 Aug 2016 13:30:44 +0200

A few weeks ago I discovered that

IsNumeric("02NST2")

returns True. Well, I don't agree with this result.

So I needed a workaround. And this is what I ended up with:

MatchRegularExpression("02NST2","[0-9]+") -> False

HTH
Sebastian

Re: Importing Data from Excel (XLS) file to HF

edmundo — Wed, 02 Oct 2013 21:51:12 +0200

gracias por tu aporte me dio mucha ayuda

Re: Instructions for how to set up HFSQL C/S on 4 Linux distributions

ICI — Thu, 28 Feb 2013 14:13:26 +0100

First,
Thank you for this great tutorial. You need few changes with screen order but it is ok if we slowly reading and trying.

Problem is with installation of HF Server. I am try with your tutorial on UBUNTU and SUSE. Same situation. You can see picture .
[/img]

Regards !

Re: How to make a treeview with parents

Carlo Hermus — Thu, 31 Jan 2013 16:28:01 +0100

Alexander,

You are welcome. I am happy I can help as I am helped by others.

Re: How to make a treeview with parents

Alexander S. — Sun, 27 Jan 2013 21:00:49 +0100

thank you for your post very much!!! I spent a lot of time to search a solution.

Re: Printing labels on a Zebra LP 2844 using Zebra EPL

Marcelo Brazil — Sat, 12 May 2012 18:16:55 +0200

Thanks, thanks, many thanks.

Re: Getting the current decimal separator from Windows

Tor-Bjarne — Mon, 19 Mar 2012 22:31:35 +0100

Or you could read the registry:

Info(RegistryQueryValue("HKEY_CURRENT_USER\Control Panel\International\","sMonDecimalSep"])

the ] = ) otherwise example show a :)

Cheers
Tor-Bjarne

Re: MSSQL4WDEng

Fri, 03 Feb 2012 14:08:54 +0100

Link is broken.