Hello,
I wrote the following function:
public void SaveChanges(DataTable table)
{
FbConnection myConn = new FbConnection(this.ConnectionString);
myConn.Open();
FbTransaction myTxn = myConn.BeginTransaction();
FbDataAdapter myDataAdapter = new FbDataAdapter(new
FbCommand(string.Format("S
On 13.4.2006 0:03 Carlos Guzmán Álvarez wrote:
In GDS implementations before the value of a char/varchar parameter is
written to the socket
the lenght of the string value gets compared with the lenght of the
field if it's greater an exception get thrown:
if ((param.Le
Hello:
I don't understand the sentence. :( The second part is weird.
In GDS implementations before the value of a char/varchar parameter is
written to the socket
the lenght of the string value gets compared with the lenght of the
field if it's greater an exception get thrown:
On 12.4.2006 23:10 Carlos Guzmán Álvarez wrote:
In FbCommand class to see if it's needed to request the server to
describe the parameters
and in GDS implementations before send the parameter to check if the of
the parameter value
is correct compared to the parameter size
I don't understand th
Hello:
It's done internaly for char/varchar parameters.
In FbCommand class to see if it's needed to request the server to
describe the parameters
and in GDS implementations before send the parameter to check if the of
the parameter value
is correct compared to the parameter size
--
Carlos
Hello:
me again. ;)
What's the sense of size property in FbCommand.Parameters.Add (or
common xxxCommand)? It does not perform any trimming or validation,
right.
It's done internaly for char/varchar parameters.
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
"When you do
Hi *,
me again. ;)
What's the sense of size property in FbCommand.Parameters.Add (or common
xxxCommand)? It does not perform any trimming or validation, right.
--
Jiri Cincura
http://www.cincura.net/
---
This SF.Net email is sponsored by x
I've tried it,use that encoding to building sql statement,but it doesn't
work,hehe!
I'm reading the source of provider now,but there isn't any code by generator
Sql statement with parameter,I think it's implemented by .net framework.
that's mean you don't know it too? :)
--
View this message in
Hello:
"Select * From Table where GuidField = "+Guidvalue,How can I convert
Guidvalue to a string format that
It can works?
You can try by using the BinaryEncoding class that comes with the
provider ( it was contributed by Jim Beveridge for the Guid support ) if
it doesn't work ... hehe .. we
thanks very much,I change it ,just this line:
DbParameter parameter = target.Factory.CreateParameter();
It works now!
but,I know When The parameter query works,It will generator sql command.I
want to know How to write the sql statement without parameter,Could you tell
me?
"Select * From Table whe
On 12.4.2006 14:15 Carlos Guzmán Álvarez wrote:
Yes it should be possible, if not it's a bug ;)
Yesterday it was not working for me. :( Today it's working! :)
Maybe some woodoo. ;)
--
Jiri Cincura
http://www.cincura.net/
---
This SF.Net em
Hello:
I have committed some changes in CVS to fix some problems with
the synonyms handling in the FbConnectionStringBuilder class.
Along with that fixes there are a new Catalog synonym for the Database
connection string parameter.
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogsp
Hello:
open conn.
select data
while read
read one row
use some columns from select and insert new to another table (insert
is using the same conn)
commit;
conn. close
Yes it should be possible, if not it's a bug ;)
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
"Wh
Something like this:
open conn.
select data
while read
read one row
use some columns from select and insert new to another table (insert
is using the same conn)
commit;
conn. close
--
Jiri Cincura
http://www.cincura.net/
---
This SF.Ne
Hi,
can I use one FbConnection for multiple FbCommands.
I'm using one command for selecting data from table and while reading
it, I'm inserting this and new data into another table.
Can I do this? Or need I 2 conections (one for reading data during
inserting (the second conn.))?
--
Jiri Ci
On 12.4.2006 10:17 Carlos Guzmán Álvarez wrote:
The problem with FIRST lies inthat the Query Builder performs a
validation of the SQL didn't know if there are a way of doing a custom
validation of it.
Ohh. This seems to be very bad. :(
--
Jiri Cincura
http://www.cincura.net/
---
Hello:
two way:
1.what's wrong for the codes? or
2.If I want use "select * from table where id = guid",how to write the
sqlStetement,I know there's
a way to write the sql,but how to write it?
I only use "'"+Encoding.Default.GetString(aGuid.ToByteArray()) +"'",It can't
work.
How to write it?
T
could you tell me how to use dbcommand to find a row with given guid
primarykey?
It can't work:(
DbCommand command = new DbCommand("select * From test where Id =
@Id",connection);
DbParameter parameter =command.CreateParameter();
parameter.ParameterName = "@Id";
parameter.Value = a guid that exis
Hello:
I've Test it use FbCommand,It Works Fine.
but It Can't Work use Dbcommand,only can work with fbcommand.as you
know,dbParameter Haven't charset property.
You don't need to set the Charset when using a Guid parameter the
provider will do so.
--
Carlos Guzmán Álvarez
Vigo-Spain
http
I've Test it use FbCommand,It Works Fine.
but It Can't Work use Dbcommand,only can work with fbcommand.as you
know,dbParameter Haven't charset property.
I read the GuidTest.cs,there is only three test there use Fb.
--
View this message in context:
http://www.nabble.com/How-to-use-sql-to-inse
Hello:
sure I use a field by char[16],and the charset is octecs.
Have you tested it using parametrized queries ?? and setting the
param value a the Guid ( the System.Guid not the string representation ) ??
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
"When you don't co
Hello:
There is other possibilities without other tools???
The provider has nothing to do that, so you will need to do that by yourself
( there was a user with the same need some time ago, Marek Leitl, search
the list if you want )
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosg
Hello:
It also points to QueryBuilder, which also don't works well. On
SELECT FIRST 100 title, perex, link FROM items WHERE feed_id =
@feed_id ORDER BY pub_date DESC;
I have tested on a DataAet a Paramtrized Query and looks as working fine
for me.
The problem with FIRST lies inthat the Quer
Hello:
What's interesting, though, is that I still got the error with
FbDbType set to Text as well. Shouldn't that have worked, even with
the size specified?
Huumm yes !! ... can you do a try with latest v2.0 CVS sources ??
There are a change from some days ago that changes the way the
"ID= '" +
Encoding.Default.GetString(((Guid)table.Rows[i]["Id"]).ToByteArray()) + "'"
sorry,For a example,I must use "Select * From Table Where ID=
'薳[\0\rC?-p=呖\r'",It Can't Get The
Record.I know I can Use FbCommand with parameterTo do it,but I use Dbcommand
with parametar
25 matches
Mail list logo
