RE: SV: SV: [development-axapta] Joining 2 tables gives no result

2006-01-27 Thread Bayliss, Barry
oogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Sent: Thursday, 26 January 2006 5:32 PM To: development-axapta@yahoogroups.com Subject: Re: SV: SV: [development-axapta] Joining 2 tables gives no result Hi John, I tried to add the following before the select/join statement but it d

Re: SV: SV: [development-axapta] Joining 2 tables gives no result

2006-01-26 Thread Thomas
Hi John, I tried to add the following before the select/join statement but it does not seem to work: vba.company("tkv"); Am I doing this wrong? Thomas --- In development-axapta@yahoogroups.com, Hans-Walter Bous <[EMAIL PROTECTED]> wrote: > > Hi, >   you don't have to change company. Just

RE: SV: SV: [development-axapta] Joining 2 tables gives no result

2006-01-25 Thread Hans-Walter Bous
Hi,   you don't have to change company. Just try it with   vba.company().   By this you force the join to the selected company.   John Askeryd Thomas <[EMAIL PROTECTED]> schrieb:   An idea is to split the join. Making it more like while select xxx from Journal { change company to where

SV: SV: [development-axapta] Joining 2 tables gives no result

2006-01-25 Thread Askeryd Thomas
An idea is to split the join. Making it more like while select xxx from Journal { change company to where vba is {     select vba where vba.yyy == Journal.xx;     print some stuff;   } } IT will slow down the method but it will do the job. Thomas. ___