Re: [Firebird-net-provider] How to use sql to insert record with guid?
Hello: sorry,as you know,many Guid's char is not visable in ascii. for eample,if "/0" in it,the sql statement will failed to exceute. my question is how to write the sql statement when it contained char such as 0x10,0x14? You need to use parametrized queries and the filed in the table should be a char(16) character set octets -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
RE: [Firebird-net-provider] Connection string change
It will be ok... Looks like SQL conection...more readable! PaulM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Tuesday, April 11, 2006 12:14 AM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Connection string change Hello: I'm thinking if i should do or not ( if not it will be done post v2.0 release ) a minor change in connection strings, just add a new 'Catalog' synonym for Database connection string parameter. Opinions welcome !!! -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd_ __ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] (no subject)
--- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] How to use sql to insert record with guid?
sorry,as you know,many Guid's char is not visable in ascii. for eample,if "/0" in it,the sql statement will failed to exceute. my question is how to write the sql statement when it contained char such as 0x10,0x14? -- View this message in context: http://www.nabble.com/How-to-use-sql-to-insert-record-with-guid--t1427996.html#a3853554 Sent from the firebird-net-provider forum at Nabble.com. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] How to use sql to insert record with guid?
On 4/10/06, byx45 <[EMAIL PROTECTED]> wrote:
>
> I'm not Sure,is this:
> insert xx values "1234567890123456"?
> or others?
If you're asking about SQL syntax to use, then this should be it:
INSERT INTO my_table(my_field) VALUES('my value')
You should use single quotes around the value that you're inserting.
--
Nemanja Corlija <[EMAIL PROTECTED]>
---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] How to use sql to insert record with guid?
I'm not Sure,is this: insert xx values "1234567890123456"? or others? -- View this message in context: http://www.nabble.com/How-to-use-sql-to-insert-record-with-guid--t1427996.html#a3851216 Sent from the firebird-net-provider forum at Nabble.com. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string change
Hello: OK. I think this wouldn't be a problem. Of course it's not a great deal, but i think it can be useful. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string change
On 10.4.2006 23:29 Carlos Guzmán Álvarez wrote: Hello: I think, if it will be synonym, why not. For me, this is not important. I'll use the "good old" syntax. ;) Yes, it's more a matter of compatibility with other provider when using the Connection String Builders in a generic way using DbConnectionStringBuilder. OK. I think this wouldn't be a problem. -- Jiri Cincura http://www.cincura.net/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string change
Hello: I think, if it will be synonym, why not. For me, this is not important. I'll use the "good old" syntax. ;) Yes, it's more a matter of compatibility with other provider when using the Connection String Builders in a generic way using DbConnectionStringBuilder. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string change
On 10.4.2006 23:13 Carlos Guzmán Álvarez wrote: Hello: I'm thinking if i should do or not ( if not it will be done post v2.0 release ) a minor change in connection strings, just add a new 'Catalog' synonym for Database connection string parameter. Opinions welcome !!! I think, if it will be synonym, why not. For me, this is not important. I'll use the "good old" syntax. ;) -- Jiri Cincura http://www.cincura.net/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Connection string change
Hello: I'm thinking if i should do or not ( if not it will be done post v2.0 release ) a minor change in connection strings, just add a new 'Catalog' synonym for Database connection string parameter. Opinions welcome !!! -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error code -303, Operation Not Supported...
Hello: COMMENTBODY = BLOB -- LONGVARCHAR -- subtype: text Have you set the FbDbType of this parameter to FbDbType.Text ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Error code -303, Operation Not Supported...
Hi All,I am seeing the following error during a simple insert into a table that has a text field:"Dynamic SQL ErrorSQL error code = -303feature is not supportedBLOB and array data types are not supported for move operation" The insert is using parameterized statements, but is otherwise completely normal:INSERT INTO COMPONENTCOMMENT (COMPONENTID,COMMENTRANK,COMMENTTYPE,COMMENTDESCRIPTION,COMMENTBODY) VALUES (@COMPONENTID,@COMMENTRANK,@COMMENTTYPE,@COMMENTDESCRIPTION,@COMMENTBODY) COMPONENTID = bigintCOMMENTRANK = smallintCOMMENTTYPE = smallintCOMMENTDESCRIPTION = varchar(70)COMMENTBODY = BLOB -- LONGVARCHAR -- subtype: textDo you know why I would get this error? Thanks,Jess
Re: [Firebird-net-provider] bug of Guid When use dbcommandbuilder
a embed database,only have a table named "Test",It contained two field,a Guid field and a text field. -- View this message in context: http://www.nabble.com/bug-of-Guid-When-use-dbcommandbuilder-t1268418.html#a3848454 Sent from the firebird-net-provider forum at Nabble.com. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
RE: [Firebird-net-provider] FBConnection.CreateDatabase
Thanks Carlos! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Monday, April 10, 2006 7:07 PM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] FBConnection.CreateDatabase Hello: > Use fb client 2.0, Firebird 2.0 and VS 2005. > Can I specify Page Size when I creata database? Yes, use: FbConnection.CreateDatabase(string connectionString, int pageSize, bool forcedWrites, bool overwrite) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd_ __ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FBConnection.CreateDatabase
Hello: Use fb client 2.0, Firebird 2.0 and VS 2005. Can I specify Page Size when I creata database? Yes, use: FbConnection.CreateDatabase(string connectionString, int pageSize, bool forcedWrites, bool overwrite) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] FBConnection.CreateDatabase
Hi Use fb client 2.0, Firebird 2.0 and VS 2005. Can I specify Page Size when I creata database? TIA Paul --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] bug of Guid When use dbcommandbuilder
Hello: Can you send a test database to my private email please ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
