Setting TQuery SQL Statement

CK CK 3788 
Created at
Updated at  
12,164 0 0

This source code sets the SQL String in Query1. As it fits on one line we just use SQL[0].

The SQL statement finds all the fields from the Article table where the user_id field is equal to a varaible Text value dbtUser.Text.

A better way would be to use Parameters in the Query.
      
      

Query1.SQL[0] := 'select * from article where user_id = ' + dbtUser.Text + '';
Query1.Active := True; 


 

Tags SQL TQuery Facebook X
Comments 0
Similar posts
  1. SQL to Select a random row from a database table
    541
  2. How to download/grap web pages or XML document at internet website in Delphi XE?
    880
  3. The Ultimate Data Engineering Roadmap
    1,082
  1. How To Get The Windows OS Version
    623
  2. How To Change The Desktop Wallpaper
    2,173
  3. How To Get The Windows Language
    1,158
  4. How To Make A Gradient Filled Form
    846
  5. How can I hide the caption bar on a form?
    1,404
  6. How To Send An E-mail By Code
    1,124
  7. How To Open Url In Default Webbrowser
    465
  8. How To Check If A Soundcard Is Installed
    1,571
  9. How To Change Screen Resolution
    2,090
  10. How To Force The Correct Decimal Separator
    1,786
  11. How To Register Own File Types
    1,198
  12. How To Get Volume Name
    416
  13. How To Get Windows And System Directory
    2,740
  14. Get The Drive Type
    506
  15. How can I modify aliases programmatically ?
    1,317
Recently updated
  1. Google OAuth Token Expiration: Causes and Solutions
    29
  2. Why 100% SEO Guarantees Better User Engagement and How to Achieve It in Your Service
    55
  3. Why SPF and DKIM Are Essential for Linux Email Servers?
    49
  4. How do I create animated background for Google Meet?
    22,880
  5. MaxMind GeoLite2 vs. DB-IP Lite vs. ip-api.com: Choosing the Right Free IP Geolocation Solution
    271
  6. Meet Valkey: Why Redis Changed Its License, Why Valkey is Better, and How to Use It as a Drop-in Replacement
    103
  7. How Rogue Web Scrapers Are Stealing My Content and Destroying My Server
    168
  8. Array of arguments passed to script in PHP
    97
  9. Invalid Auction Storms in Ad Tech
    106
  10. Building MRC-Compliant Instrumentation in Ad Tech: Implementation Steps and Key Challenges
    207
  11. The Two Clocks of Ad Server Architecture
    77
  12. Frequency Cap Architecture Overview
    526
  13. Collecting Proof-of-Play from 100,000 Screens
    152
  14. Vector Search in Relational Databases (RDBs): Trends & Usage Environments
    302
  15. What is RedisVL?
    114
  16. Designing a Skill Registry Architecture: Minimize Token Usage and Maximize AI Performance
    246
  17. TPU & GPU Cluster Management Tools
    257
  18. The Concept of Scaffolding in AI Agents
    244
  19. Beyond Static Pipelines: Architecting LLM Multi-Agent Systems for Autonomous Workflow Orchestration
    596
  20. AI-DLC vs. AI-SDLC: Model-Centric vs. System-Centric AI Development
    267
  21. Fine-Tuning Open-Weight LLMs: Training, Licensing, and Deploying Custom Models with Ollama
    353
  22. Inside the Next-Generation Streaming Architecture: Ultra-Low Latency, SGAI, and AI Codecs
    206
  23. Machine Learning: Training vs. Ranking
    229
  24. The Continuous Learning Machine: Designing a Loop That Actually Turns
    228
  25. The Next-Gen Low-Latency Standards: LL-HLS & MoQ
    202
  26. Designing a Data Curation System Around a Vector Database
    230
  27. Extracting Context from Live Video: The Architecture Got Simpler When We Stopped Building Features
    263
  28. The New Ad Stack Behind Live Sports Streaming: Inside SGAI, EABN, and the Standards Race to Fix Live Monetization
    671
  29. Designing MLOps Architectures to Handle Seasonal Data Drift in EV Fleet Models
    200
  30. From 15 to 40+ FPS: Accelerating PyTorch Object Detection on Automotive ECUs
    232