Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Code in report
Message
From
18/02/2008 14:12:46
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01293004
Message ID:
01293524
Views:
31
>>We tried the blob idea and after few months the memo file was already well over Gig in size. The current alternative has been to retrieve the text version (a string of hex numbers) and compression them before saving a memo field. This method reduced the size of the memo field usage by well over 90%. In one of our markets they have up to eight separate signatures per invoice.
>>
>>Having the Signature object recreate the signature bitmap take only about a tenth of a second, or less.
>
>Hi Greg,
>
>Thanks again for your explanation. Obviously I'm asking just out from curiosity (not working with VFP). But what if you need to print several signatures (multiple detail records with signatures). How exactly you're applying your technique in this case?

We have a ESign table that store a single signature per row, each having the invoice number and a item number. When the bitmap is written the item number a prefixed to the filename. Then there is a corresponding image control on the invoice. We do not have signatures on the detail band so it is not a problem with which bitmap is associated with which line item. But I am sure that with a little thought, even that could be achieved.
Greg Reichert
Previous
Reply
Map
View

Click here to load this message in the networking platform