Barry G. Sumpter
|
| Posted: 04/27/2002, 1:36 PM |
|
Hi all,
I worked thru the CCS Tutorial using the the database in
EmployeeDirectory.zip.
And everything worked exactly as the tutorial showed.
I then created:
New Page | Blank Page | Grid Wizard | Intranet Database (under
select a sample database) |
and continued on to create the same Search/Grid as the tutorial just
using the similar field names
from the Intranet Database as we used in the Tutorials Employees.mdb.
I conitnued to follow the Tutorial using the Intranet Database selecting
the listbox list contents,
Grids SQL, qualifying the Department_ID as Employees.Department_ID, and
changing the
control source for {Department_ID} and {Alt_Department_ID} to
departments.department_name.
Again the exact mods in the Tutorial - just using a different .mdb
Upon first test the Department column data is completely blank .
A bit of experimantation by changing the Source Type of {Department_ID}
to Database Expression.
No change in testing.
However, futher experimentation,
leaving Source Type as Database Expression,
and changing the Name of {Department_ID} to {Department_Name},
the {Department_Name} is NOW displaying the correct Department_Name.
But the {Alt_Department_ID} is still blank.
Even after changing the Name of {Alt_Department_ID} to
{Alt_Department_Name},
its still returning blanks.
Although this is just my first step in variations on the Tutorial I was
hoping someone has
stumbled upon this anomaly as well.
Any help, support, or encouragement would be sincerely apprecaited.
baz
|
|
|
 |
