Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by almcnicoll
-
INSERT INTO from SELECT Values
Mike, are you trying to insert into mo_DTL the values you're selecting from mo_old? IF so, you need to run those two statements into one. I'd be tempted to do it with some VB but if you need to do it with pure SQL you could try: INSERT INTO mo_DTL (field1,field2,field3,...) VALUES (SELECT...- almcnicoll
- Post #4
- Forum: Microsoft: FoxPro
-
How to control and get data from TreeView Control
Hi castor, I can't find the help file for download anywhere either! Meantime, I've been mucking with the TreeView control a fair bit in VBA. To answer your questions: 1a. To reference any node by its key, use myTreeViewCtrl.Nodes("myKey") 1b. To select that node, use...- almcnicoll
- Post #4
- Forum: Microsoft: FoxPro
