The problem with MEMO

[Victorio]

Hi,

What content is in "Memo" field ? Is there text in cyrillic ?, or umlauts (hmm in russian do not remember if has some, )

this may have nothing to do with the problem which I had severeal months when want convert CSV file from tasklist to array. I had this problem on france installation of Windows 10, where some special france umlauts/accents caused incorretly read fields from CSV to array. I must ignore first row in CSV and put own row of CSV structure to solution.

Also once I had problem with test type of fields type M , Memo in DBF file created in Foxpro, some function worked in Foxpro but in Alaska Xbase no. Here I read info about two type of Memo M4 a M10 , this is new info for me.

[Eugene Lutsenko]

Hi,

What content is in "Memo" field ? Is there text in cyrillic ?, or umlauts (hmm in russian do not remember if has some, )

this may have nothing to do with the problem which I had severeal months when want convert CSV file from tasklist to array. I had this problem on france installation of Windows 10, where some special france umlauts/accents caused incorretly read fields from CSV to array. I must ignore first row in CSV and put own row of CSV structure to solution.

Also once I had problem with test type of fields type M , Memo in DBF file created in Foxpro, some function worked in Foxpro but in Alaska Xbase no. Here I read info about two type of Memo M4 a M10 , this is new info for me.

I have in a memo-field the usual text consisting only of symbols of parentheses, a comma and figures: (),0123456789. That's all. There are no breaks between ends of lines, ends of paragraphs, etc. Just by the length of this text, the usual text boxes do not always fit. An example is here at the bottom of the images: http://aidos.byethost6.com/ClustClass/page_01.htm

[Eugene Lutsenko]

I have a suspicion that with "C" works but "M" does not work due to the fact that "M" work wrong sort (indexed arrays) and filter. It is possible that logical sorting (indexing) when"M" violates the correctness of the correspondence between the order of records in dbf and dbt

[Piotr D]

Hello Eugen,
in DbeSys.PRG what type of COMPONENT_ORDER you use?
Try this:
IF ! DbeLoad( "FOXDBE", .T.)
Alert( "Motor bazy danych FOXDBE nie został załadowany" , {"OK"} )
ENDIF

IF ! DbeLoad( "CDXDBE",.T.)
Alert( "Motor bazy danych CDXDBE nie został załadowany" , {"OK"} )
ENDIF

IF ! DbeBuild( "FOXCDX", "FOXDBE", "CDXDBE" )
Alert( "FOXCDX - motor bazy danych nie został utworzony" , {"OK"} )
ENDIF
DbeInfo(COMPONENT_ORDER,CDXDBE_MODE,CDXDBE_COMIX)

Without this, typically, the mode is like in Visual FoxPro, where Collation table is in CDX file, and this make problem with sorting (indexing) when database is non-english standard.

Piotr

[Eugene Lutsenko]

Thanks, Peter!

Definitely try. I was thinking about whether it was in CDX. I had another option: just make a text file out of lines with links to them by line numbers from the main file from the field that is now used from the text. But now the regime is working well (on limited dimensions of data) and I'll get back to it when you re-mount any other urgent cases

http://aidos.byethost6.com/ClustClass/page_01.htm

[bwolfsohn]

Eugene,

did you say you had an index on this field when it was a "C" ? if so, then that might be the problem... I don't think you can have a straight index on a Memo field

[Auge_Ohr]

you can make an Index on Type "M" but ist must be same Lengh

Code: Select all

INDEX ON SUBSTR(Field->Memo + SPACE(xxx),1,xxx) TO myIndex

Note xxx :
DBFNTX max. 512 bytes
CDXDBE is limited to 240 bytes but when have Collation Table you can use only 120 byte

If collation is ASCII or CDXDBE_MODE is FOXPRO2X, no transformation occurs and the key-value size is restricted to 240 characters.

---

@Eugene : i understand that you change Structure Field Type from "C" to "M"
next you create a new DBF but this is empty so where do your data come from ?

the Picture on page 1 show {} so it is a Array ... but you write it as String into DBF ?
to use it did you convert String back to Array ?

if YES : store Array as binary into Field Type "V" !

[Eugene Lutsenko]

Why-it is a memo field it works correctly, but the text all right:

Code: Select all

IF AT(ALLTRIM(aClust1[cl]), ALLTRIM(NAMECLS_FU)) > 0                            // Почему-то с мемо-полем это не работает ####################

[Auge_Ohr]

Why-it is a memo field it works correctly, but the text all right:

Code: Select all

IF AT(ALLTRIM(aClust1[cl]), ALLTRIM(NAMECLS_FU)) > 0                            // Почему-то с мемо-полем это не работает ####################

it seems that nobody can confirm what you have so there must be something you have not tell us until now.
if it is a Array you can store hole Array as i say but than you must use Type "V" and re-work your Code.

Tip : make a small Demo and look it if still happens

[Eugene Lutsenko]

The system Eidos can be downloaded here:
http://lc.kubagro.ru/aidos/_Aidos-X.htm

It is downloaded from the source code. But separately it is possible to download here:
http://lc.kubagro.ru/_AIDOS-X.txt

The text is the one I compile. The only thing I will not publish license codes for libraries Boris

Look for the function: FUNCTION F4_2_2_3()

There the elements of the array is just an object to search for (text). Search is carried out in the memo field