Hello Carlos,
>> I did so immediately after you ask me. Have you got my email?
>
> I haven't.
It's mysterious ... I sent it to [EMAIL PROTECTED]
I've created a bug issue (DNET-87) in firebird tracker.
Regards
Ralf
-
Take
Hello:
> Sorry, my fault.
Don't worry ^^
> BTW just quick info, if I write:
> cmd.Parameters.Add("@s", FbDbType.VarChar).Value =3D "";
> provider will ask server for length (on other side no asking =
>
> cmd.Parameters.Add("@s", FbDbType.VarChar, 5).Value =3D "";), right?
Right
> The easiest way is to use TransactionScope.
>
> using (TransactionScope scope = new TransactionScope())
> {
>//do your code
>sc.Complete();
> }
>
I'll try it.
Thanks
Marv
-
Take Surveys. Earn Cash. Influence the Fu
The easiest way is to use TransactionScope.
using (TransactionScope scope = new TransactionScope())
{
//do your code
sc.Complete();
}
Or you can make TableAdapter's connection public visible and start
transaction manually (this is some kind of old-school way).
--
Jiri {x2} Cincura
http:/
> refer 2nd example.
>
Please forgive the pseudo code, but how would I modify this code to
use a single transaction?
DataSetTableAdapters.LOCATIONSTableAdapter lota =
new DataSetTableAdapters.LOCATIONSTableAdapter();
DataSet.LOCATIONSDataTable lodt = lota.Get
Carlos Guzmán Álvarez wrote:
> It should be done in XdrStream for the standalone server GDS implementation.
Damn, you're right, of course. I got FbException with specific error
message and number so I thought it's from server.
Sorry, my fault.
BTW just quick info, if I write:
cmd.Parameters.Add
See this
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=examples
refer 2nd example.
On 4/2/07, Marvin Cook <[EMAIL PROTECTED]> wrote:
Hi,
Could someone point me to a code example of using a transaction with
the FB .Net Provider?
Thanks
Marv
--
Hi,
Could someone point me to a code example of using a transaction with
the FB .Net Provider?
Thanks
Marv
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance
Hello:
> I did so immediately after you ask me. Have you got my email?
I haven't.
> Should I do this too?
It will be nice if you can do that ( http://tracker.firebirdsql.org )
-
Take Surveys. Earn Cash. Influence the Futur
Hello:
> Currently I just use a fbcommand statement to execute some sql statement.
> I am curious does this way auto commit?
When you run a query with the FbCommand if the FbCommand instance has no
transaction specfified, the provider will start one for you and will do
a commit or a rollback of
Hello:
> Are you sure? I was testing this yesterday and nothing was thrown.
It should be done in XdrStream for the standalone server GDS implementation.
case DbDataType.Char:
if (param.Charset.IsOctetsCharset)
{
this.WriteOpaque(param.DbValue.GetBinary(), param.Length);
Not nothing of course. I got error from FB server of course.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsa
manish shukla wrote:
> oh, i am sorry.
> thanks for the info.
> can you tell me how to do backup and restore by using data provider? i
> am using embedded version.
public void BackupTest()
{
FbBackup backupSvc = new FbBackup();
back
Carlos Guzmán Álvarez wrote:
> The provider checks for char and varchar parameters that the value has a
> correct lenght according to the parameter definition, if it hasn't it
> will raise an exception.
Are you sure? I was testing this yesterday and nothing was thrown.
--
Jiri {x2} Cincura
htt
At 11:16 PM 2/04/2007, you wrote:
>What is the main reason to use transactions?
Because in a transactional database (which Firebird is) you can't
avoid it. Everything happens in a transaction, such that the work
that you are doing is isolated from what everyone else is doing.
>Currently I just
At 10:54 PM 2/04/2007, you wrote:
>I to was getting the unable to undate meta data error. I guess that
>explains it.
>So I initially tried to create the table with one large sql
>statement and got a message that it was to large.
>Then I split the table up and was using a seperate update command t
> Yes, on the XdrStream class.
>
> http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Client/Gds/XdrStream.cs?r1=28&r2=102
Make same changes in
NETProvider_17\source\FirebirdSql.Data.Gds\XdrStream.cs and my old test
application (same as i
Gary,
See this
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=examples
and for more information here:
http://firebirdsql.org/dotnetfirebird/index.html
-
Take Surveys. Earn Cash. Influence the Future of IT
Joi
What is the main reason to use transactions?
Currently I just use a fbcommand statement to execute some sql statement.
I am curious does this way auto commit?
If I do use transactions can someone sent a sample code for a basic select
transaction.
Thanks.
---
I to was getting the unable to undate meta data error. I guess that explains it.
So I initially tried to create the table with one large sql statement and got a
message that it was to large.
Then I split the table up and was using a seperate update command to add each
column, this caused me to ru
Hello Carlos,
>> I've build a simple test application to reproduce the behavior.
>
> Can you send it to my private email, please ??
I did so immediately after you ask me. Have you got my email?
> Or you can fill a bug in the firebird tracker and post the
> sample there.
Should I do this too?
oh, i am sorry.
thanks for the info.
can you tell me how to do backup and restore by using data provider? i am
using embedded version.
thanks,
Manish
On 4/2/07, Helen Borrie <[EMAIL PROTECTED]> wrote:
At 05:20 PM 2/04/2007, you wrote:
> >Max no. of columns in Firebird is 255
>
> >Not true.
>
Just load all needed tables into DataSet or DataTables and assign them as
datasource with SetDatasource method of Crystal Report ReportDocument in
runtime, for design time you can use ODBC connection as model for table
structure
--
View this message in context:
http://www.nabble.com/How-can-I-c
At 05:20 PM 2/04/2007, you wrote:
> >Max no. of columns in Firebird is 255
>
> >Not true.
>
>I don't think you are right, because i have tested Fireird
>2.0.0.12748 DB by Data Provider, and i could only insert max of 255
>columns after that which it says "Unsuccessful MetaData update. Too
>many
Hello:
> We have not tested your changes yet. Where can i take changes? From SVN
> only?
Yes, on the XdrStream class.
http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Client/Gds/XdrStream.cs?r1=28&r2=102
-
Hello:
> When I drag the the table from the Data Sources window to a blank form
> I get the binding navigator and a "lOCATIONSDataGridView" which has no
> columns defined and when I go to edit columns the table is not shown.
> I can drag another table in my db to the same form and the resulting
>
Max no. of columns in Firebird is 255
Not true.
I don't think you are right, because i have tested Fireird 2.0.0.12748 DB
by Data Provider, and i could only insert max of 255 columns after
that which it says "Unsuccessful MetaData update. Too many versions".
manish
On 4/2/07, Helen Borrie
27 matches
Mail list logo
