explicitly cast the the value to the appropriate data type. for
example
row["key]" = Convert.ToInt(row["key"]);
this could be preformed as part of the InputComand (override
CreateRow(IDataReader))
class GetDataFromFoxPro : ConventionInputCommandOperation
{
protected override Row CreateFromReader(IDataReader reader)
{
var row = base.CreateFromReader(reader);
row["key"] = Convert.ToInt32(row["key"]);
return row;
}
}
or as it's own operation
ClassConvertToInt : AbstractOperation
{
public IEnumerable<Row> Process(IEnumerable<Row> rows)
{
foreach(var row in rows)
{
row["key"] = Convert.ToInt32(row["key"]);
yield return row;
}
}
}
On Dec 6, 11:09 am, dinger <carlzuro...@gmail.com> wrote:
> Hello,
> I am creating an etl job using rhino etl to transfer data between a
> mysql db and foxpro db. I am having trouble with a left join - it is
> not returning any rows for the right side of the join. I believe this
> is due to a datatype issue. Is there any way that I can change the
> datatype when it is joining so that they can actually complete the
> join? It is a numeric in foxpro and either an int or float in mysql
> (I tried both data types but neither one works.
>
> Thanks
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To post to this group, send email to rhino-tools-...@googlegroups.com.
To unsubscribe from this group, send email to
rhino-tools-dev+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en.
