FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the SqlServer Adapter Adapter, which may answer your question: CSV text file import , flat file export , Import IDENTITY (Auto Increment) fields , CSV export divided into several files

Pass Parameters from Access to FH

  • JD Cox
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 4 weeks ago #3673 by JD Cox
Pass Parameters from Access to FH was created by JD Cox
I have an access app for users to generate invoicing.  I want the end user to select a customer and an invoice date then click a button that runs FH, executing a stored procedure.  How do I pass those parameters from access to FH?  I know I can execute the stored procedure with a pass-through query in access but I would like to use FH to generate multiple reports, log the transaction and update records.

Thanks, JD

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #3674 by FlowHeater-Team
Replied by FlowHeater-Team on topic Pass Parameters from Access to FH
Hi JD,

you can to this with the help of FlowHeater Parameter .

For example, you can call the Batch Module with the /SetParameter option like this
     FHBatch.exe /SetParameter invoice=1234 /SetParameter date="11/09/2022" AccessExport.fhd

In the FlowHeater Definition you can use this parameter in your SQL Statement to hand over the given values

e.g.
     exec sp_fhtest @invoice = ‘$invoice$’, @dt = ’$date$’

 

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

  • JD Cox
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 3 weeks ago #3675 by JD Cox
Replied by JD Cox on topic Pass Parameters from Access to FH
Robert, as always thank you.

That helped me sort out the parameters from batch to the definition.  But I still cannot pass them from MS Access to the batch file.

File_Path = "C:\WINDOWS\explorer.exe  \\~\INVOICE_DATA.bat"

If I SET the parameters in the batch file and execute it from Access the definition run great.

Shell File_Path, vbNormalFocus

File_Path = "C:\WINDOWS\explorer.exe  \\~\INVOICE_DATA.bat 143"

But as soon as I try to SET the parameters in Access shell only opens windows explorer, nothing else happens.

Looks like it’s possible, guess I’m missing something.

JD

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #3676 by FlowHeater-Team
Replied by FlowHeater-Team on topic Pass Parameters from Access to FH
Hi JD,

Why you are calling explorer.exe?

You can call FHBatch.exe or a script (.cmd | .bat) directly with the MS Access shell command.

e.g.
    Shell """C:\Program Files (x86)\FlowHeater V4\BIN\FHBatch.exe"" /SetParameter p1=test1 /SetParameter p2=test2 ""C:\Temp\test.fhd"""

Please find attached a short example.

 

File Attachment:

File Name: access-shell-cmd.zip
File Size:57 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

  • JD Cox
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 3 weeks ago - 2 months 3 weeks ago #3677 by JD Cox
Replied by JD Cox on topic Pass Parameters from Access to FH
Wow…did not know that.  Works great, super fast too.     FH_PATH = """C:\~\FHBatch.exe"""
    FH_LOG = " /LogFile \\10.0.0.0\~\INVOICE_LOG_.log"
    FH_PARAM1 = 143
    FH_PARAM2 = "10/25/2022"
    FH_PARAMS = " /SetParameter FH_BCID=" & FH_PARAM1 & " /SetParameter FH_INV_DATE=" & FH_PARAM2
    FH_DEF = " \\~\INVOICE_DATA.fhd"    Shell FH_PATH & FH_PARAMS & FH_LOG & FH_DEF

It does produce a warning for the parameters in the log file.  Is that to be expected?
It still works and the user has no idea.\~\INVOICE_DATA.fhd,Warning,Warning : Parameter [FH_BCID] does not exist  the Parameter will be dynamically generated!
\~\INVOICE_DATA.fhd,Info,Set Parameter [FH_BCID]  Value [143]
\~\INVOICE_DATA.fhd,Warning,Warning : Parameter [FH_INV_DATE] does not exist  the Parameter will be dynamically generated!
\~\INVOICE_DATA.fhd,Info,Set Parameter [FH_INV_DATE]  Value [10/25/2022]Thanks, JD
Last edit: 2 months 3 weeks ago by FlowHeater-Team.

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago - 2 months 3 weeks ago #3678 by FlowHeater-Team
Replied by FlowHeater-Team on topic Pass Parameters from Access to FH
Hi JD,

You may ignore this warning ? In case you would like to suppress this warning you just have to create the used parameter names into the definition, see screenshot below, that’s all.

 

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: 2 months 3 weeks ago by FlowHeater-Team.

Please Log in or Create an account to join the conversation.

  • JD Cox
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 3 weeks ago #3679 by JD Cox
Replied by JD Cox on topic Pass Parameters from Access to FH
Simple enough

Thanks for your help Robert

JD

Please Log in or Create an account to join the conversation.

Time to create page: 0.347 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en