Re: Copying genbral fields

[Stefan Wuebbe]

"ahmjamil" <ahmj...@discussions.microsoft.com> wrote in message
news:23E4A1C9-70AB-49D8...@microsoft.com...
>I have a table (in a database) and I have to edit it (thousands of
>records).
> I am creating a new table to contain edited fields. But how do I copy the
> General Field records to this new table? I use a VFP 8.
Hi,
You can for example:
CREATE CURSOR temp (gTest G)
APPEND BLANK
APPEND GENERAL gTest FROM GETFILE()

SELECT * FROM temp INTO CURSOR temp2

CREATE CURSOR temp3 (gTest G)
INSERT INTO temp3 (gTest) SELECT gtest FROM temp

However, "general fields" are somewhat difficult to use, many people
including the MS VFP team meanwhile recommend to use BLOB fields
(or binary memos) instead:
http://groups.google.com/groups/search?q=general+fields+recommended+group%3A*fox*&safe=off

hth
-Stefan

--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------