If I create update command for TableAdapter, it creates me paramaters as
objects...
Tested in my VS. Look at screenshot.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'
If I create update command for TableAdapter, it creates me paramaters as
objects...
Tested in my VS. Look
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chanc
Carlos Guzmán Álvarez wrote:
> can't be customized ( as i know at least )
Yeah, I hate MS for doing this.
But it's a good story for other developers - trust me, everytime I'm saying
this everybody almost cries from laughing. ;)
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID
Hello:
> AFAIK this Query Builder and some other stuff is handled by VS.
>
> We're i.e. not able to check, whether the query is OK (right Carlos?).
Yes the query builder is doing some sort of parsing but it's not valid
for all servers and
can't be customized ( as i know at least )
--
Carlos G
> If I create update command for TableAdapter, it creates me paramaters as
> objects...
Hmm, very strange... I'll look at home later...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay
sasha wrote:
>> Yes.
>> BTW can you send me a test case, I try to have a look at the problem.
>
>
> But what test do you want? You can take any table with BIGNINT field and
> create for example UPDATE command oh this field... I can sent you
> screenshots if you want.
If I create update comma
> Yes.
> BTW can you send me a test case, I try to have a look at the problem.
But what test do you want? You can take any table with BIGNINT field and
create for example UPDATE command oh this field... I can sent you
screenshots if you want.
sasha wrote:
> example i have few fields with name "Name" and i think sql provider will
> handle this names correctly.
AFAIK this Query Builder and some other stuff is handled by VS.
We're i.e. not able to check, whether the query is OK (right Carlos?). If
you input "select first 1 some from fo
sasha wrote:
>> It's not wrong. ;)
>
> Why provider decide to select for this parameter Int32 type? Why don't
> it use object, boolean, string, deciamal and so on... I think provider
> can generate correct type ;-)
Yes.
BTW can you send me a test case, I try to have a look at the problem.
--
> But MS SQL also supports quoted identifiers in "" and []. I'm using in
> my MS SQL databases fields with names equals to reserved words. For
> example i have few fields with name "Name" and i think sql provider will
> handle this names correctly.
The fact that quoted identifiers are case-sensiti
> It's not wrong. ;)
Why provider decide to select for this parameter Int32 type? Why don't
it use object, boolean, string, deciamal and so on... I think provider
can generate correct type ;-)
-
Take Surveys. Earn Cash. I
> Well, creating case sensitive tables is like playing with a fire.
> But this isn't problem of FB provider, this quotation is handled by VS.
But MS SQL also supports quoted identifiers in "" and []. I'm using in
my MS SQL databases fields with names equals to reserved words. For
example i have
sasha wrote:
>> Why don't you just change the parameter?
>
> I changed, but is that correct behavior?
It's not wrong. ;)
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
Take Surveys. Earn C
sasha wrote:
> After this formatting command becomes invalid because there are no any
> table with name NOTES.
Well, creating case sensitive tables is like playing with a fire.
But this isn't problem of FB provider, this quotation is handled by VS.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/j
> Why don't you just change the parameter?
I changed, but is that correct behavior?
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions
sasha wrote:
> In my case field SomeField was of type Int64, but designer adds
> parameter @SomeField of type Int32.
Why don't you just change the parameter?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
And yet one problem in these designers.
When i'm creating command:
UPDATE
SomeField = @SomeField
...
then designer adds parameter @SomeField in parameters collection
In my case field SomeField was of type Int64, but designer adds
parameter @SomeField of type Int32.
So i've caught unexpected
Yet one problem:
1) I have table "Notes", not NOTES
2) Right click on NotesTableAdapter in data set design mode, select
Properties
3) In property grid i see Data section with properties like
InserCpmmand, UpdateCommand ets...
4) Choose insert command and select (new), then select command text an
> easy ;) carlosga05 at gmail.com
Sent...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief sur
Hello:
> Can't find your e-mail. You can try script below...
>
easy ;) carlosga05 at gmail.com
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-
Take Surveys. Earn Cash. Influence the Future of IT
Join
Another one. If i not confuse (can't check now) MS SQL's provider
generate something like this:
INSERT INTO "Table" ("Name", "Description") VALUES (@Name, @Description);
SELECT "Id", "Name", "Description" FROM "Table" WHERE "Id" =
SCOPE_IDENTITY();
But it's not completely clear for me how does
> Does this work with previous version? Does the MS SQL work with views (if
> you're able to test)?
Don't know about previous versions and MS SQL. In any case this is a bug.
-
Take Surveys. Earn Cash. Influence the Future
> Can you send a test database to my private email ??, please
Can't find your e-mail. You can try script below...
/**/
/*** Generated by IBExpert 2006.11.26 08.01.2007 22:12:26
***/
/*
Hello:
> I'm using FB.NET Privider 2.1 with DDEX 2.0.1.
>
> When i click "Add query" in DataSet designer on table adapter and choose
> generating new UPDATE or INSERT command then provider generates simple
> words UPDATE or INSERT and that's all.
>
> I've tried generation of commands for vews.
sasha wrote:
>> Is the view updatable?
>
> Yes. It simle alias for table:
>
> CREATE VIEW "Notes" AS SELECT * FROM "_Notes";
Humm, seem to be, that cooperation with DbCommandBuilder isn't 100% correct
(it will not return result in GetInsertCommand etc.).
Does this work with previous version? D
> Is the view updatable?
Yes. It simle alias for table:
CREATE VIEW "Notes" AS SELECT * FROM "_Notes";
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to
Hi!
I'm using FB.NET Privider 2.1 with DDEX 2.0.1.
When i click "Add query" in DataSet designer on table adapter and choose
generating new UPDATE or INSERT command then provider generates simple
words UPDATE or INSERT and that's all.
I've tried generation of commands for vews. For tables seem
sasha wrote:
> I've tried generation of commands for vews. For tables seems all ok
Is the view updatable?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
Take Surveys. Earn Cash. Influence t
28 matches
Mail list logo