Database API placeholder question

[Jan Schenkel]

--- K <nnoydb at excite.com> wrote:
> 
> I have a strange behavior I cannot explain.  When I
> create a SQL statement like below.
> 
> 
> SELECT ca,cb,cc from :1 where fa=:2
> 
> In this case :1 and :2 is sent to the database with
> single quotes ('') around it  am I configuring
> something wrong? Is there a option to stop this? 
> 
> K
> 

Hi Kevin,

You aren't doing anything wrong, and it shouldn't be
causing problems ; there is no option to stop it, but
you can always use the merge() function to build your
queries ; example :
--
  put "Foo" into tTable
  put 123456 into tRecID
  put merge("SELECT ca,cb,cc FROM [[tTable]] WHERE
fa=[[tRecID]]") into tSQLQuery
--

Hope this helped,

Jan Schenkel.

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)


	
		
__________________________________
Do you Yahoo!?
Yahoo! Domains – Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer