Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append General
Message
From
07/07/2008 06:04:35
 
 
To
07/07/2008 05:49: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:
01329339
Views:
11
This message has been marked as a message which has helped to the initial question of the thread.
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
Next
Reply
Map
View

Click here to load this message in the networking platform