Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert
Message
 
To
31/05/2005 04:55:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01018623
Message ID:
01018628
Views:
21
O, now I understand :o))
CREATE TABLE NewTable FREE (NEWQ C(10))

SELECT YourTableWithQfieldnames
nCntFields = AFIELDS(aFlds)
FOR nCnt = 1 TO nCntFields
    IF LOWER(LEFT(aFlds[nCnt,1])) == "q"
       INSERT INTO NewTable VALUES (aFlds[nCnt,1])
    ENDIF
NEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform