TableAdapter Commands on PostgreSQL Direct.
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
good day
i havent received any email yet. my email add is : [email protected]
in my video it is clear that the table have primary keys. but as i drag them to the dataset, update and delete commands are not generated, and errors too on tableadapter parameters.
anyway, ill try to upload the table code and structure soon. i am using enterprise db 8.1
hope this problem will be solved.. thank you.
i havent received any email yet. my email add is : [email protected]
in my video it is clear that the table have primary keys. but as i drag them to the dataset, update and delete commands are not generated, and errors too on tableadapter parameters.
anyway, ill try to upload the table code and structure soon. i am using enterprise db 8.1
hope this problem will be solved.. thank you.
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
Good day.,
here are the code for the table chartofaccounts
CREATE TABLE "public"."chartofaccounts" (
"accountid" VARCHAR(15) NOT NULL,
"accounttype" VARCHAR(6) NOT NULL,
"genaccountid" VARCHAR(15) NOT NULL,
"shortaccountname" VARCHAR(25) NOT NULL,
"accountname" VARCHAR,
"fullname" TEXT,
"isroot" BOOLEAN DEFAULT false,
CONSTRAINT "chartofaccounts_pkey" PRIMARY KEY("accountid")
) WITHOUT OIDS;
I just wonder today, when i tried to test again the tableadapter for update and delete commands, it come to me as a surprise that it is generated. !!
I wonder what went wrong with it. Im using my office pc for now, ill try this one at home. hope it works.
However, the errors remaining is the parameters, similar to thomas holschen's post, i cant create a parameter at the query builder of the tableadapter, then suddenly it generates an error , forcing to close and restart Visual Studio 2005.
Hope you can solve this issue on parameters the soonest time possible. Thank you very much
here are the code for the table chartofaccounts
CREATE TABLE "public"."chartofaccounts" (
"accountid" VARCHAR(15) NOT NULL,
"accounttype" VARCHAR(6) NOT NULL,
"genaccountid" VARCHAR(15) NOT NULL,
"shortaccountname" VARCHAR(25) NOT NULL,
"accountname" VARCHAR,
"fullname" TEXT,
"isroot" BOOLEAN DEFAULT false,
CONSTRAINT "chartofaccounts_pkey" PRIMARY KEY("accountid")
) WITHOUT OIDS;
I just wonder today, when i tried to test again the tableadapter for update and delete commands, it come to me as a surprise that it is generated. !!
I wonder what went wrong with it. Im using my office pc for now, ill try this one at home. hope it works.
However, the errors remaining is the parameters, similar to thomas holschen's post, i cant create a parameter at the query builder of the tableadapter, then suddenly it generates an error , forcing to close and restart Visual Studio 2005.
Hope you can solve this issue on parameters the soonest time possible. Thank you very much
So, seemingly, this problem is absent.when i tried to test again the tableadapter for update and delete commands, it come to me as a surprise that it is generated.
We have fixed this problem for you two. VS won't crash anymore.However, the errors remaining is the parameters, similar to thomas holschen's post
Look forward to the next build.
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact:
Good day.
Thank you very much for the help. Hope that this new build
can accomodate multiple queries in tableadapters with parameters.
What version will the the new build release be, ?
On your posted announcement, it is currently v 2.50.21, but
i think it does not have the fixes for the db parameters. So i
guess it will be another version..?
Also, i have visited the downloads section, I haven't downloaded
it yet. coz i think it is still the older version.
May i ask when can you post the new build..?
Thank you very much.
Thank you very much for the help. Hope that this new build
can accomodate multiple queries in tableadapters with parameters.
What version will the the new build release be, ?
On your posted announcement, it is currently v 2.50.21, but
i think it does not have the fixes for the db parameters. So i
guess it will be another version..?
Also, i have visited the downloads section, I haven't downloaded
it yet. coz i think it is still the older version.
May i ask when can you post the new build..?
Thank you very much.
-
- Posts: 18
- Joined: Sat 12 Aug 2006 06:37
- Contact: