FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC: SQL Heater stopping returning 1 value

SQL Heater stopping returning 1 value 3 months 2 days ago #3516

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 333
Hello there,

I'm using flowheater to migrate a database using the SqlServer Adapter on the read side and MySQL Adapter on the write side.

I have to write a column from another table on the read side to the write side, so i'm using an SQL Heater to do this. I have tried with the code in the example on the site and a code that uses a join, but with both pieces of code it looks at the first value of that column and enters that for the entire column.

So instead of looking up the value for each row, he looks up 1 value and uses that to fill that field in every row. Is this a setting i need to adjust?

Jonas
Request received via Email

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.

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.

SQL Heater stopping returning 1 value 3 months 2 days ago #3517

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 333
Hi Jonas,

In the SQL Heater you have to define a where clause with one or more a dynamical FlowHeater Parameters . To set the Parameter you have to use the Set Parameter Heater like the screenshot below.


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.
Attachments:

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

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: by FlowHeater-Team.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en