Thanks - that worked perfectly. On Dec 6, 12:48 pm, Jason Meckley <[email protected]> wrote: > 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 <[email protected]> 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
