vfp9 Select * Command field name in correct
Hi experts
I have a table called customer and it has field email_offer
when i use the following
select * from customer into table temp
when I open table temp it has field
email_offe
r is missing of that field.
Please help
I have a table called customer and it has field email_offer
when i use the following
select * from customer into table temp
when I open table temp it has field
email_offe
r is missing of that field.
Please help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
my table customer is part of a dbc
when I copy it to cursor like
select * from customer into cursor test
it is ok. it does have full field name
but when I copy it to a table
select * from customer into table temp
all the field name are 10 character.
Please help
when I copy it to cursor like
select * from customer into cursor test
it is ok. it does have full field name
but when I copy it to a table
select * from customer into table temp
all the field name are 10 character.
Please help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See "How to: Name Fields" in vfp help
So if your customer table was inside the DBC the query would show the long file names