Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append General
Message
From
07/07/2008 07:16:51
 
 
To
07/07/2008 06:04:35
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01329337
Message ID:
01329354
Views:
10
Hi Tore,
You are right :) FROM (tcExcelFile).. the brakets are important :)

>I always advice against general fields, but I know that in some cases you must use them. Anyway, I have two comments:
>1. You don't need to Select a table after creating it, it will automatically be selected after it has been created.
>2. APPEND GENERAL excelfile FROM (tcExcelFile) ?
>
>>Hi,
>>I try to create template table and append general field to use excel features inside foxpro form.
>>And... it does not work for me.. the General fields always stay blank
>>What do I wrong?
>>
>>
>>	PROCEDURE OpenExcelFile
>>	LPARAMETERS tcExcelFile
>>	LOCAL lcTmpTable as String
>>	LOCAL lcTmpAlias as String
>>	lcTmpTable = ADDBS(SYS(2023))+SYS(2015)
>>	CREATE TABLE (lcTmpTable) FREE (excelfile G)
>>	lcTmpAlias = JUSTSTEM(lcTmpTable)
>>	SELECT(lcTmpAlias)
>>	APPEND BLANK
>>	APPEND GENERAL excelfile FROM tcExcelFile
>>*!*        BROWSE
>>	Thisform.oleObject.ControlSource = ALLTRIM(lcTmpAlias)+".excelfile"
>>	THisform.Refresh()
>>	ENDPROC
>>
>>
>>When I made BROWSE... I can see.. General field still empty.
>>File exist on the disk 100% :)
>>
>>Thanks
>>Denis
Previous
Reply
Map
View

Click here to load this message in the networking platform