Recent content by JBDev

totkopf - how is the Covast/Biztalk project going? Any lessons you'd like to share? I'm seriously considering this product for replacing Gentran. -JB

RE: JFLandry 5/26/03 - I found this post very helpful and got this working. RE: Leprikon 6/6/03 - verify the name of your output field in the name portion of element properties; and be sure to convert your real or int Order Number to string via the ntoa function. Hope this helps.

I have created custom P4210's for the various R47011 updates we use for EDI. Create new P4210's (with custom processing options) through Interactive Versions (fast path: IV) then specify it by name in the processing options of R47011. What you need to do sounds similar.

Could you elaborate? JDE support is telling me Workflow isn't going to solve this.

Where could I find information on e-mailing JDE reports that are created in a scheduled batch job? Is this the SendMessage function or is this setup in the Workflow Management.

We have Gentran Windows NT 4.0 and JDE OW XE. I've used the JDE extensions with good results. I initially created the maps using the JDE flatfile extract, but plan to replace some of the outbound maps with GENTRAN ODBC maps to improve EDI processing automation (ie fix/filter the data before it...

You should be able to do this by creating an outbound ODBC map in Gentran.

Wow - thanks to everyone for the helpful suggestions. I'm a bit rusty with SQL but getting back up to speed quickly. I'll try these solutions and see how it goes. - JB

Hi, Thanks for the input - this would work if the number of levels was always 3, but this can vary. I can only specify the top level record (ie #3) - the query has to find all records that cascade below this for any number of levels. I should have added one more level to my example to better...

I’m trying to create a self join in a table that selects specific records as it cascades through a record chain. Each employee record contains a field “ReportsTo” which contains the employee id of the manager each employee reports to. All levels of management are contained in this file...

I found the answer to this problem. The first step was to get a better book on ADO.NET. Once I positioned the CurrencyManager to the correct row the rest was simple: ie: Dim fld2 as string = DsGetData1.myTable(0).Field2

help The user interface prompts for 2 values. The first value is used as the parameter to lookup a particular record in the dataset. Once the correct record is found, I need to compare the second user value entered to another field in the dataset. Here is an example: Dim strFld1 As...