V9 - Use of UD tables

Yahoo Archive
1
One other note on this, if you're concerned about performance (you've got a
UD table with large number of records), you can always add an index.



Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Wednesday, February 16, 2011 11:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V9 - Use of UD tables





I use the key fields to make each row unique. If by chance the value I
need to link to another table is a character field, then it works out
great. Just use one of the Key fields.

If it is not a character field, then a store the value in one of the
user defined fields, like Number01, and use that field to link to a
table.

There is no requirement that forces you to only use indexed fields when
joining tables. You can use any field you want. The issue is that as
your data grows, there might be a performance hit.

Depending on the value of the functionality you gain, it may outweigh
the performance hit.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Keith Mailloux
Sent: Wednesday, February 16, 2011 11:19 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V9 - Use of UD tables

We have an application for the use of UD tables and I have a question.
The 5 "Key" fields provided are all character fields. Thus all indexes
provided are based on character data. I have a need to index on a
numeric (integer) field. We will be using crystal and BAQ's with the
data that resides in this UD Table(child table) so we cannot create
joins to the table as our parent table linking field is an integer
value. Anyone address this yet?

Thanks,

Keith Mailloux
Ferguson Perforating
(401)941-8876

---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
We have an application for the use of UD tables and I have a question. The 5 "Key" fields provided are all character fields. Thus all indexes provided are based on character data. I have a need to index on a numeric (integer) field. We will be using crystal and BAQ's with the data that resides in this UD Table(child table) so we cannot create joins to the table as our parent table linking field is an integer value. Anyone address this yet?

Thanks,


Keith Mailloux
Ferguson Perforating
(401)941-8876


---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
3
We replicate the Key we want to be numberic in one of the Number0X fields,
for Instacne if Key1 is to be numeric we insert it in Key1 and Number01 and
then on the BAQ we use the criteria set to join the tables.
Hope this helps.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Feb 16, 2011 at 11:19 AM, Keith Mailloux <
keith.mailloux@...> wrote:

>
>
> We have an application for the use of UD tables and I have a question. The
> 5 "Key" fields provided are all character fields. Thus all indexes provided
> are based on character data. I have a need to index on a numeric (integer)
> field. We will be using crystal and BAQ's with the data that resides in this
> UD Table(child table) so we cannot create joins to the table as our parent
> table linking field is an integer value. Anyone address this yet?
>
> Thanks,
>
> Keith Mailloux
> Ferguson Perforating
> (401)941-8876
>
> ---------------------------------
> This e-mail and any attachments may contain confidential and
> privileged information. If you are not the intended recipient,
> please notify the sender immediately by return e-mail, delete this
> e-mail and destroy any copies. Any dissemination or use of this
> information by a person other than the intended recipient is
> unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
4
I use the key fields to make each row unique. If by chance the value I
need to link to another table is a character field, then it works out
great. Just use one of the Key fields.

If it is not a character field, then a store the value in one of the
user defined fields, like Number01, and use that field to link to a
table.



There is no requirement that forces you to only use indexed fields when
joining tables. You can use any field you want. The issue is that as
your data grows, there might be a performance hit.

Depending on the value of the functionality you gain, it may outweigh
the performance hit.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Wednesday, February 16, 2011 11:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V9 - Use of UD tables





We have an application for the use of UD tables and I have a question.
The 5 "Key" fields provided are all character fields. Thus all indexes
provided are based on character data. I have a need to index on a
numeric (integer) field. We will be using crystal and BAQ's with the
data that resides in this UD Table(child table) so we cannot create
joins to the table as our parent table linking field is an integer
value. Anyone address this yet?

Thanks,

Keith Mailloux
Ferguson Perforating
(401)941-8876

---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]