Signed QR Code data

[newtofoxpro]

E-invoice. Signed QR Code data string is approx 900+ character. I am looking for best way to store/save in DBF free tables

Thanks in advance

 

[Mike Lewis]

You haven't really got a choice. For a 900-character string, you must store it in a memo field.

But I wonder if that it what you are really asking?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Chris Miller]

Depends on the nature of that string, not just the length. For example, VFP differentiates "memo" and "memo (binary)" and then later also introduced blob.

And you could also need another recommendation in case you need DBF access from Perl or Python via a module or lib for old DBF types on a Linux server. The free table format only compares to Fox 2.6 format in not having a DBC backlink in the header, but the old 2.6 format and the VFP3+ free table formats differ in more aspects.

Chriss

 

[herbstgy]

yeah, what is blob exactly?
I came from FoxPro 2.6 for DOS and not familiar with the concept.

 

[newtofoxpro]

Thank you all. I will try memo

 

[GriffMG]

You could break it into parts and avoid the memo (9 fields of 100 characters)

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Mike Lewis]

yeah, what is blob exactly?

It's a data type designed for storing long strings of binary data, such as images or audio data (the letters stand for binary large object). I wouldn't worry about them.

You said that your data consists of about 900 characters. If that's right, you can store it in a memo field. A memo field works in almost exactly the same way as a character field. So you can use REPLACE or INSERT to get the data into the field, and you can access the data just as you would a character field.

I'm simplifying this description slightly. There are some differences between character and memo data, and their internal storage is quite different. But you don't need to worry about any that for now.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads