AnsweredAssumed Answered

SQL Script

Question asked by RGoyette on May 26, 2010
Latest reply on May 26, 2010 by bvoth

Title

SQL Script

Post

Hello all.  I am using FMPRO 11 for Windows, talking to an Oracle database via ODBC.

 

I have a script that builds a SQL call:

 

"SELECT * FROM prpsl."&Events::Short Beamline Name&"_prpsl_V where RUN_CYCLE_ID='"&Beamline Info::Run Cycle&"' and PRPSL_ID not in (select PRPSL_ID from <FileMaker Pro Table Name>  where RUN_CYCLE_ID='"&Beamline Info::Run Cycle&"')"

 

The <FileMaker Pro Table Name> is tha part causing me trouble.  I have a FM table named Events, which has a field PRPSL_ID.   I am trying to say:  Select PRPSL_ID from the Oracle database if PRPSL_ID does not appear in the Events::PRPSL_ID.  The problem is how do I specify the table name Events?  I have tried

 

(select PRPSL_ID from Events...           but that throws an error.

 

Any suggestions?

Outcomes