Replies posted by Craig_IFS8_to_Cloud

1 Reply

C
Do Gooder
Craig_IFS8_to_CloudDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Which SQL Table for Any Form?

Shan, your title of “Hero” does you justice :)  Thank you! I’ll elaborate a little as I’ve just checked a number of other Forms which I’d been asked about to check the method and there is a standard pattern which you’ve correctly shown. Whatever the Entity is: “CustomerInfo” or “InventoryPartInStock” or “IdentityInvoiceInfo”...separate the words with underscores and run the equivalent search: SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'CUSTOMER_INFO'orSELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'INVENTORY_PART_IN_STOCK'orSELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'IDENTITY_INVOICE_INFO' and extract the TEXT from the result. Brilliant. 

2
C
Do Gooder
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings