Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set defa to
Message
From
21/11/2004 06:26:11
 
 
To
21/11/2004 06:23:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00963220
Message ID:
00963300
Views:
9
Yes, I suspected that aar was not a part of the path, but only the file name. :-)

>hi,
>thank you,it works as under,
>
>
>set defa to e:\bills1\bills1
>thisform.text1.Value='aar'
>LOCAL lcTableName
>lcTableName = thisform.text2.value
>CREATE TABLE (lcTableName) (a C(50), b C(70),c C(50), d C(50),e C(70), f C(70),s C(70), l C(70),char9 c(70), char10 c(40),;
>char11 C(10), char12 C(60),char13 C(50), char14 C(40),char15 C(10), char16 C(10),char17 C(10), char18 C(70),char19 C(10),;
>char20 C(10),char21 C(10), char22 C(40),char23 C(10), char24 C(10),char25 C(10), char26 C(70),char27 C(10), char28 C(10) NOCPTRANS)&& you put ; before NOCPTRANS get error message.
>lcTableName = thisform.text1.value
>APPEND FROM (lcTableName) TYPE XLS
>*** USE (thisform.text2.value) exclusive ALIAS SomeAlias && Not necessary, this table is already selected
>GO TOP
>DELETE NEXT 6
>
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform