Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (248)
  • Dynamics NAV & BC (5,470)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (5,291)
  • ERP general (347)
  • Information management (58)
  • Off-topic (51)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

Inline Query | SQL like Queries in Business Central

By admin in Dynamics NAV & BC, Tips & tricks 19 November 2020

Inline Query is a library that can execute SQL like Queries in Business Central AL Language. This is a small compiler in AL that compiles and executes SQL like queries in text constants or text variables.

Source : msnJournals
Read more…

Share this:

  • Facebook
  • LinkedIn
  • WhatsApp
  • Twitter
  • Email
  • Print

Like this:

Like Loading...

Gerelateerde artikelen:

  1. Business Central Queries VS Views
  2. Putting Queries to Use in Business Central
  3. Business Central Execute Queries from Pages
  4. Using the power of queries to bring some smartness into Business Central
  5. How to: Join Data Items to Define the Query Dataset in Microsoft Dynamics 365 Business Central
Tags Business CentralInlineQuerySQL
Expose Business Central API as CDS Virtual Entity (without code)
Change Company dropdown Control Add-in for Business Central

Related Articles.

Dynamics 365 Business Central: How to hide page inspection details (Table Fields, Extensions, Page Filters and View table action)

02 Jun, 2023

Can You Truly Handle Bulk Communication With Word Templates In Business Central?

02 Jun, 2023

Business Central 2023 wave 1 (BC22): Edit in OneDrive

01 Jun, 2023

How to get 3 Business Central Cloud Sandboxes for $6 per month

31 May, 2023

Dynamics 365 Business Central: How to add Media or MediaSet data type (Pictures) to a report

30 May, 2023
Pardaan.com

Microsoft Dynamics NAV, Business Central, ERP general, Projectmanagement, Information management and Visual C#


Dennis Pardaan

Facebook page

Facebook page

Stay Hungry, Stay Foolish

RSS Mibuso

  • how to take backup of specific system table before the Deletion of records from a specific table?
  • Show each month on Account schedule and YTD
  • BC2022 hide specific page for a profil
  • BC 18 Edit in Excel Invalid server configuration
  • Allocation costs in BC
  • CurrPage.EDITABLE together with CurrPage.UPDATE
  • Design Mode in BC Cloud Sandboxes
  • Financials in BC
  • Copy newly created temp file
  • NAV webclient: Force auth by parameter
  • Auto Attached "Document Attachment" upon Send Email
  • Business Central Copy Link Option in Share Menu on Pages
  • [color=#FF0000][Inappropriate/Offensive text removed by Moderator.][/color]
  • How to import sales orders from excel in navision?
  • You do not have the following permissions on TableData Vendor Ledger Entry: Modify
  • Importing Items from Excel - Include Extended Text?
  • BC 21 import multiple xmlport with dynamic filesnames
  • Copy User field from posted purchase invoice line(123) to G/L Entry(17) table
  • Microsoft.Dynamics.Nav.Runtime.NavVariant variable not initialized
  • Can I take backup of user personalization?

RSS Dynamics NAV Team Blog

  • Dynamics 365 Field Service Mobile: New multi-image attachment feature and tips to get the most out of Inspections
  • Account structure activation performance enhancement 
  • Split recurring contract billing across multiple customers 
  • Status-Driven Success: Managing Your Work Order Lifecycle through Statuses – Part 1  
  • Status-Driven Success: Managing Your Work Order Lifecycle through Statuses – Part 2  
  • Status-Driven Success: Managing Your Work Order Lifecycle through Statuses – Part 3  
  • Printing Labels Using External Service with Dynamics 365 – Warehouse Management
  • How Copilot in Microsoft Dynamics 365 and Power Platform delivers enterprise-ready AI built for security and privacy
  • How real-time analytics improve supervisor experiences in Customer Service
  • Boost your sales business with smart organization charts

RSS Power BI

  • REMINDER: Announcing the retirement of data support for Streaming Dataflows
  • Power BI Embedded with Microsoft Fabric
  • Power BI Report Server May 2023 Feature Summary
  • Learn about Microsoft Fabric from MVPs
  • On-premises data gateway May 2023 release
  • Power BI May 2023 Feature Summary
  • Power BI Administrator role will be renamed to Fabric Administrator
  • New Tenant Setting Notifications and GetTenantSettings API
  • Microsoft Fabric Launch Event | May 24-25
  • Introducing Microsoft Fabric and Copilot in Microsoft Power BI
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
%d bloggers like this: