Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field
Message
From
20/09/2005 11:10:14
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/09/2005 10:51:25
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01051285
Message ID:
01051316
Views:
12
Tore,
It doesn't matter much in this case. Storing such redundant data in a memo field is already bloated from the start:)
Cetin

>My point is that you should only have ONE replace command, not a lot like in your sample. In a multiuser envirionment VFP will allocate a new memory block for each replace, if you do it your way, causing memo bloat.
>mPocReciept="20-09-2004 Cashier: Bob" +CHR(13)+CHR(10)
>mPocReceipt=mPocReceipt + "Pizza..........1x 8.00 =  8.00" +CHR(13)+CHR(10)
>mPocReceipt=mPocReceipt + "Topping....1x 1.00 =  1.00" +CHR(13)+CHR(10)
>Replace PocReceipt with mPocReceicpt
>
>>>>
>>This is one of many ways to get his POC data into a memo field. Bloat, well that has to be watched, but he seemed to want all the Point of Sale information in the memo field. You will have to deal with bloat.
>>
>>>Are you giving crash courses in how to create memo bloat? :-)
>>>
>>>Try to minimize the number of replaces in a memo field!
>>>
>>>>If the memo field is called lets say PocReceipt, then you could say:
>>>>
>>>>REPLACE PocReceipt WITH PocReceipt + "20-09-2004 Cashier: Bob
>>>>" +CHR(13)+CHR(10)
>>>>REPLACE PocReceipt WITH PocReceipt + "Pizza..........1x 8.00 = 8.00" +CHR(13)+CHR(10)
>>>>REPLACE PocReceipt WITH PocReceipt + "Topping....1x 1.00 = 1.00" +CHR(13)+CHR(10)
>>>>
>>>>
>>>>etc...
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform