Hi Peter:
Thanks for the detailed posts -- you seem to be on top of it now hihi. I haven't read thru all this closely but will do so. I am glad to see someone getting into the internals of LOGic.
I can't say why the deleted showed up on top without seeing the data. Anyway,
Quote:FIELD_NAME + IIF(FIELD_TYPE="I", PADL(TRIM(VALUE),LEN(VALUE)), VALUE)
just varies the index expression based on whether the field is integer or not. If it is integer, it left-pads the value (or right-justifies in other words). This is so that 2 will come on top of 10 for instance.
There is nothing preventing you from setting up an integer value and entering a character value I suspect the incorrect ordering had something to do with this. The integer values are actually stored in a character field of course. I will add an edit to the Lists screen to check this, but of course this will not prevent importing "bad" data.
As for upper/lower case, if you are using Descr for anything other than something for a human to read, I would make it all upper-case. Go to tools/advanced/database commands. Type:
USE LISTS
REPLACE DESCR WITH UPPER(DESCR) FOR FIELD_NAME="JCC "
But there is a DELETED field -- may as well use it.
I use the free OpenOffice Calc for massaging data, then save as tab-delimited (you can do the same with Excel). Getting the tab-delimited into LOGic is trivial. Go to tools/advanced/database commands. Type:
USE LISTS
APPEND FROM yourfile.txt DELIMITED WITH TAB
to go the other way, type:
COPY TO d:\tmp\jcg.txt FOR FIELD_NAME = "JCG " DELIMITED WITH TAB WITH ""
Click for info on the screwy syntax if you care.
If you just did WITH TAB, it would export with quotes around the values and tabs between values:
"JCG"{tab}"123"
WITH "" tells it to not put anything around the values:
JCG{tab}123
"" is an empty character expression of course
I have had several requests to add generic import to the Lists and Memberships table like the Log has. I think that would be worthwhile.
BTW, if you want to share your tables, feel free to upload them here!
Tnx & 73,
Dennis WN4AZY