Вверх ↑
Этот топик читают: Гость
Ответов: 35
Рейтинг: 0
#1: 2024-02-11 06:25:58 ЛС | профиль | цитата
как сделать ограничить поиск по столбцу есть 2 столбца номер и дата
при попытке поиска он ищёт везде в примере номер 024 но проблемма что дата 2024 но так как поиск везде он берёт и выделяет не то что мне нужно

Add(MainForm,2953706,609,350)
{
Width=474
Height=408
link(onCreate,6046155:doWork1,[])
}
Add(StringTableMT,5499133,749,364)
{
Left=215
Top=15
Width=220
Height=335
Columns=#13:номер =100 =1|12:дата =100 =2|
MultiSelect=0
IconsCheck=[]
MiscIcons=[]
Icons=[]
Point(ExtCmp)
Point(StrLst)
Point(EndEdit)
Point(LFileExists_MT)
Point(SFileExists_MT)
Point(IListFileName)
Point(IconsFileName)
Point(IconFileName)
Point(StrLstFName)
Point(FileName)
Point(FStream)
Point(FTblStream)
Point(StringTable)
Point(AllCheck_MT)
Point(AllSelect_MT)
Point(GenColors_MT)
Point(ImgSize)
Point(IconArray)
Point(ColumnArray)
Point(CheckBoxes)
Point(SelectArray)
Point(StrLstArray)
Point(Strings)
Point(TextStrLst)
Point(FullTextTab)
Point(EndIdxCol)
Point(EndIdxStrLst)
Point(EndIdxIcons)
Point(EndIdx)
Point(CountIcons)
Point(CountCol)
Point(CountStrLst)
Point(Matrix)
Point(ItemAtPos)
Point(PerPage)
Point(TopItem)
Point(SubItem)
Point(Index)
Point(Cell)
Point(onMT_CellClick)
Point(onMT_FindText)
Point(onMT_Check)
Point(onMT_EMatrix)
Point(onMT_GetColors)
Point(onMT_GetCol)
Point(onGetIconIdx)
Point(onExtIcon)
Point(onGetMiscIcon)
Point(onGetIcon)
Point(onGetStrList)
Point(onLineChange)
Point(onBeforeLineChange)
Point(onChangeColLst)
Point(onChangeImgLst)
Point(onChangeStrLst)
Point(onChange)
Point(onEscCell)
Point(onColumnClick)
Point(onSelect)
Point(doEndEdit)
Point(doGetColors_MT)
Point(doMT_FindNext)
Point(doGetCol_MT)
Point(doMT_FindText)
Point(doMT_LoadExtIcon)
Point(doMT_ReplaceIcon)
Point(doMT_InsertIcon)
Point(doMT_CheckBox)
Point(doMT_ColorsStr)
Point(doMT_SelEMatrix)
Point(doMT_ChkEMatrix)
Point(doMT_IconCol)
Point(doMT_EMatrix)
Point(doMT_IconStr)
Point(doMT_ImageCol)
Point(doMT_AlignTxtCol)
Point(doMT_WidthCol)
Point(doMT_NameCol)
Point(doMT_ReplaceCol)
Point(doMT_InsertCol)
Point(doMT_Replace)
Point(doMT_Insert)
Point(doMT_AddCols)
Point(doMT_Add)
Point(doRefresh)
Point(doSaveFStream)
Point(doLoadFStream)
Point(doSaveIList)
Point(doLoadIList)
Point(doLoadPakIcons)
Point(doSaveIcon)
Point(doLoadIcon)
Point(doTblStrLst)
Point(doSortStrLst)
Point(doGetStrList)
Point(doAddTextStrLst)
Point(doTextStrLst)
Point(doInsertStrLst)
Point(doAppendStrFile)
Point(doSaveStrLst)
Point(doLoadStrLst)
Point(doDeleteStrLst)
Point(doClearStrLst)
Point(doAddStrLst)
Point(doDeleteCol)
Point(doClearCol)
Point(doGetMiscIcon)
Point(doGetIconIdx)
Point(doGetIcon)
Point(doDeleteIcon)
Point(doClearIcons)
Point(doAutoColWidth)
Point(doInitTxtTab)
Point(doEnsureVisible)
Point(doSelEndStr)
Point(doSelect)
Point(doSortExtCmp)
Point(doSortDigit)
Point(doSort)
Point(doAddColumn)
Point(doReplace)
Point(doInsert)
Point(HeightControls)
Point(WidthControls)
Point(MouseY)
Point(MouseX)
Point(Top)
Point(Left)
Point(Height)
Point(Width)
Point(PHandle)
Point(Handle)
Point(onMouseEnter)
Point(onMouseLeave)
Point(onSplitUp)
Point(onKillFocus)
Point(onSetFocus)
Point(onDblClick)
Point(onPaint)
Point(onMove)
Point(onMouseWheel)
Point(onMouseUp)
Point(onMouseMove)
Point(onMouseDown)
Point(onResize)
Point(onHide)
Point(onShow)
Point(onChar)
Point(onKeyDown)
Point(onKeyUp)
}
Add(Edit,12176395,672,420)
{
Left=15
Top=70
Width=125
Text=""
MaxLenField=3
link(onEnter,5499133:doMT_FindText,[])
}
Add(MultiElement,6046155,672,364)
{
link(onEvent1,5499133:doAdd,[])
}
BEGIN_SDK
Add(EditMulti,13554181,21,21)
{
EventCount=1
WorkCount=1
Width=262
Height=225
link(doWork1,2349744:doTimer,[(63,27)(63,69)])
}
Add(FormatStr,7792619,154,70)
{
DataCount=0
Mask="245;2024"
link(onFString,5020440:doEvent1,[(194,76)(194,118)])
}
Add(FormatStr,5278433,154,105)
{
DataCount=0
Mask="567;2024"
link(onFString,5020440:doEvent2,[(194,111)(194,125)])
}
Add(FormatStr,9568085,154,140)
{
DataCount=0
Mask="024;2024"
link(onFString,5020440:doEvent3,[(194,146)(194,132)])
}
Add(FormatStr,15217098,154,175)
{
DataCount=0
Mask="856;2024"
link(onFString,5020440:doEvent4,[(194,181)(194,139)])
}
Add(Hub,5020440,203,112)
{
InCount=4
OutCount=1
link(onEvent1,13554181:onEvent1,[(250,118)(250,27)])
}
Add(Timer,2349744,70,63)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,14932434:doEvent1,[])
}
Add(Timer,11296269,70,105)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,8366962:doEvent1,[])
}
Add(Hub,14932434,112,63)
{
link(onEvent1,7792619:doString,[(140,69)(140,76)])
link(onEvent2,11296269:doTimer,[(138,76)(138,94)(58,94)(58,111)])
}
Add(Hub,8366962,112,105)
{
link(onEvent1,5278433:doString,[])
link(onEvent2,4707685:doTimer,[(138,118)(138,136)(58,136)(58,153)])
}
Add(Timer,4707685,70,147)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,11751497:doEvent1,[])
}
Add(Hub,11751497,119,147)
{
link(onEvent1,9568085:doString,[(143,153)(143,146)])
link(onEvent2,11572336:doTimer,[(145,160)(145,178)(58,178)(58,195)])
}
Add(Timer,11572336,70,189)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,15217098:doString,[(128,195)(128,181)])
}
END_SDK

карма: 0

0
Ответов: 771
Рейтинг: 168
#2: 2024-02-11 07:50:10 ЛС | профиль | цитата
prostov писал(а):
как сделать ограничить поиск по столбцу

Совет: не использовать StringTableMT и не выкладывать таких "монстров".
StringTableMT

Add(MainForm,2198646,147,42)
{
Width=474
Height=408
link(onCreate,6046155:doWork1,[])
}
Add(StringTableMT,5499133,427,56)
{
Left=215
Top=15
Width=220
Height=335
Columns=#13:номер =100 =1|12:дата =100 =2|
SelectFind=1
MultiSelect=0
IconsCheck=[]
MiscIcons=[]
Icons=[]
Point(Matrix)
Point(onMT_EMatrix)
Point(doMT_EMatrix)
Point(doSelect)
link(onMT_EMatrix,3972635:doEnum,[])
}
Add(Edit,12176395,140,147)
{
Left=15
Top=70
Width=125
Text=""
MaxLenField=3
link(onChange,1783433:doStrCatDlm,[])
}
Add(MultiElement,6046155,210,56)
{
link(onEvent1,5499133:doAdd,[])
}
BEGIN_SDK
Add(EditMulti,13554181,21,21)
{
EventCount=1
WorkCount=1
Width=262
Height=225
link(doWork1,2349744:doTimer,[(63,27)(63,69)])
}
Add(FormatStr,7792619,154,70)
{
DataCount=0
Mask="245;2024"
link(onFString,5020440:doEvent1,[(194,76)(194,118)])
}
Add(FormatStr,5278433,154,105)
{
DataCount=0
Mask="567;2024"
link(onFString,5020440:doEvent2,[(194,111)(194,125)])
}
Add(FormatStr,9568085,154,140)
{
DataCount=0
Mask="024;2024"
link(onFString,5020440:doEvent3,[(194,146)(194,132)])
}
Add(FormatStr,15217098,154,175)
{
DataCount=0
Mask="856;2024"
link(onFString,5020440:doEvent4,[(194,181)(194,139)])
}
Add(Hub,5020440,203,112)
{
InCount=4
OutCount=1
link(onEvent1,13554181:onEvent1,[(250,118)(250,27)])
}
Add(Timer,2349744,70,63)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,14932434:doEvent1,[])
}
Add(Timer,11296269,70,105)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,8366962:doEvent1,[])
}
Add(Hub,14932434,112,63)
{
link(onEvent1,7792619:doString,[(140,69)(140,76)])
link(onEvent2,11296269:doTimer,[(138,76)(138,94)(58,94)(58,111)])
}
Add(Hub,8366962,112,105)
{
link(onEvent1,5278433:doString,[])
link(onEvent2,4707685:doTimer,[(138,118)(138,136)(58,136)(58,153)])
}
Add(Timer,4707685,70,147)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,11751497:doEvent1,[])
}
Add(Hub,11751497,119,147)
{
link(onEvent1,9568085:doString,[(143,153)(143,146)])
link(onEvent2,11572336:doTimer,[(145,160)(145,178)(58,178)(58,195)])
}
Add(Timer,11572336,70,189)
{
Interval=250
Enable=1
AutoStop=1
link(onTimer,15217098:doString,[(128,195)(128,181)])
}
END_SDK
Add(StrCatDelim,1783433,196,147)
{
Str1="*"
Str2="*"
Point(Delimiter)
link(onStrCatDlm,8234581:doEvent1,[])
}
Add(Hub,8234581,259,147)
{
OutCount=3
link(onEvent1,50476:doMask,[(529,153)(529,76)])
link(onEvent2,10068618:doData,[])
link(onEvent3,13277034:doString,[(284,167)(284,97)])
}
Add(FormatStr,13277034,315,91)
{
Mask="0;-1"
link(onFString,2316602:doMTString,[])
}
Add(MT_String,2316602,364,77)
{
link(onResult,5499133:doMT_EMatrix,[])
}
Add(MT_Enum,3972635,490,63)
{
link(onItem,50476:doCompare,[])
}
Add(StrMask,50476,567,63)
{
Point(doMask)
link(onTrue,13688491:doData,[])
}
Add(DoData,13688491,630,70)
{
link(onEventData,3613696:doWork1,[(669,76)(669,111)])
link(Data,3972635:Index,[(636,61)(622,61)(622,103)(503,103)])
}
Add(DoData,10068618,364,154)
{
Data=Integer(100000)
link(onEventData,3613696:doWork3,[(417,160)])
}
Add(HubEx,3613696,413,105)
{
Angle=3
link(onEvent,5499133:doSelect,[(417,90)])
}

MTStrTbl

Add(Label,5887663,322,21)
{
Width=592
Height=50
Align=2
Caption=""
AutoSize=1
}
Add(MainForm,1495570,70,70)
{
Width=608
Height=479
link(onCreate,27875:doConvert,[])
}
Add(MST_Matrix,16359836,350,168)
{
Y=-1
MSTControl="MTStrTbl"
link(onEMatrix,3972635:doEnum,[])
link(X,2488760:Index,[])
}
Add(Label,21375,371,21)
{
Left=295
Top=15
Width=51
Height=17
Font=[MS Sans Serif,10,0,0,1]
Caption="Искать"
}
Add(Edit,16767801,175,203)
{
Left=361
Top=15
Width=95
Hint="* - любые символы, ? - один любой символ, # - одна любая цифра"
Text=""
DataType=2
link(onChange,1783433:doStrCatDlm,[])
}
Add(Label,11759952,420,21)
{
Left=35
Top=15
Width=71
Height=20
Font=[MS Sans Serif,10,0,0,1]
Caption="В столбце"
}
Add(MT_Enum,3972635,399,168)
{
link(onItem,50476:doCompare,[])
}
Add(StrList,3013988,119,35)
{
Strings=#42:Артикул;Название;Кол-во;Ед.изм.;Цена;Сумма|56:23544122;Carbon disc ?44,7/38,3x5,8mm;10;PC;16,92;169,20|56:23544122;Carbon disc ?44,7/38,3x5,8mm;10;PC;16,92;169,20|54:23544122;Carbon disc ?44,7/38,3x5,8mm;2;PC;16,92;33,84|64:21200159;Top part UNIFL3/4 for steel bot.part;25;PC;30,09;752,25|57:24400111;Hose f. pump compl. UNIWASH;153;PC;10,58;1618,74|58:13225;Piston complete for valve UNIWASH3;4;PC;27,09;108,36|60:12200105;Vacuumgauge glycerine ?100mm 3/8";5;PC;40,57;202,85|54:21200141;Thread bush UNIFLOW3 steel;130;PC;1,93;250,90|45:25100146;O-ring ?16,1x1,6mm;175;PC;0,36;63,00|57:21200127;Holder rocking lever, UNIFLOW3;170;PC;0,26;44,20|50:21200131;Rocking lever UNIFLOW3;150;PC;0,89;133,50|65:25200132;Valve button inside UNIFLOW3 steel FA;225;PC;0,72;162,00|61:21200129;Bar closing device UNIFLOW3 steel;225;PC;1,09;245,25|55:25200124;Valve flap outside UNIFLOW3;225;PC;1,56;351,00|60:14400212;Solenoid valve sgl. invensys 230vac;5;PC;8,50;42,50|62:14400213;Solenoid valve dobb. invensys 230vac;5;PC;14,13;70,65|48:21200131;Rocking lever UNIFLOW3;20;PC;0,89;17,80|63:25200132;Valve button inside UNIFLOW3 steel FA;20;PC;0,72;14,40|43:25100146;O-ring ?16,1x1,6mm;20;PC;0,36;7,20|55:21200127;Holder rocking lever, UNIFLOW3;20;PC;0,26;5,20|58:21200130;Bar closing device UNIFLOW3 steel;20;PC;0,34;6,80|58:25200119;Guard bracket UNIFLOW3 steel SBS;20;PC;3,38;67,60|55:13474;Valve flap exterior UNIFLOW3 SBS;20;PC;1,56;31,20|59:26400104;Terminal wheel for lock guide str;20;PC;1,12;22,40|67:25215022;Rubber liner UNIFL. 15022-?22 UNIFLEX FA;96;PC;2,39;229,44|55:14800695;Hose guide f. SAC115 complete;10;PC;9,17;91,70|36:14306;Filter for IDC;20;PC;0,40;8,00|51:25515435;Rubber hose ?27/16 mm - FA;15;M;5,24;78,60|63:13930;Double-action Quickstart II rem. L=740mm;1;PC;98,66;98,66|54:13100201;Spray gun for udder washer;20;PC;17,77;355,40|0:|
}
Add(StreamConvertor,27875,119,84)
{
Mode=7
Point(Data)
link(onResult,5630780:doLoadFromStream,[])
link(Data,3013988:Text,[])
}
Add(MST_Load,5630780,168,77)
{
MSTControl="MTStrTbl"
link(onLoadFromStream,12754267:doEnum,[])
}
Add(MST_ArrayCols,7373423,224,28)
{
MSTControl="MTStrTbl"
}
Add(ArrayEnum,12754267,224,84)
{
link(onItem,2505676:doSplit,[])
link(onEndEnum,14674062:doColAction,[(270,97)(270,132)])
link(Array,7373423:ColumnArray,[])
}
Add(ComboBox,2488760,336,91)
{
Left=130
Top=15
Width=120
Height=21
Text="Выбрать столбец"
Point(Index)
}
Add(StrPart,2505676,280,84)
{
Char="="
link(onPart,2488760:doAdd,[])
}
Add(MST_ColAction,14674062,280,126)
{
Action=9
Index=-2
MSTControl="MTStrTbl"
}
Add(StrMask,50476,455,168)
{
Point(doMask)
link(onTrue,9148446:doSelect,[])
}
Add(Hub,8234581,280,203)
{
OutCount=4
link(onEvent1,16002373:doClear,[(319,209)(319,335)])
link(onEvent2,50476:doMask,[(438,216)(438,181)])
link(onEvent3,9148446:doSelectOut,[(494,223)(494,188)])
link(onEvent4,16359836:doEMatrix,[(305,230)(305,174)])
}
Add(StrCatDelim,1783433,224,203)
{
Str1="*"
Str2="*"
Point(Delimiter)
link(onStrCatDlm,8234581:doEvent1,[])
}
Add(MTStrTbl,4593529,154,294)
{
Top=50
Width=592
Height=285
Align=5
Name="MTStrTbl"
MultiSelect=0
Point(onSelect)
link(onSelect,7642424:doRead,[])
}
Add(MST_SelectRow,9148446,511,175)
{
MSTControl="MTStrTbl"
Point(IndexSelect)
Point(doSelectOut)
link(IndexSelect,3972635:Index,[(517,166)(503,166)(503,208)(412,208)])
}
Add(Memo,16002373,336,322)
{
Top=335
Width=592
Height=105
Align=4
ScrollBars=3
}
Add(MT_String,2989942,266,322)
{
link(onResult,16002373:doAdd,[])
}
Add(MST_ArrayRows,5333737,210,266)
{
MSTControl="MTStrTbl"
}
Add(MT_MTArrayRW,7642424,210,322)
{
link(onRead,2989942:doStr,[])
link(Array,5333737:Strings,[])
}

карма: 15

1
Голосовали:prostov
Ответов: 35
Рейтинг: 0
#3: 2024-02-11 12:16:39 ЛС | профиль | цитата
спасибо
Gunta писал(а):

Совет: не использовать StringTableMT и не выкладывать таких "монстров".

|
извините я не знал что такой монстр может навредить.
карма: 0

0
3
Сообщение
...
Прикрепленные файлы
(файлы не залиты)