CodeCharge Support
|
| Posted: 04/27/2002, 9:59 PM |
|
Hi Barry,
Please let us know if you used the Visual Query feature in Grid's Data
Source to select multiple tables.
If so, you may need to check/select each field that you want to use in your
Grid.
If you don't select any fields, you will end up with fully qualified field
names like departments.department_name, but once you click on checkboxes in
Visual Query Builder, you will end up with "short" unqualified field names
like "department_name", which will work the way you want.
In the next few days we will be releasing an update where you will no longer
need to select each individual field in the query builder.
Konrad
"Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
news:aaf24o$4r5$1@news.codecharge.com...
> Hi all,
>
> I worked thru the CCS Tutorial using the the database in
> EmployeeDirectory.zip.
>
> And everything worked exactly as the tutorial showed.
>
> I then created:
> New Page | Blank Page | Grid Wizard | Intranet Database (under
> select a sample database) |
>
> and continued on to create the same Search/Grid as the tutorial just
> using the similar field names
> from the Intranet Database as we used in the Tutorials Employees.mdb.
>
> I conitnued to follow the Tutorial using the Intranet Database
selecting
> the listbox list contents,
> Grids SQL, qualifying the Department_ID as Employees.Department_ID,
and
> changing the
> control source for {Department_ID} and {Alt_Department_ID} to
> departments.department_name.
>
> Again the exact mods in the Tutorial - just using a different .mdb
>
> Upon first test the Department column data is completely blank .
>
> A bit of experimantation by changing the Source Type of
{Department_ID}
> to Database Expression.
> No change in testing.
>
> However, futher experimentation,
> leaving Source Type as Database Expression,
> and changing the Name of {Department_ID} to {Department_Name},
> the {Department_Name} is NOW displaying the correct Department_Name.
>
> But the {Alt_Department_ID} is still blank.
>
> Even after changing the Name of {Alt_Department_ID} to
> {Alt_Department_Name},
> its still returning blanks.
>
> Although this is just my first step in variations on the Tutorial I
was
> hoping someone has
> stumbled upon this anomaly as well.
>
> Any help, support, or encouragement would be sincerely apprecaited.
>
> baz
>
>
|
|
|
|
Barry G. Sumpter
|
| Posted: 04/28/2002, 3:24 AM |
|
Hi Konrad,
Yes I did use the Visual Query feature in the Grid's Data Source.
And I did select multiple tables.
Just like the tutorial.
Currently, by NOT selecting individual fields we retrieve ALL field
names. Qualified.
I believe this to be correct.
MSAccess reflects this with an * in the fields list.
If your intent on improving the field selection, might I suggest you
follow this convention?
I need fully qualified field names when using multiple tables which have
duplicate field names.
To distinguish between employees.Department_ID and
Departments.Department_ID.
However, if you're suggesting that we only need short unqualified UNIQUE
names
then cool. It will keep me from having to reselect each field name
after modifying the sql query
to include multiple tables.
For some reason I have selected the Group_ID for display as well.
And, in a desperate attempt, have modified the control source for
Group_ID and Alt_Group_ID to the Unqualified Department_Name.
And surprisingly this Unqualified field name works properly.
However, qualifying to Departments.Department_Name, leaves blanks again.
I hope I've clarified this anomaly well enough for you to make sence of.
I look forward to more updates.
Barry G. Sumpter
"CodeCharge Support" <support@codecharge.com> wrote in message
news:aafvjt$llv$1@news.codecharge.com...
> Hi Barry,
>
> Please let us know if you used the Visual Query feature in Grid's Data
> Source to select multiple tables.
> If so, you may need to check/select each field that you want to use in
your
> Grid.
> If you don't select any fields, you will end up with fully qualified field
> names like departments.department_name, but once you click on checkboxes
in
> Visual Query Builder, you will end up with "short" unqualified field names
> like "department_name", which will work the way you want.
> In the next few days we will be releasing an update where you will no
longer
> need to select each individual field in the query builder.
>
> Konrad
>
>
> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>news:aaf24o$4r5$1@news.codecharge.com...
> > Hi all,
> >
> > I worked thru the CCS Tutorial using the the database in
> > EmployeeDirectory.zip.
> >
> > And everything worked exactly as the tutorial showed.
> >
> > I then created:
> > New Page | Blank Page | Grid Wizard | Intranet Database (under
> > select a sample database) |
> >
> > and continued on to create the same Search/Grid as the tutorial just
> > using the similar field names
> > from the Intranet Database as we used in the Tutorials
Employees.mdb.
> >
> > I conitnued to follow the Tutorial using the Intranet Database
> selecting
> > the listbox list contents,
> > Grids SQL, qualifying the Department_ID as Employees.Department_ID,
> and
> > changing the
> > control source for {Department_ID} and {Alt_Department_ID} to
> > departments.department_name.
> >
> > Again the exact mods in the Tutorial - just using a different .mdb
> >
> > Upon first test the Department column data is completely blank .
> >
> > A bit of experimantation by changing the Source Type of
> {Department_ID}
> > to Database Expression.
> > No change in testing.
> >
> > However, futher experimentation,
> > leaving Source Type as Database Expression,
> > and changing the Name of {Department_ID} to {Department_Name},
> > the {Department_Name} is NOW displaying the correct Department_Name.
> >
> > But the {Alt_Department_ID} is still blank.
> >
> > Even after changing the Name of {Alt_Department_ID} to
> > {Alt_Department_Name},
> > its still returning blanks.
> >
> > Although this is just my first step in variations on the Tutorial I
> was
> > hoping someone has
> > stumbled upon this anomaly as well.
> >
> > Any help, support, or encouragement would be sincerely apprecaited.
> >
> > baz
> >
> >
>
>
|
|
|
|
Barry G. Sumpter
|
| Posted: 04/28/2002, 4:16 AM |
|
Hi Konrad,
Yep, you were spot on!
Thats what it was.
I have to select the individual fields in the Query Select.
Absolutely Brilliant!
baz
"CodeCharge Support" <support@codecharge.com> wrote in message
news:aafvjt$llv$1@news.codecharge.com...
> Hi Barry,
>
> Please let us know if you used the Visual Query feature in Grid's Data
> Source to select multiple tables.
> If so, you may need to check/select each field that you want to use in
your
> Grid.
> If you don't select any fields, you will end up with fully qualified field
> names like departments.department_name, but once you click on checkboxes
in
> Visual Query Builder, you will end up with "short" unqualified field names
> like "department_name", which will work the way you want.
> In the next few days we will be releasing an update where you will no
longer
> need to select each individual field in the query builder.
>
> Konrad
>
>
> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>news:aaf24o$4r5$1@news.codecharge.com...
> > Hi all,
> >
> > I worked thru the CCS Tutorial using the the database in
> > EmployeeDirectory.zip.
> >
> > And everything worked exactly as the tutorial showed.
> >
> > I then created:
> > New Page | Blank Page | Grid Wizard | Intranet Database (under
> > select a sample database) |
> >
> > and continued on to create the same Search/Grid as the tutorial just
> > using the similar field names
> > from the Intranet Database as we used in the Tutorials
Employees.mdb.
> >
> > I conitnued to follow the Tutorial using the Intranet Database
> selecting
> > the listbox list contents,
> > Grids SQL, qualifying the Department_ID as Employees.Department_ID,
> and
> > changing the
> > control source for {Department_ID} and {Alt_Department_ID} to
> > departments.department_name.
> >
> > Again the exact mods in the Tutorial - just using a different .mdb
> >
> > Upon first test the Department column data is completely blank .
> >
> > A bit of experimantation by changing the Source Type of
> {Department_ID}
> > to Database Expression.
> > No change in testing.
> >
> > However, futher experimentation,
> > leaving Source Type as Database Expression,
> > and changing the Name of {Department_ID} to {Department_Name},
> > the {Department_Name} is NOW displaying the correct Department_Name.
> >
> > But the {Alt_Department_ID} is still blank.
> >
> > Even after changing the Name of {Alt_Department_ID} to
> > {Alt_Department_Name},
> > its still returning blanks.
> >
> > Although this is just my first step in variations on the Tutorial I
> was
> > hoping someone has
> > stumbled upon this anomaly as well.
> >
> > Any help, support, or encouragement would be sincerely apprecaited.
> >
> > baz
> >
> >
>
>
|
|
|
|
PH
|
| Posted: 05/04/2002, 1:12 AM |
|
When I want to use a SQL Statement to fill a list box for use in a search
form, normally I like to use a UNION to fill the listbox to add a NULL
entry, so I'm not forced to use a value from the listbox for filtering the
grid.
What is the recommended way using list boxes populated with data from a
table to use in a search form? Normally they need to contain one empty value
and if this is selected the entry is not used for filtering the data.
Peter
"CodeCharge Support" <support@codecharge.com> schrieb im Newsbeitrag
news:aafvjt$llv$1@news.codecharge.com...
> Hi Barry,
>
> Please let us know if you used the Visual Query feature in Grid's Data
> Source to select multiple tables.
> If so, you may need to check/select each field that you want to use in
your
> Grid.
> If you don't select any fields, you will end up with fully qualified field
> names like departments.department_name, but once you click on checkboxes
in
> Visual Query Builder, you will end up with "short" unqualified field names
> like "department_name", which will work the way you want.
> In the next few days we will be releasing an update where you will no
longer
> need to select each individual field in the query builder.
>
> Konrad
>
>
> "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in message
>news:aaf24o$4r5$1@news.codecharge.com...
> > Hi all,
> >
> > I worked thru the CCS Tutorial using the the database in
> > EmployeeDirectory.zip.
> >
> > And everything worked exactly as the tutorial showed.
> >
> > I then created:
> > New Page | Blank Page | Grid Wizard | Intranet Database (under
> > select a sample database) |
> >
> > and continued on to create the same Search/Grid as the tutorial just
> > using the similar field names
> > from the Intranet Database as we used in the Tutorials
Employees.mdb.
> >
> > I conitnued to follow the Tutorial using the Intranet Database
> selecting
> > the listbox list contents,
> > Grids SQL, qualifying the Department_ID as Employees.Department_ID,
> and
> > changing the
> > control source for {Department_ID} and {Alt_Department_ID} to
> > departments.department_name.
> >
> > Again the exact mods in the Tutorial - just using a different .mdb
> >
> > Upon first test the Department column data is completely blank .
> >
> > A bit of experimantation by changing the Source Type of
> {Department_ID}
> > to Database Expression.
> > No change in testing.
> >
> > However, futher experimentation,
> > leaving Source Type as Database Expression,
> > and changing the Name of {Department_ID} to {Department_Name},
> > the {Department_Name} is NOW displaying the correct Department_Name.
> >
> > But the {Alt_Department_ID} is still blank.
> >
> > Even after changing the Name of {Alt_Department_ID} to
> > {Alt_Department_Name},
> > its still returning blanks.
> >
> > Although this is just my first step in variations on the Tutorial I
> was
> > hoping someone has
> > stumbled upon this anomaly as well.
> >
> > Any help, support, or encouragement would be sincerely apprecaited.
> >
> > baz
> >
> >
>
>
|
|
|
|
|
