Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Thought process
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01658136
Message ID:
01658281
Views:
72
>>I don't know why it is not working for you.
>>Here author's eMail (it is public) -> praisach at yahoo dot com
>
>This is the code I tried in his TestEmpty.prg:
>
>
>use in select('csrItems')
>create cursor csrItems (Department C(10), Category C(10), item C(10), descrip varchar(100), MatrixItem C(3), ;
>	MatrixTemplate varchar(20), GLNumber varchar(12), UserDefined varchar(12), Help_Info M, ;
>	Barcode varchar(20), UPC varchar(20), ;
>	LabelLayout varchar(100), DirectPricing C(3), Price n(12,4), DynamicPriceRule C(10), ;
>	PriceCalculationType C(1), AddTax C(3), ;
>	Tax_Rate C(1), Tax_Rate_B C(1), Vendor1 varchar(25), Vendor2 varchar(25), VendorPartNumber varchar(20), ReorderPoint n(8,2), ;
>	TargetQty n(8,2), ProfitCenter varchar(15), UserDefinedText1 varchar(50), UserDefinedText2 varchar(50), ;
>	subclass C(10), Season C(20))
>
>=appendfromxlsx(GETFILE('xlxs'),,,2,"Items",.T.)
>BROWSE
>
>The HelpInfo column is empty in the worksheet. All columns come empty after that column.

Maybe he just skipped the empty columns.
You should debug the code.
I use IMPORTfromXLSX and I remember that I fixed that bug there, but kill me I don't remember where.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform