Thanks Erv for the explanation.
I am outputting an xml file from this stored procedure where each row of the
returned column is a line of xml.
I want to write this to a file so I have been taking the output from the
DataTable, iterating through it and using a streamWriter.WriteLine to write
each
A data adapter object utilizes the Fill method to populate a DataSet or a
DataTable object with data retrieved by a SELECT command. Internally, the Fill
method makes use of a data reader to get to the data and the metadata that
describe the structure and content of the source tables. The data re
Yes, finally!
Thanks Erv.
I am new to VB.Net. What is the purpose of the GetData method?
Rick
-Original Message-
From: Ervin Kleinschmidt [mailto:[EMAIL PROTECTED]
Sent: Friday, October 20, 2006 3:18 PM
To: [EMAIL PROTECTED]; For users and developers of the Firebird .NET
providers
Sub
To get data back use the fill method.
An Example from one of my projects.
Note I'm setting '@' in the parameters name field in the dataset.
Me.NewRecipientTableAdapter.Fill(Me.PremiumsDataSet.NewRecipient,
Me.PremiumsDataSet.ORDERS(0).CUSTID, txtRcpLastName.Text, txtRcpFirstName.Text,
txtRcpAddr
Well, hopefully I understood this correctly.
Before I had in my GetData method:
GetData(INVOICENUM, LOGOFOLDER, DOCTYPE)
And now I have
GetData(@INVOICENUM, @LOGOFOLDER, @DOCTYPE)
So now I call like this
Dim sdInfo As New
RGardenDataSetTableAdapters.P_XML_SALESDOCTable
Hello,
Carlos Guzmán Álvarez said the following on 20.10.2006 20:33:
>> And it said that 1.1.18 is last release before Mono 1.2.
> Huummm v2.0 sources looks as building fine with the latest mono ... i'm
> going to run the
> nunit test suite now ... if it runs fine next versions will have mono
>
Hello:
>
> VB.Net 2005
>
> FB 1.5.3
>
> I’m using a table adapter for access to a stored procedure with three
> input parameters.
>
What are the names of the parameters in the TableAdapter query ??
--
Carlos Guzmán Álvarez
Vigo-Spain
---
Carlos Guzmán Álvarez wrote:
> Hello:
>> Nice subject really! For next question don't post message with this stupid
>> subject.
> Please try to mantain discussions in a polite way ;)
Sorry, but subject "please help me" really freaks me out.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | h
Hello:
> Nice subject really! For next question don't post message with this stupid
> subject.
Please try to mantain discussions in a polite way ;)
--
Carlos Guzmán Álvarez
Vigo-Spain
-
Using Tomcat but need to do more? N
Hello:
> The script executes fine in Flamerobin, without the RECONNECT; row before
> the "ALTER TABLE statment.
>
> Any ideas?
Could please send to me the isql script that is giving you problems ?? (
to my private email )
Thanks in advance.
--
Carlos Guzmán Álvarez
Vigo-Spain
Hello:
> I did search the list - and this gave me the hard and soft commit
> resolution.
> I just thought that someone has any ideea of what am I doing wrong.
>
> anyway, thanks...
It maybe a problem with the provider, but i don't the possible reasons
the server could raise
that exception so it'
VB.Net 2005
FB 1.5.3
I’m using a table adapter for access to a stored
procedure with three input parameters.
When I am in design view I can select “Preview Data”
by clicking on the TableAdapter, fill in the params and Preview to get the
results.
In code I am trying to call lik
Hello:
> Huummm v2.0 sources looks as building fine with the latest mono ... i'm
> going to run the
> nunit test suite now ... if it runs fine next versions will have mono
> binaries.
Things looks nice in general, while the test cases that are using the
FbDataAdapter classes are not working due
I did search the list - and this gave me the hard and soft commit
resolution.
I just thought that someone has any ideea of what am I doing wrong.
anyway, thanks...
> Hello:
>> Then I restarted the firebird server and all went ok afterwards. In the
>> log
>> there was this message with 'too many
Hello:
> I've tried today to build provider 2.0.1-RC2 with the latest 1.1.18 mono
> and it built without errors (just some warnings about unused variables).
> And it said that 1.1.18 is last release before Mono 1.2.
Huummm v2.0 sources looks as building fine with the latest mono ... i'm
going to r
Hello:
There are two users yet that have requested me to do a caching of the
Encodings on the Charset class,
in first place i think that shouldn't be a problem ( time ago there was
a change there due to memory problems
but if i didn't remember if at that time it was saving all the encodings
fro
Hello:
> I'm wondering about how provider handles connection pooling if there are
> connections with the different roles from the same application?
As the role is part of the connection string there will be two different
pools.
> Maybe provider should raise exception when user can't connect with
>
Hello:
> Then I restarted the firebird server and all went ok afterwards. In the log
> there was this message with 'too many savepoints'.
Could you ask in the fb-support lista bout the possible reasons of that
error ??
-
Usi
Hello:
> Is that normal (I am using it in a faulty way) or do I have to do anything
> more to complete my fbe execution?
What version of the provider are you using ??
What version of Firebird are you using ??
What version of .NET/mono are you using ??
Can you send to my private email the isql s
Hello:
> hello Carlos I have a question, if I want show two grids with information of
> two different tables
> how make this in one form
>
For example using a dataset with two TableAdapters or a dataset with two
DataTables
Julian Abreo Herrera wrote:
> hummm.
>
>
> I have a question, if I want show two grids with information of two
> different tables how make this
> in one form..
Nice subject really! For next question don't post message with this stupid
subject.
To the Q:
Create connection and 2 commands. P
Hello,
Carlos Guzmán Álvarez said the following on 02.09.2006 20:55:
> I have no problem with that, while i think it's better to include only
> the v2.0 of the provider
> in the mono 2.0 profile, but anyway i think that should be decided by
> the mono people.
I've tried today to build provider
hummm.
I have a question, if I want
show two grids with information of two different tables how make thisin one
form..
???
-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff don
Hi carlos
hello Carlos I have a question, if I want show two grids with information of
two different tables
how make this in one form
Thanks
Julian abreo.
original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de
Carlos Guzmán Álvarez
Enviado el: viernes, 20 de octubre
If I use FbBatchExecution I have problems that indicate that the transactions
are not commited correctly?
The Execute() method could be called with an argument, autocommit. What is
the difference between choosing true or false and what is default when
calling Execute() ?
If I use Execute(false)
Hello,
I'm wondering about how provider handles connection pooling if there are
connections with the different roles from the same application?
I think in Firebird role handling is different from MS SQL server, here
role should be specified in connection string, and role is in fact
property of co
Hi Jiri,
I've done some further testing and I'm not sure this is a Fb <->
TableAdapter issue. When I instantiate a TableAdapter in code and issue
an update everything is updated correctly. However, when I bind to a
GridView I get the error. I'll keep investigating.
Paul.
-Original Message---
Carlos Guzmán Álvarez wrote:
> Let me know if you want me to do the change or you like to do it by
> yourself :D
Of course myself. :) You have probably better things to do. :P
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
---
Hello:
> Yes that looks a good candidate for change.
Let me know if you want me to do the change or you like to do it by
yourself :D
-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done
Paul Cook wrote:
> One of the fields in the Firebird table is a blob type (which the
> TableAddapter has as Object type) and when I hit ‘Update’ I get ‘Value
> cannot be null’ on that field.
Is in DataTable null "value" allowed?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.I
I'm using connection.BeginTransaction(isolationLevel) calls and
I do NOT use Save() methods.
- Original Message -
From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
Sent: 20 October, 2006 16:29
Subject: Re: [Firebird-net-provi
Hello:
> OK, so I think, this is the good candidate for using generics. We'll kill
> the (un)boxing in the code like in get { return (FbError)this.errors[index];
> }.
> What do you think?
Yes that looks a good candidate for change.
Hello:
> This is the real problem :)
>
> I didn't had problem for a week (the app is running 18h a day) and one day
> in a transaction it just blocked.
> I tried to recreate the scenario with the production db on a dev machine but
> it worked.
> Then I restarted the firebird server and all went o
Hi
I’m hooking up my Firebird table to a GridView via a
TableAdapter and I’m having a few problems.
One of the fields in the Firebird table is a blob type (which
the TableAddapter has as Object type) and when I hit ‘Update’ I get
‘Value cannot be null’ on that field.
I’ve trie
One more info: where the problem appears I use IsolationLevel.Serializable.
-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job ea
This is the real problem :)
I didn't had problem for a week (the app is running 18h a day) and one day
in a transaction it just blocked.
I tried to recreate the scenario with the production db on a dev machine but
it worked.
Then I restarted the firebird server and all went ok afterwards. In the
balazs.zoltan wrote:
> There are 3 diferent applications, and 5 clients using them at the same
> firebird server.
> All 3 applications were developed by us, using a common db layer for
> communicating with the db server.
Well, can you "create" this error on some sample code (to find the bug in
There are 3 diferent applications, and 5 clients using them at the same
firebird server.
All 3 applications were developed by us, using a common db layer for
communicating with the db server.
- Original Message -
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of
balazs.zoltan wrote:
> Thanks,
>
> Is there any other possible reason for the 'too many savepoints' error
> message ?
Only your app is working with server?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
--
Thanks,
Is there any other possible reason for the 'too many savepoints' error
message ?
- Original Message -
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
Sent: 20 October, 2006 11:33
Subject: Re: [Firebird-net-provider] Commit
>
> OK, so I think, this is the good candidate for using generics. We'll kill =
>
> the (un)boxing in the code like in get { return (FbError)this.errors[index]=
> ; }.
> What do you think?
>
I think to use generics it's a very good idea for increase the
performance
-
balazs.zoltan wrote:
> My question is:
> - when I do
> transaction.Commit();
> transaction.connection.Close();
>
> does it do a commit retaining or a hard commit ?
Normal commit. For commit retaining is there CommitRetaining method.
--
Jiri {x2} Cincura
http://blog.vyvojar.c
Hello list,
In my firebird server logfile it shows up a message saying 'internal gds
software consistency check (Too many savepoints (287))'.
My question is:
- when I do
transaction.Commit();
transaction.connection.Close();
does it do a commit retaining or a hard commit ?
Th
Carlos Guzmán Álvarez wrote:
> Hello:
>
>> is there any reason, why is FbErrorCollection created as synchronized?
>>
>> Can be there any concurent access to collection?
>
>
> You mean the errors member of the FbErrorCollection class ??
Yes, private ArrayList errors member.
> No special reason
44 matches
Mail list logo
