Re: [sqlite] Most wanted features of SQLite ?

2009-09-20 Thread Guillermo Varona Silupú 
Hi
I want to insert this text:

1' equivale a 12"

cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")

TIA
Best Regards
GVS



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

[sqlite] How can I do to build this query with a text that contains ' and "?

2009-09-20 Thread Guillermo Varona Silupú 
Hi
I want to insert this text:

1' equivale a 12"

cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")

TIA
Best Regards
GVS

P.D.: Sorry for the post past and my bad english



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

Re: [sqlite] How can I do to build this query with a text that contains ' and "?

2009-09-20 Thread Guillermo Varona Silupú 
Thanks, now work fine

BestRegards
GVS

Simon Davies escribió:
> 2009/9/20 Guillermo Varona Silupú :
>   
>> Hi
>> I want to insert this text:
>>
>> 1' equivale a 12"
>>
>> cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")
>> 
>
> INSERT INTO Tabla1 (Code,Equiv) VALUES (10, '1'' equivale a 12"');
>
>   
>> TIA
>> Best Regards
>> GVS
>>
>> P.D.: Sorry for the post past and my bad english
>>
>>
>> 
>
> single quotes to delimit string literals. Double them up to escape
> them inside a string literal.
> See http://www.sqlite.org/lang_expr.html#litvalue
>
> Regards,
> Simon
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

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

[sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

2009-09-21 Thread Guillermo Varona Silupú 
Hi
In these SQL commands:

CREATE TABLE "test" ("code" char(2));
INSERT INTO test (code) VALUES("123")

Why are allowed to keep a text of 3 characters in a field that has been 
set to 2?
Is a bug?

TIA
BestRegards
GVS

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

Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

2009-09-21 Thread Guillermo Varona Silupú 
Ok.
Simon and  P Kishor.
Thank very much for your response

BestRegards
GVS

Simon Davies escribió:
> 2009/9/21 Guillermo Varona Silupú :
>   
>> Hi
>> In these SQL commands:
>>
>> CREATE TABLE "test" ("code" char(2));
>> INSERT INTO test (code) VALUES("123")
>>
>> Why are allowed to keep a text of 3 characters in a field that has been
>> set to 2?
>> Is a bug?
>> 
>
> No - I suggest that you have a look at http://www.sqlite.org/datatype3.html
>
>   
>> TIA
>> BestRegards
>> GVS
>>
>> 
>
> Regards,
> Simon
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

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