Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving records Table to Table
Message
 
 
To
22/08/2000 10:29:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00407737
Message ID:
00407741
Views:
18
>INSERT INTO tablename(Orig_lata, Term_lata, Bill_dur);
> VALUE (temp.Orig_lata, temp.Term_lata,temp.Bill_dur)
>
>
>I'm using this code to bring information into a table from a temp table with same format....It works if I put the actual tablename in the code, but I want to be able to choose that path each time. What can I use as a generic tablename???
>Kelly
>
>


You can use Name Expression in INSERT statment
lcTableName = "MyTable"
INSERT INTO (lcTableName) (Orig_lata, Term_lata, Bill_dur);
	VALUE (temp.Orig_lata, temp.Term_lata,temp.Bill_dur)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform