Drew Byer
|
| Posted: 05/30/2002, 8:16 AM |
|
Page 28 of CCSTutorial_105.pdf states to view the working page and
A. sort by clicking on the column headers or
B. search by entering keyword.
===============================
A. - works for ID and Name
- semi works for Assigned To, meaning that they are almost entirely
placed in sort order, but for example "D" (David) and "P" (Pablo) come after
"R" (Rob)
- Project, Priority, and Status display the following error:
------------------------
Source: Grid tasks
Error: The specified field 'project_id' could refer to more than one table
listed in the FROM clause of your SQL statement. (Microsoft JET Database
Engine)
SELECT task_id, task_name, emp_name, priority_name, project_name,
status_name FROM (((tasks INNER JOIN priorities ON tasks.priority_id =
priorities.priority_id) INNER JOIN projects ON tasks.project_id =
projects.project_id) INNER JOIN statuses ON tasks.status_id =
statuses.status_id) INNER JOIN employees ON tasks.user_id_assign_to =
employees.emp_id ORDER BY project_id
-------------------------
B. Search (at this step) does not funtion properly, based on records
displayed.
Samples:
- Current list of records displays 3 records that would include the word
"test", but the search results only display the one record that has "test"
in the name field.
- Current list of records displays 5 records that would include the word
"code", but the search results displays ALL available records, including
ones that do not appearantly have the word "code" in any column.
Bugs or what?
Sincerely,
Drew
|
|
|
 |
Drew Byer
|
| Posted: 05/30/2002, 6:51 PM |
|
This refers to page 28 of document or page 34 of PDF. Topic is "View and
Test the Live Page"
"Drew Byer" <byerd@markross.com> wrote in message
news:ad5fnq$sq0$1@news.codecharge.com...
> Page 28 of CCSTutorial_105.pdf states to view the working page and
> A. sort by clicking on the column headers or
> B. search by entering keyword.
> ===============================
>
> A. - works for ID and Name
> - semi works for Assigned To, meaning that they are almost entirely
> placed in sort order, but for example "D" (David) and "P" (Pablo) come
after
> "R" (Rob)
> - Project, Priority, and Status display the following error:
> ------------------------
> Source: Grid tasks
> Error: The specified field 'project_id' could refer to more than one table
> listed in the FROM clause of your SQL statement. (Microsoft JET Database
> Engine)
> SELECT task_id, task_name, emp_name, priority_name, project_name,
> status_name FROM (((tasks INNER JOIN priorities ON tasks.priority_id =
> priorities.priority_id) INNER JOIN projects ON tasks.project_id =
> projects.project_id) INNER JOIN statuses ON tasks.status_id =
> statuses.status_id) INNER JOIN employees ON tasks.user_id_assign_to =
> employees.emp_id ORDER BY project_id
> -------------------------
>
> B. Search (at this step) does not funtion properly, based on records
> displayed.
> Samples:
> - Current list of records displays 3 records that would include the word
> "test", but the search results only display the one record that has "test"
> in the name field.
> - Current list of records displays 5 records that would include the word
> "code", but the search results displays ALL available records, including
> ones that do not appearantly have the word "code" in any column.
>
> Bugs or what?
>
> Sincerely,
> Drew
>
>
|
|
|
|
CodeCharge Support
|
| Posted: 05/31/2002, 4:24 AM |
|
Drew,
Re: A
Thanks for spotting this error. The Tutorial will need to be updated here as
well.
For now, please click on project column's heading/sorter and then in the
Data properties change Sort Order from "project_id" to "tasks.project_id".
Repeat the same for all such columns.
This is needed because Power Wizard creates the Grid based on single table
and database fields don't need to be fully qualified.
However, adding additional tables to the query requires the above change
because the multiple tables have the same field name.
Re: B
I only see one task with the word "Test" in task's name or description.
Other fields are not being searched.
Searching for "code" displays all records that have "code" in name or
description.
It seems to work OK, as all the tasks have "code" in the description.
Konrad
"Drew Byer" <byerd@markross.com> wrote in message
news:ad5fnq$sq0$1@news.codecharge.com...
> Page 28 of CCSTutorial_105.pdf states to view the working page and
> A. sort by clicking on the column headers or
> B. search by entering keyword.
> ===============================
>
> A. - works for ID and Name
> - semi works for Assigned To, meaning that they are almost entirely
> placed in sort order, but for example "D" (David) and "P" (Pablo) come
after
> "R" (Rob)
> - Project, Priority, and Status display the following error:
> ------------------------
> Source: Grid tasks
> Error: The specified field 'project_id' could refer to more than one table
> listed in the FROM clause of your SQL statement. (Microsoft JET Database
> Engine)
> SELECT task_id, task_name, emp_name, priority_name, project_name,
> status_name FROM (((tasks INNER JOIN priorities ON tasks.priority_id =
> priorities.priority_id) INNER JOIN projects ON tasks.project_id =
> projects.project_id) INNER JOIN statuses ON tasks.status_id =
> statuses.status_id) INNER JOIN employees ON tasks.user_id_assign_to =
> employees.emp_id ORDER BY project_id
> -------------------------
>
> B. Search (at this step) does not funtion properly, based on records
> displayed.
> Samples:
> - Current list of records displays 3 records that would include the word
> "test", but the search results only display the one record that has "test"
> in the name field.
> - Current list of records displays 5 records that would include the word
> "code", but the search results displays ALL available records, including
> ones that do not appearantly have the word "code" in any column.
>
> Bugs or what?
>
> Sincerely,
> Drew
>
>
|
|
|
|
Drew Byer
|
| Posted: 06/03/2002, 8:33 AM |
|
Thanks, I appreciate the info for the changes. However, the results are
not true.
Section A:
Yes, I no longer receive an error, but there still seems to be a problem
with the records being sorted in the correct order. The example below was
sorted by "Status", but as you can see "In Progress" comes before "Closed",
followed by "On Hold", then "Open". This same type of example appears in
fields ("Project" and "User Assigned To") that are sorted:
======================
Id Project Priority Status Name User Id Assign To
10 Super Project Highest In progress Code, code, code. Stefan Fey
5 Test Project High In progress Test this project. Rob McDonald
3 CodeCharge High Closed Get ready to click David Snyder
12 Test Project Lowest On hold Sleep Rob McDonald
8 Test Project Highest On hold Get armed John Smith
15 Super Project Highest Open Have fun Li Jang
====================
Section B:
You state that the results displayed are based on the name or description
fields. Well, my first question is:
1. Where is the description field and how can I make that visible?
Sincerely,
Drew Byer
"CodeCharge Support" <support@codecharge.com> wrote in message
news:ad7mhn$17s$1@news.codecharge.com...
> Drew,
>
> Re: A
> Thanks for spotting this error. The Tutorial will need to be updated here
as
> well.
> For now, please click on project column's heading/sorter and then in the
> Data properties change Sort Order from "project_id" to "tasks.project_id".
> Repeat the same for all such columns.
> This is needed because Power Wizard creates the Grid based on single table
> and database fields don't need to be fully qualified.
> However, adding additional tables to the query requires the above change
> because the multiple tables have the same field name.
>
> Re: B
> I only see one task with the word "Test" in task's name or description.
> Other fields are not being searched.
>
> Searching for "code" displays all records that have "code" in name or
> description.
> It seems to work OK, as all the tasks have "code" in the description.
>
> Konrad
>
>
>
>
> "Drew Byer" <byerd@markross.com> wrote in message
>news:ad5fnq$sq0$1@news.codecharge.com...
> > Page 28 of CCSTutorial_105.pdf states to view the working page and
> > A. sort by clicking on the column headers or
> > B. search by entering keyword.
> > ===============================
> >
> > A. - works for ID and Name
> > - semi works for Assigned To, meaning that they are almost entirely
> > placed in sort order, but for example "D" (David) and "P" (Pablo) come
> after
> > "R" (Rob)
> > - Project, Priority, and Status display the following error:
> > ------------------------
> > Source: Grid tasks
> > Error: The specified field 'project_id' could refer to more than one
table
> > listed in the FROM clause of your SQL statement. (Microsoft JET Database
> > Engine)
> > SELECT task_id, task_name, emp_name, priority_name, project_name,
> > status_name FROM (((tasks INNER JOIN priorities ON tasks.priority_id =
> > priorities.priority_id) INNER JOIN projects ON tasks.project_id =
> > projects.project_id) INNER JOIN statuses ON tasks.status_id =
> > statuses.status_id) INNER JOIN employees ON tasks.user_id_assign_to =
> > employees.emp_id ORDER BY project_id
> > -------------------------
> >
> > B. Search (at this step) does not funtion properly, based on records
> > displayed.
> > Samples:
> > - Current list of records displays 3 records that would include the word
> > "test", but the search results only display the one record that has
"test"
> > in the name field.
> > - Current list of records displays 5 records that would include the word
> > "code", but the search results displays ALL available records, including
> > ones that do not appearantly have the word "code" in any column.
> >
> > Bugs or what?
> >
> > Sincerely,
> > Drew
> >
> >
>
>
begin 666 DescOn.gif
M1TE&.#EA#0`)`+,.`"XQDJ6EI;Z^ON3DY+6UM:^OKZ:FIK"PL+N[NZFIJ?GY
M^<C(R+>WM_CX^,# P ```"'Y! $```X`+ `````-``D```0KT,E)J6HCZ[&.
D9$ HBH'@',%()HA4I&-@$*8+`S)=O?A<[X&$KC(1('Z." `[
`
end
|
|
|
|
CodeCharge Support
|
| Posted: 06/04/2002, 12:14 AM |
|
Hi Drew,
Re: A
I mentioned that you can change the Sort Order from "project_id" to
"tasks.project_id".
This will sort your tasks by the Project Id, not the Name.
But you can change the Sort Order to "project_name" and then your tasks
should be sorted by project's name.
Same applies to tasks.status_id vs. status_name.
Re: B
The point of implementing the Grid is not to display the descriptions, just
summary information.
The descriptions can be very large (it's a memo field and may not fit or not
be properly laid out on the page that is meant to display the list of tasks.
Therefore we are creating the Grid to show Tasks Names, and the Record form
to show Task Description and all other information.
The Application Builder automatically creates the Grid that can be searched
by any Text/Memo field, therefore both the Task Name and Description are
being searched.
If you do not want to search descriptions, go to the Data Source properties
of the Grid, and remove the parameter:
task_desc contains (like '%...%') '{s_keyword}'
Or if you want to display the description within the Grid, insert a new
column into the grid, and add a Label field from Toolbox -> Forms -> Label.
Then configure Label's properties to show the description.
Konrad
"Drew Byer" <byerd@markross.com> wrote in message
news:adg28v$oee$1@news.codecharge.com...
> Thanks, I appreciate the info for the changes. However, the results are
> not true.
>
> Section A:
> Yes, I no longer receive an error, but there still seems to be a problem
> with the records being sorted in the correct order. The example below was
> sorted by "Status", but as you can see "In Progress" comes before
"Closed",
> followed by "On Hold", then "Open". This same type of example appears in
> fields ("Project" and "User Assigned To") that are sorted:
>
> ======================
> Id Project Priority Status Name User Id Assign To
> 10 Super Project Highest In progress Code, code, code. Stefan
Fey
> 5 Test Project High In progress Test this project. Rob McDonald
> 3 CodeCharge High Closed Get ready to click David Snyder
> 12 Test Project Lowest On hold Sleep Rob McDonald
> 8 Test Project Highest On hold Get armed John Smith
> 15 Super Project Highest Open Have fun Li Jang
>
> ====================
>
> Section B:
> You state that the results displayed are based on the name or description
> fields. Well, my first question is:
> 1. Where is the description field and how can I make that visible?
>
> Sincerely,
> Drew Byer
>
>
>
>
>
>
> "CodeCharge Support" <support@codecharge.com> wrote in message
>news:ad7mhn$17s$1@news.codecharge.com...
> > Drew,
> >
> > Re: A
> > Thanks for spotting this error. The Tutorial will need to be updated
here
> as
> > well.
> > For now, please click on project column's heading/sorter and then in the
> > Data properties change Sort Order from "project_id" to
"tasks.project_id".
> > Repeat the same for all such columns.
> > This is needed because Power Wizard creates the Grid based on single
table
> > and database fields don't need to be fully qualified.
> > However, adding additional tables to the query requires the above change
> > because the multiple tables have the same field name.
> >
> > Re: B
> > I only see one task with the word "Test" in task's name or description.
> > Other fields are not being searched.
> >
> > Searching for "code" displays all records that have "code" in name or
> > description.
> > It seems to work OK, as all the tasks have "code" in the description.
> >
> > Konrad
> >
> >
> >
> >
> > "Drew Byer" <byerd@markross.com> wrote in message
> >news:ad5fnq$sq0$1@news.codecharge.com...
> > > Page 28 of CCSTutorial_105.pdf states to view the working page and
> > > A. sort by clicking on the column headers or
> > > B. search by entering keyword.
> > > ===============================
> > >
> > > A. - works for ID and Name
> > > - semi works for Assigned To, meaning that they are almost
entirely
> > > placed in sort order, but for example "D" (David) and "P" (Pablo) come
> > after
> > > "R" (Rob)
> > > - Project, Priority, and Status display the following error:
> > > ------------------------
> > > Source: Grid tasks
> > > Error: The specified field 'project_id' could refer to more than one
> table
> > > listed in the FROM clause of your SQL statement. (Microsoft JET
Database
> > > Engine)
> > > SELECT task_id, task_name, emp_name, priority_name, project_name,
> > > status_name FROM (((tasks INNER JOIN priorities ON tasks.priority_id =
> > > priorities.priority_id) INNER JOIN projects ON tasks.project_id =
> > > projects.project_id) INNER JOIN statuses ON tasks.status_id =
> > > statuses.status_id) INNER JOIN employees ON tasks.user_id_assign_to =
> > > employees.emp_id ORDER BY project_id
> > > -------------------------
> > >
> > > B. Search (at this step) does not funtion properly, based on records
> > > displayed.
> > > Samples:
> > > - Current list of records displays 3 records that would include the
word
> > > "test", but the search results only display the one record that has
> "test"
> > > in the name field.
> > > - Current list of records displays 5 records that would include the
word
> > > "code", but the search results displays ALL available records,
including
> > > ones that do not appearantly have the word "code" in any column.
> > >
> > > Bugs or what?
> > >
> > > Sincerely,
> > > Drew
> > >
> > >
> >
> >
>
>
>
|
|
|
|
|
