|
| Getting data from one dataset to another |
 |
Thu, 13 Mar 2008 08:59:10 -070 |
Hi,
I am new to XAL.
I have a requirement that means I need to view data from one data file when
in another i.e. View equivalent stock location setup in one data file that is
linked through to another by an external itemnumber field setup in the stock
table.
Thanks for help in advance.
Regards
|
| Post Reply
|
| RE: Getting data from one dataset to another |
 |
Tue, 18 Mar 2008 01:34:03 -070 |
Hi, Craig,
there is a special process in XAL, which can be used to temporarily change
the data file. Please check the existing XAL code (e.g. XAL LedgerReport) or
ask either a colleague or the XAL hotline, how this task can be solved.
Kind regards
Hannsjörg Zdarsky
Software Design Engineer
Microsoft Deutschland GmbH
"Craig" wrote:
> Hi,
>
> I am new to XAL.
>
> I have a requirement that means I need to view data from one data file when
> in another i.e. View equivalent stock location setup in one data file that
is
> linked through to another by an external itemnumber field setup in the
stock
> table.
>
> Thanks for help in advance.
>
> Regards
>
>
|
| Post Reply
|
| Re: Getting data from one dataset to another |
 |
Wed, 19 Mar 2008 08:55:42 -070 |
On Mar 18, 8:34 am, Hannsjörg Zdarsky (Microsoft)
<HannsjrgZdarskyMicros...@discussions.microsoft.com> wrote:
> Hi, Craig,
>
> there is a special process in XAL, which can be used to temporarily change
> the data file. Please check the existing XAL code (e.g. XAL LedgerReport)
or
> ask either a colleague or the XAL hotline, how this task can be solved.
>
> Kind regards
> Hannsjörg Zdarsky
> Software Design Engineer
> Microsoft Deutschland GmbH
>
> "Craig" wrote:
> > Hi,
>
> > I am new to XAL.
>
> > I have a requirement that means I need to view data from one data file
when
> > in another i.e. View equivalent stock location setup in one data file
that is
> > linked through to another by an external itemnumber field setup in the
stock
> > table.
>
> > Thanks for help in advance.
>
> > Regards
Here is an example.
Say you have a dataset called "Yada" and want to run the
"ProcessYadaYadaYada" script using this dataset.
You would code something like:
set &utilname = "ProcessYadaYadaYada"
set &dbext = "Yada"
PROCESS #PROC_DBChange 'Mode=Temp File='+&DBExt+'
Proc='+Num2Str(#PROC_XalRun, 0,0,0,0)+'
\"Args=Xal='+&UtilName+'\"'
|
| Post Reply
|
|
|
|
|
|
|
|
|
|