var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
How can I generate SQL statements with Parameters which will solve the following :
Select * From ITMS Where (FTHR=0) Order by ITEM_NM
Select * From ITMS Where (FTHR<>0) Order by ITEM_NM
This only solve the first one :
Select * From ITMS Where (FTHR=:M1) Order by ITEM_NM
// M1 =0
Either you'll use two different query components, with their specific clauses and the same parameter or you'll build the string for the TADOQuery.SQL property dynamically with the parameter value hardcoded in the clause.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors