Thank you Tomasz.
I want to pass a keyword in SQL statement: "Processing Shrimps" (Along with the Double Quotes)
So, i am writing it with \"
fts_keyword = " +\"Processing Shrimps\" +export ";
1) But how to pass the variable fts_keyword in below SQL statement?
score = odbcGetValueSQL("select MATCH(var1, var2, var3) AGAINST ( ' fts_keyword ' IN BOOLEAN MODE) as score from mytable where isin='"+Name()+"' ");
If we pass it the way I did above, it's not working. I also did '+fts_keyword+' that also does not work.
How to fix it?2) Another qts is I want to define the fts_keyword through paramstring as below:
fts_keyword = ParamStr( ''keyword', ''default'' );
When the Parameter Popup windows comes: what should i enter for the Parameter keyword:
Should i enter: +\"Processing Shrimps\" +export
Or should i enter like: " +\"Processing Shrimps\" +export "
Which will be same as
fts_keyword = " +\"Processing Shrimps\" +export ";
as in qts 1) above?
THe Objective of qts 2) is I want to pass the variable fts_keyword to the SQL statement through a parameter.
__._,_.___
Posted by: meanomalist@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
.
__,_._,___
EmoticonEmoticon