CHMlib Logo Leading Translation Management System for Translation Agencies, Top Translation Management Software for Freelance Translators, Time Tracking Software, Word Count, Character Count and Line Count Software, Computer Assisted Translation Tool for Easy Word Count, Clipboard Character Count Software, User-Friendly Translation Memory Software, Terminology Management Software, Terminology Management Server, Microsoft Glossary Software, Dictionary of Acronyms, Social Network for Translators and Translation Agencies, Acronyms and Abbreviations Search Engine, Russian Translation Lab, Ukrainian Translation Lab.
You are reading help file online using chmlib.com
CrisisHelper - First Aid in Tough Times of World Economic Crisis

_bm0 Rave Reports Developer Guide

SQL parameter

 Top  Previous  Next

QUESTION:

How do I pass a parameter to a SQL query?

 

ANSWER:

To pass a parameter to a SQL statement you need to do the following::

 

1.Set the parameter you want to pass in your Delphi code.

 

RvProject1.SetParam('ParamName','YourValue');

 

2.Set the QueryParam property of the Query Designer with something like:

 

SQLParam1=Param.ParamName
 
please note NO SPACES around equal sign

 

3.now build your SQL statement like the following:

 

if it is a numeric compare
Select * from table where Field=:SQLParam1
 
if it is a string compare
Select * from table where Field=':SQLParam1'

 

       please note NO SPACES around equal sign
You are reading help file online using chmlib.com
If you want your help file to be removed or added please send e-mail to chmlibcom@gmail.com