How to get where cluase of the query with actual parameters(instead of bind variables) from cocoa client?
How to get where cluase of the query with actual parameters(instead of bind variables) from cocoa client?
- Subject: How to get where cluase of the query with actual parameters(instead of bind variables) from cocoa client?
- From: Vikrama Devadiga <email@hidden>
- Date: Wed, 28 Dec 2005 18:28:50 +0530
Hi,
I have a requirement wherein I need to get the 'where clause' (or the
entire select statement ) from the cocoa client to pass it to the to the
backend procedure.
The select query we are getting from ' build find query ' has bind variables
inplace of actual parameters.
(I get it using [theQueryStatement queryStatement] where theQueryStatement
is DBQuery object it returns the query statement with bind variables)
For example :
SELECT MODEL_NAME ,MODIFIED_DT FROM SERVICE_FIND_VIEW WHERE MODEL_ID = :B0
AND BUYER_GROUP = :B1 AND LOWER(MFG_STATUS) LIKE 'inactive%' AND
OVERRIDE_FLAG = :B3 AND FEEDSAP_FLAG = :B4
Please let me know How I can get the query statement(at least a 'where
clause') with the actual parameters replacing the bind variables.
Any help or pointers will be greatly appreciated.
Thanks in advance,
Vikrama.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden