Carlos Guzmán Álvarez wrote:
> I can fill the IsUnique column with a value but i'm unsure about the
> problems that could cause.
IsUnique is in FB correctly reported as True (if it's unique).
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
---
Ok, i think i understand :-) (i didn't look in provider code, that's why i
could only make guesses) - if i understand the provider only "provides"
schema to FW, and it makes the rest, so if you set IsKey - FW knows - the
column belongs to PK (and there can be only one PK in table). If you set
IsU
Hello:
> maybe i don't understand what is made behind the curtain, but ... when
> provider populates schema for table, it checks if primary key for the table
> consists of 1..x fields (if any pk at all :-) ), and creates an array of
> DataColumn for the PrimaryKey property of DataTable, doesn't it
paha wrote:
> maybe i don't understand what is made behind the curtain, but ... when
> provider populates schema for table, it checks if primary key for the table
> consists of 1..x fields (if any pk at all :-) ), and creates an array of
> DataColumn for the PrimaryKey property of DataTable, doesn'
maybe i don't understand what is made behind the curtain, but ... when
provider populates schema for table, it checks if primary key for the table
consists of 1..x fields (if any pk at all :-) ), and creates an array of
DataColumn for the PrimaryKey property of DataTable, doesn't it? Could he do
j
A. Another point. When I create PK on 2 columns or unique on 2
columns. VS always creates a key on these columns on DataTable level. No
unique is set for columns.
It seems to me, that unique and PK is from MS SQL's provider and VS's
view the same and they're handling it in a "special" way.
Well, seems to be little bit weird. No matter what I do, I'm not able to
make MS SQL server & SQL Client to provide these values (it's probably
the reason why it worked):
IsUnique: False
IsKey:
it's always False and "empty". But the PK or unique is there, if I try
to insert some data I got erro
Well, first message. MS SQL does it right. :(
I'm now working on finding the problem in FB provider.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by DB2 Exp
Jiri Cincura wrote:
>
> I hope for commiting these statements before running test with provider.
> :)
>
I did this either ;-) , i'm eager if you can reproduce this issue. It is not
critical, actually, one can just add complex index with unique flag, that
will do the job, but ... if i already o
Helen Borrie wrote:
> If the DDL isn't committed, no other transaction will know about it.
I hope for commiting these statements before running test with provider. :)
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
I've done everything in IBexperts, i mean, i created test table, added
constraints and filled it with test data, tested if constraint works as
supposed. After that i just copied first table structure and then data to my
post. So the described bug has nothing to do with commits. Of course they
sho
At 10:46 PM 24/04/2007, you wrote:
>Helen Borrie wrote:
> > I don't see you commit the DDL before attempting to apply DML to the
> > table. Always do that, or you will get the corrupted effects you describe.
>
>I don't think, that this is the problem. I suppose, that table etc. is
>created in isql
Helen Borrie wrote:
> I don't see you commit the DDL before attempting to apply DML to the
> table. Always do that, or you will get the corrupted effects you describe.
I don't think, that this is the problem. I suppose, that table etc. is
created in isql (or something similar) and from .NET is
At 07:12 PM 24/04/2007, you wrote:
>Hi, can anybody confirm such bug???
>.net Provider 2.1.0.0 beta3
>
>Create test table
>
>CREATE TABLE TEST (
> F1 INTEGER,
> F2 INTEGER
>);
>ALTER TABLE TEST ADD CONSTRAINT UNQ1_TEST UNIQUE (F1, F2);
>
>Fill it with data
>
>INSERT INTO TEST (F1, F2) VA
I've tested, doesn't work either
the code
FbConnection conn = new FbConnection(Db.ConnectionString);
FbCommand comm = new FbCommand("select * from test", conn);
FbDataAdapter da = new FbDataAdapter(comm);
da.MissingSchemaAction = MissingSchemaActio
ok, i test the case with Fb - classes and send result
--
View this message in context:
http://www.nabble.com/Unique-Constraint-Bug-tf3637383.html#a10158235
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-
paha wrote:
>
> Jiri Cincura wrote:
>>
>> da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
>> This is doing wrong job. :)
>>
> Why? Worked always for me, without this there are no constraints at all. Is
> there any option to this?
Exactly. This will not create any constaints. :)
>
>
Jiri Cincura wrote:
>
> da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
> This is doing wrong job. :)
>
Why? Worked always for me, without this there are no constraints at all. Is
there any option to this?
Jiri Cincura wrote:
>
> Can you try this with MS SQL? I don't have here VS t
paha wrote:
> da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
This is doing wrong job. :)
> da.Fill(result); // Here we get exception
> Transaction.Commit();
>
>
> I should notice, that with complex PrimaryKey is everything ok - many
> columns in one primary key, so should be done for
Jiri Cincura wrote:
>
> How are you creating DataSet/DataTable? Is created from design-time?
>
no, just in runtime, but i use common types (can it be problem? i will test
it without common types)
DbTransaction Transaction = CreateTransaction(); //Here will be returned
FbTransaction
DbCommand c
paha wrote:
> And now try to read the data with FbDataAdapter.Fill
> The Problem is - there will be created two different Unique Contraints for
> every column instead of one constraint with two columns and obviously you
> get the exception "cannot activate constraints".
> Is it a bug or missing fu
21 matches
Mail list logo
