Could very much use a Field List

Posted by Bud Izen on November 2, 2006, 2:44 am

Please log in for more thread options

I apologize if this is out there already, but it seems that at least a few
field names changed from 1.2 to 1.3. Although I had downloaded a field list
before, from here, I cannot even find that original post, let alone any more
recent that might contain the correct field names.

I need to do some custom SQL and would prefer not to reinvent the wheel.

Thanks in advance very much to anyone who could help.

Bud Izen
Salem Oregon

Posted by Mickie on November 2, 2006, 9:00 am

Please log in for more thread options

Do you have MS Access? Make a new project and attach to the database as
your data source.

You will be able to see all the tables and the field names. It has been
a great thing to have!

Bud Izen wrote:

> I apologize if this is out there already, but it seems that at least a few

> field names changed from 1.2 to 1.3. Although I had downloaded a field list

> before, from here, I cannot even find that original post, let alone any more

> recent that might contain the correct field names.

> I need to do some custom SQL and would prefer not to reinvent the wheel.

> Thanks in advance very much to anyone who could help.

> Bud Izen

> Salem Oregon

Posted by Bud Izen on November 2, 2006, 12:24 pm

Please log in for more thread options

What a good idea. I will try that later this morning. Thanks a bunch!

Bud

"Mickie" wrote:

> Do you have MS Access? Make a new project and attach to the database as

> your data source.

> You will be able to see all the tables and the field names. It has been

> a great thing to have!

> Bud Izen wrote:

> > I apologize if this is out there already, but it seems that at least a few

> > field names changed from 1.2 to 1.3. Although I had downloaded a field list

> > before, from here, I cannot even find that original post, let alone any more

> > recent that might contain the correct field names.

> >

> > I need to do some custom SQL and would prefer not to reinvent the wheel.

> >

> > Thanks in advance very much to anyone who could help.

> >

> > Bud Izen

> > Salem Oregon

Posted by Jeff @ Check Point Software on November 2, 2006, 5:35 pm

Please log in for more thread options

: quoted-printable

Bud,

As far as I know, none of the fields have changed in at least 3 years.

Here's a link to the schema of both SO and HQ.
http://tinyurl.com/nao8m

Must have access to CustomerSource

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

What a good idea. I will try that later this morning. Thanks a bunch!

Bud

"Mickie" wrote:

> Do you have MS Access? Make a new project and attach to the database =
as=20
> your data source.
>=20
> You will be able to see all the tables and the field names. It has =
been=20
> a great thing to have!
>=20
>=20
> Bud Izen wrote:
> > I apologize if this is out there already, but it seems that at =
least a few=20
> > field names changed from 1.2 to 1.3. Although I had downloaded a =
field list=20
> > before, from here, I cannot even find that original post, let =
alone any more=20
> > recent that might contain the correct field names.
> >=20
> > I need to do some custom SQL and would prefer not to reinvent the =
wheel.
> >=20
> > Thanks in advance very much to anyone who could help.
> >=20
> > Bud Izen
> > Salem Oregon
>
------=_NextPart_000_0256_01C6FE8C.326E16F0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Bud,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>As far as I know, none of the fields have =
changed in at=20
least 3 years.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Here's a link to the schema of both SO and=20
HQ.</FONT></DIV>
<DIV><FONT color=3D#008000><A=20
href=3D"http://tinyurl.com/nao8m">http://tinyurl.com/nao8m</A></FONT></DI=
V>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Must have access to =
CustomerSource</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Bud Izen" <<A=20
=
rosoft.com</A>>=20
wrote in message <A=20
=
508CA-717E-4399-8516-91D6EBA990C1@microsoft.com</A>...</DIV>What=20
a good idea. I will try that later this morning. Thanks a=20
bunch!<BR><BR>Bud<BR><BR>"Mickie" wrote:<BR><BR>> Do you have MS =
Access?=20
Make a new project and attach to the database as <BR>> your data=20
source.<BR>> <BR>> You will be able to see all the tables and =
the field=20
names.  It has been <BR>> a great thing to have!<BR>> =
<BR>>=20
<BR>> Bud Izen wrote:<BR>> > I apologize if this is out there =

already, but it seems that at least a few <BR>> > field names =
changed=20
from 1.2 to 1.3. Although I had downloaded a field list <BR>> > =
before,=20
from here, I cannot even find that original post, let alone any more =
<BR>>=20
> recent that might contain the correct field names.<BR>> > =
<BR>>=20
> I need to do some custom SQL and would prefer not to reinvent the =

wheel.<BR>> > <BR>> > Thanks in advance very much to =
anyone who=20
could help.<BR>> > <BR>> > Bud Izen<BR>> > Salem=20
Oregon<BR>></BLOCKQUOTE></BODY></HTML>

------=

Posted by hozay on November 2, 2006, 9:36 am

Please log in for more thread options

or use this DbaMgr2 it will also give you a good look at the fields

"Bud Izen" wrote:

> I apologize if this is out there already, but it seems that at least a few

> field names changed from 1.2 to 1.3. Although I had downloaded a field list

> before, from here, I cannot even find that original post, let alone any more

> recent that might contain the correct field names.

> I need to do some custom SQL and would prefer not to reinvent the wheel.

> Thanks in advance very much to anyone who could help.

> Bud Izen

> Salem Oregon