RE: [amibroker] How to detect if 'foreign' is successful or not ?

["Herman vandenBergen" <psytek@xxxxxxxx>]

<FONT face=Arial color=#0000ff 
size=2>Salil, I'd love an answer to this as i am struggling to detect 
the existence of Composites. 
<FONT face=Arial color=#0000ff 
size=2> 
<FONT face=Arial color=#0000ff 
size=2>I thought of using <SPAN 
class=170040606-30042003><FONT face=Arial color=#0000ff 
size=2>IsEmpty(Foreign(...)) but I couldn't get it to work well, another 
way may be to use Cum(Foreign(...))==0 to indicate there is no data... but there 
must be a better way.
<FONT face=Arial color=#0000ff 
size=2> 
<FONT face=Arial color=#0000ff 
size=2>herman

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Salil V Gangal 
  [mailto:salil_gangal@xxxxxxxxx]Sent: April 30, 2003 12:00 
  PMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker] How 
  to detect if 'foreign' is successful or not ?
  
  Friends,
   
  If a 'foreign' function is executed, then how to detect 
  programatically if it is successful or not ?
   
  I thought IsNull will be useful, but it was not.  I executed the 
  following code (and there is MSFT in the database I'm using) and it shows 
  'IsNull is true' for both.  I tried the code without 'Ref' as well ... 
  Same result.
   
  
  
    security=<FONT 
    face=courier>foreign<FONT 
    color=#000000>("MSFT"<FONT 
    color=#000000>,"C"<FONT 
    color=#000000>);<FONT 
    color=#000000>
    if ( 
    <FONT 
    color=#0000ff>IsNull(<FONT 
    color=#0000ff>Ref(<FONT 
    color=#000000>security,<FONT 
    color=#ff00ff>0<FONT face=courier 
    size=3>)) ) {
        message = 
    "IsNull is 
    true";
    }
    else 
    {
        message = 
    "IsNull is 
    false"<FONT 
    color=#000000>;<FONT face=courier color=#000000 
    size=3>
    }
    message;<FONT 
  face=courier color=#000000 size=3>
   
  
    security=<FONT 
    face=courier>foreign<FONT 
    color=#000000>("DoesNotExist"<FONT 
    color=#000000>,"C"<FONT 
    color=#000000>);
    if ( 
    <FONT 
    color=#0000ff>IsNull(<FONT 
    color=#0000ff>Ref(security,<FONT 
    color=#ff00ff>0<FONT face=courier 
    size=3>)) ) {
        message = 
    "IsNull is 
    true";
    }
    else 
    {
        message = 
    "IsNull is 
    false";
    }
    message<FONT 
    size=3>;
     
  Regards,
  - Salil V 
  Gangal
  
  
  Do you Yahoo!?<A 
  href="">The New 
  Yahoo! Search - Faster. Easier. Bingo. Send 
  BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
  suggest@xxxxxxxxxxxxx-----------------------------------------Post 
  AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A 
  href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
  group FAQ at: <A 
  href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
  Your use of Yahoo! Groups is subject to the <A 
  href="">Yahoo! Terms of Service. 







Yahoo! Groups Sponsor












Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.