Thanks everyone for all the input. At this point I my code scans through
multiple databases doing the following for several hundred tables:
- Loop through the original table to build a cursor with the memo fields
converted to character fields
- Build a header string with field names
[mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Wednesday, April 15, 2015 11:00 AM
To: profoxt...@leafe.com
Subject: Re: Data Dictionary questions
When there is a table that is part of a database (DBSTAFF) I can browse it
and it automatically opens the database and shows the long
: Wednesday, April 15, 2015 6:03 AM
To: profoxt...@leafe.com
Subject: Re: Data Dictionary questions
Joe,
have a look at AFIELDS() and COPY STRUCTURE EXTENDED ...
HTH
The Foxil
[excessive quoting removed by server]
___
Post Messages to: ProFox
flavors.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, April 15, 2015 11:00 AM
To: profoxt...@leafe.com
Subject: Re: Data Dictionary questions
When there is a table that is part of a database (DBSTAFF) I can browse
On Wed, Apr 15, 2015 at 9:31 AM, Joe Yoder j...@wheypower.com wrote:
The help so far has given me the tools to figure out how to create a
translation table but I still don't know what syntax to use when I want to
write an SQL Select specifying the fields I want using the long name form.
in the Fox to get you where you
want to go.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, April 15, 2015 11:36 AM
To: profoxt...@leafe.com
Subject: Re: Data Dictionary questions
Richard,
So I am concluding
When there is a table that is part of a database (DBSTAFF) I can browse it
and it automatically opens the database and shows the long field names as
headers. When I do a select * from DBSTAFF I get a cursor with the long
field names as headers. My question is What syntax do I use specify
specific
Joe Yoder wrote:
When there is a table that is part of a database (DBSTAFF) I can browse it
and it automatically opens the database and shows the long field names as
headers. When I do a select * from DBSTAFF I get a cursor with the long
field names as headers. My question is What syntax do I
Subject: Re: Data Dictionary questions
Joe,
have a look at AFIELDS() and COPY STRUCTURE EXTENDED ...
HTH
The Foxil
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman
] On Behalf Of Jean MAURICE
Sent: Wednesday, April 15, 2015 3:05 PM
To: profoxt...@leafe.com
Subject: Re: Data Dictionary questions
I wonder one thing : I have NEVER had problems with longfield names. Is'nt it
because of the space in the name that you have your problem ?
The Foxil
I wonder one thing : I have NEVER had problems with longfield names. Is'nt it
because of the space in the name that you have your problem ?
The Foxil
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
When there is a table that is part of a database (DBSTAFF) I can browse it
and it automatically opens the database and shows the long field names as
headers. When I do a select * from DBSTAFF I get a cursor with the long
field names as headers. My question is What syntax do I use specify
Open the database as a database (not a table) and use:
? DBGETPROP(table.fieldname, FIELD, Caption)
Laurie
On 15 April 2015 at 00:57, Joe Yoder j...@wheypower.com wrote:
I am needing to do some coding to manipulate data stored in tables that are
a part of a database.
I had assumed that one
Joe,
have a look at AFIELDS() and COPY STRUCTURE EXTENDED ...
HTH
The Foxil
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
+1
On 15/04/2015 14:43, Laurie Alvey wrote:
Open the database as a database (not a table) and use:
? DBGETPROP(table.fieldname, FIELD, Caption)
Laurie
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
ADBOBJECTS() can also be useful.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean MAURICE
Sent: Wednesday, April 15, 2015 6:03 AM
To: profoxt...@leafe.com
Subject: Re: Data Dictionary questions
Joe,
have a look at AFIELDS() and COPY
I am needing to do some coding to manipulate data stored in tables that are
a part of a database.
I had assumed that one can open the DBC as a table and get access to the
long field names but when I tried it I found only some of the long field
names embedded in the property memo field. Can
17 matches
Mail list logo