Hello:
> I have a problem with the tableadapter and the ddex provider i will try to
> explain you with an exemple :
I think i have this fixed in my local tree
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-
Hello:
> But the insert command didn't get generated ... looks weird ...
I will try to check if it could be something related to the
FbCommandBuilder class.
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
dimaaan wrote:
> Hi.
>
> I have a problem with procedure. Execute of this produce no effect
>
> ET TERM ^ ;
>
> CREATE PROCEDURE CLEAR_TEMP_DATA
> as
> begin
> DELETE FROM connected_players;
> DELETE FROM sel_nositeli;
> DELETE FROM sel_nositeli2;
> DELETE FROM sel_vvt;
> DELETE FROM
Hi.
I have a problem with procedure. Execute of this produce no effect
ET TERM ^ ;
CREATE PROCEDURE CLEAR_TEMP_DATA
as
begin
DELETE FROM connected_players;
DELETE FROM sel_nositeli;
DELETE FROM sel_nositeli2;
DELETE FROM sel_vvt;
DELETE FROM sel_vvt2;
end^
SET TERM ; ^
GRANT SELECT,
Hello:
> Huummm setting FAC_CODE ( As a test ) as primary key ... makes it to be
> enabled selecting only two fields ...
But the insert command didn't get generated ... looks weird ...
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-
Hello:
> It doesn't help as well
>
> But it looks like when selecting only the two first columns in the
> TableAdapter wizard the GenerateDBDirectmethods option
> is disabled ... the problem comes on knwing what can be the reasons
> that makes this to be disabled ...
Huummm setting FAC_CO
Hello:
> I will try to do a debug and looks what exceptions are being raised ( if
> there are any )
It doesn't help as well
But it looks like when selecting only the two first columns in the
TableAdapter wizard the GenerateDBDirectmethods option
is disabled ... the problem comes on knwing
Else i have found a ddex for sqlite database and it is very simple.
in this one this problem is'nt present so maybe can help you ?
you can find it at http://sourceforge.net/projects/sqlite-dotnet2
-
Using Tomcat but need
Hello:
> what is a concept mapper ?
It could be part of DDEX provider, it allows to map the field data type
to DbType, the Framework Type, etc ... but looks like
the problem isn't there
I will try to do a debug and looks what exceptions are being raised ( if
there are any )
> And you think that
> I'm thinking if it could be a matter of data type mapping ... i'm =
>
> thinking on try to implement a concept mapper ... and give it a try ...
>
what is a concept mapper ?
And you think that the problem is in the ddex provider or in the ado .net
provider ?
Hello:
> Yes in the property window this propertie is good but not in the genrated
> code so VS seems to take the information elsewhere but where i don't know :(
I'm thinking if it could be a matter of data type mapping ... i'm
thinking on try to implement a concept mapper ... and give it a try
> AllowDbNull looks correct to me at least in the properties window.
>
Yes in the property window this propertie is good but not in the genrated
code so VS seems to take the information elsewhere but where i don't know :(
Hello:
> If we look the different parameter we can see that AllowDbNull is always set
> to "False" or only the FAC_CODE Column should set to "False". Maybe the
> problem is here ?
AllowDbNull looks correct to me at least in the properties window.
--
Carlos Guzmán Álvarez
Vigo-Spain
http://car
Hello:
> NOTE: Carlos, is there any description of DDEX architecture (to understand
> the code and data flow there)?
There are the documentation that comes with the Visual Studio SDK ...
but the problem is not only what the DDEX provider does ... is in how
Visual Studio is using it and what inf
le roy arnaud wrote:
> but i will try with this :
> CREATE TABLE ACH_FAM (
> FAC_CODE SMALLINT NOT NULL,
> FAC_NOMVARCHAR(30) DEFAULT 'test',
> FAC_SELECTION SMALLINT DEFAULT 1
> );
>
> and i have the same problem and i will try with an access database and it's
> It could be i have done some changes some days that should help on that =
>
> ( While it's not possible to know what is being done by the VS to =
>
> generate the commands ... and what information is being used for that =
>
> ... :P )
> What version of the provider ( DDEX and ADO.NET ones )are
Hello:
> If we look the different parameter we can see that AllowDbNull is always set
> to "False" or only the FAC_CODE Column should set to "False". Maybe the
> problem is here ?
It could be i have done some changes some days that should help on that
( While it's not possible to know what is be
Hello:
> I haven't tested that file yet, i will try to do so as soon as possible.
I have done a test and looks like it's not possible to use the provider
in express as it's right now for that it will be nedded
to identify in the DDEX provider the connections as local ( the express
editions doesn
>
> IMHO it's because FAC_SELECTION doesn't have default value, so VS is not
> able to be 100% sure whether the insert will be OK (i.e. generator in
> trigger can "fix" this, but VS doesn't know this).
>
thanks jiro for the rapidity,
but i will try with this :
CREATE TABLE ACH_FAM (
FAC_CODE
le roy arnaud wrote:
> CREATE TABLE ACH_FAM (
> FAC_CODE SMALLINT NOT NULL,
> FAC_NOMVARCHAR(30),
> FAC_SELECTION SMALLINT
> );
>
> when i create a tableadpter with this sql command :
> "SELECT FAC_CODE,FAC_NOM,FAC_SELECTION FROM ACH_FAM".
> All the command are generated
Hello,
I have a problem with the tableadapter and the ddex provider i will try to
explain you with an exemple :
I have this table :
CREATE TABLE ACH_FAM (
FAC_CODE SMALLINT NOT NULL,
FAC_NOMVARCHAR(30),
FAC_SELECTION SMALLINT
);
when i create a tableadpter with this
Thanks Carlos,
I have FirebirdSql.Data.FirebirdClient.dll installed to the GAC on the
server and I put it into the application folder as well.
Is this what you meant? If not, where is FirebirdSql.Data.Firebird.dll? I
don't think it came with my install files.
Rick
Hello:
>
> Do I need to ins
Hello:
>
> Do I need to install something on the server to have an application
> run there?
>
The provider assembly ( FirebirdSql.Data.Firebird.dll )
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-
Us
23 matches
Mail list logo
