Re: [Firebird-net-provider] bug of Guid When use dbcommandbuilder

2006-04-10 Thread Carlos Guzmán Álvarez
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 ) ---

[Firebird-net-provider] FBConnection.CreateDatabase

2006-04-10 Thread Paul Mercea
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. Atte

Re: [Firebird-net-provider] FBConnection.CreateDatabase

2006-04-10 Thread Carlos Guzmán Álvarez
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

RE: [Firebird-net-provider] FBConnection.CreateDatabase

2006-04-10 Thread Paul Mercea
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 cli

Re: [Firebird-net-provider] bug of Guid When use dbcommandbuilder

2006-04-10 Thread byx45
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. --

[Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-10 Thread Jesse Sightler
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 n

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-10 Thread Carlos Guzmán Álvarez
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" (

[Firebird-net-provider] Connection string change

2006-04-10 Thread Carlos Guzmán Álvarez
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/ "

Re: [Firebird-net-provider] Connection string change

2006-04-10 Thread Jiri Cincura
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 wil

Re: [Firebird-net-provider] Connection string change

2006-04-10 Thread Carlos Guzmán Álvarez
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 Álv

Re: [Firebird-net-provider] Connection string change

2006-04-10 Thread Jiri Cincura
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 DbC

Re: [Firebird-net-provider] Connection string change

2006-04-10 Thread Carlos Guzmán Álvarez
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 Hejl

[Firebird-net-provider] How to use sql to insert record with guid?

2006-04-10 Thread byx45
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. --

Re: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-10 Thread Nemanja Corlija
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: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-10 Thread byx45
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-

[Firebird-net-provider] (no subject)

2006-04-10 Thread Thomas Clarke
--- 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.

RE: [Firebird-net-provider] Connection string change

2006-04-10 Thread Paul Mercea
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]

Re: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-10 Thread Carlos Guzmán Álvarez
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