UF error parsing single quotation marks

Geoff Booth

• 24 de mayo de 2021 19:46

I'm trying to automate an Item Master Data Manager form calling it from a BP Master record.

Everything works except for pasting the actual Condition (SQL). I am trying to paste:

WHERE OITM.CardCode = 'V10511'

However no matter what quote grouping I use around the V10511 I either get no quotes or nothing after the =. I have tried two single quotes, three single quotes and any combination of 1,2 or 3 I can think of.

SAP 10 FP 2011 SQL Server

Vote

0

• 

  Paul Mills

  • 26 de mayo de 2021 07:35

  Hi Geoff - are you trying to pull the CardCode dynamically from somewhere? or hard coding in the actual value V10511?
• 

  Geoff Booth

  • 26 de mayo de 2021 13:52

  I hard coded the value for testing.

  I'm trying to paste the value from the Business Partner Master record as per below (@STORE3)

  I know Rasmus doesn't like SendKeys but at least it's working for now

  ClearAllStoreValues();
  @STORE1 = $[$5.0.0]; -- Store the Vendor CardCode
  @STORE2 = $[$BOYX_6.0.NUMBER]; -- Store the New vendor lead time
  @STORE3 = 'WHERE OITM.CardCode = ';  -- Build the where clause
  --@STORE3 = 'WHERE OITM.CardCode = ''' + $[OCRD.CardCode] + '''; -- Build the where clause
  StatusBar(@STORE3|S);
  Activate(BOY_81_ITMMDM);
  Activate();
  Set($[$BOY_6.0.0]|@STORE3); -- Set the "Where"  clause
  Click($[$BOY_18_6.0.0]); -- Activate Planning Tab 
  Set($[$BOY_62.0.NUMBER]|@STORE2); -- Set new lead time
  Click($[$BOY_93.0.0]); -- Set the checkbox to 'Y'
  Click($[$BOY_6.0.0]);
  SendKeys({END});
  SendKeys(    ); -- Can't send a space either - this fails
  SendKeys(');
  SendKeys(@STORE1);
  SendKeys(');
  Click(BOY_5); -- Find 
  AutoPressNextPopup(BOY_14); -- Auto-Click Yes on Popup after the Execute
  Click(BOY_14); -- Execute

   

Iniciar sesión para dejar un comentario.