Hi
Here is the example I worked..
> Creating the table
SqlLite.exe test.db "create table t3 (t3key INTEGER PRIMARY KEY,path
TEXT,num double,timeEnter DATE , validate BOOL);"
> Inserting into the table
SqlLite.exe test.db "insert into t3 (path,num) values
('D:/CCVweiew/sampleexample/data/path',3);"
SqlLite.exe test.db "insert into t3 (path,num) values
('D:/CCdfView/sample/dadfta2/abcd',3);"
SqlLite.exe test.db "insert into t3 (path,num) values
('D:/CCVdfiew/sample/data/efgh',3);"
>
SqlLite.exe test.db "select * from t3 ";
t3key = 1
path = D:/CCVweiew/sampleexample/data/path
num = 3.0
timeEnter = NULL
validate = NULL
t3key = 2
path = D:/CCdfView/sample/dadfta2/abcd
num = 3.0
timeEnter = NULL
validate = NULL
t3key = 3
path = D:/CCVdfiew/sample/data/efgh
num = 3.0
timeEnter = NULL
validate = NULL
> updating when path matches '/sample/'
SqlLite.exe test.db "update t3 set validate=500 where path like
'%/sample/%'"
>SqlLite.exe test.db "select * from t3 ";
t3key = 1
path = D:/CCVweiew/sampleexample/data/path
num = 3.0
timeEnter = NULL
validate = NULL
t3key = 2
path = D:/CCdfView/sample/dadfta2/abcd
num = 3.0
timeEnter = NULL
validate = 500
t3key = 3
path = D:/CCVdfiew/sample/data/efgh
num = 3.0
timeEnter = NULL
validate = 500
Hope it solves ur probs..
--
ABC
mikewhit wrote:
>
> Gerasimos Xydas <[EMAIL PROTECTED]> writes:
>
>>
>> Hello,
>>
>> I have built an SQLite 3 database from C code.
>>
>> CASE 1
>> ========
> ...
>> CASE 2
>> ========
> ...
>>
>> Best regards,
>> Gerasimos
>>
>
> Search the newsgroup ... start here
> http://thread.gmane.org/gmane.comp.db.sqlite.general/42112
>
> Regards,
> MikeW
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://www.nabble.com/LIKE-operator-to-support-GREEK-tp20341577p20374899.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
