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
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: [email protected]
Subject: [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.
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-
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
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.
--
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
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
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
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
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/
"
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" (
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
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.
--
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: [email protected]
Subject: Re: [Firebird-net-provider] FBConnection.CreateDatabase
Hello:
> Use fb cli
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
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
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 )
---
18 matches
Mail list logo
