Re: [sqlite] How to convert any dataType to sqlite3_value ?

2008-09-20 Thread Igor Tandetnik
"suku249" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> Igor Tandetnik wrote:
>>
>> suku249 <[EMAIL PROTECTED]>
>> wrote:
>>> I need to convert dataTypes like int or string into sqlite3_value.
>>
>> Why? What are you trying to achieve?
>
> We are trying to implement fts3 functionality without using the
> virtual table implementation, So we are trying to implement three
> functionalities, createTable(creates content,segement and seg dir
> table), InsertData (insert data into the 3 tables) and selectTerms (
> which selects data from 3 tables). These functions will be directly
> called from client apps. For this, we are trying to port code from
> fts3.c. Data content is passed as type sqlite3_value in many
> functions in fts3.c. To port existing functionalities in fts3.c, we
> need to use sqlite3_value.

Well, there's no public API to create these structures. Since you are 
deep in SQLite source code anyway, I guess you could extract necessary 
functionality from it.

However, I would imagine that the first thing those FTS3 functions do is 
extract actual values from sqlite3_value structures. Couldn't you just 
strip that part from the code, and make your functions take the 
strongly-typed values directly? That should make both your and your 
clients' lives easier.

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] How to convert any dataType to sqlite3_value ?

2008-09-20 Thread suku249

We are trying to implement fts3 functionality without using the virtual table
implementation, So we are trying to implement three functionalities,
createTable(creates content,segement and seg dir table), InsertData (insert
data into the 3 tables) and selectTerms ( which selects data from 3 tables).
These functions will be directly called from client apps. For this, we are
trying to port code from fts3.c. Data content is passed as type
sqlite3_value in many functions in fts3.c. To port existing functionalities
in fts3.c, we need to use sqlite3_value.  

Igor Tandetnik wrote:
> 
> suku249 <[EMAIL PROTECTED]>
> wrote:
>> I need to convert dataTypes like int or string into sqlite3_value.
> 
> Why? What are you trying to achieve?
> 
> Igor Tandetnik 
> 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/How-to-convert-any-dataType-to-sqlite3_value---tp19574177p19584357.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] How to convert any dataType to sqlite3_value ?

2008-09-19 Thread Igor Tandetnik
suku249 <[EMAIL PROTECTED]>
wrote:
> I need to convert dataTypes like int or string into sqlite3_value.

Why? What are you trying to achieve?

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users