sla8a писал(а):
Подскажите кто знает как вывести номер строки по порядку при SELECTЭто имелось в виду?
Add(MainForm,5487311,140,112)
{
Width=584
Height=344
Caption="Тест с нумерацией"
Position=1
link(onCreate,11171972:doOpen,[])
}
Add(StrList,3068266,294,70)
{
Strings=#13:Петров;Москва|12:Иванов;Минск|12:Сидоров;Киев|13:Смирнов;Киров|14:Малевич;Сидней|
Point(doGetIndex)
Point(onGetIndex)
}
Add(Button,9912960,133,238)
{
Left=105
Top=270
TabOrder=-1
Caption="Select"
Data=Integer(0)
link(onClick,11037579:doEvent1,[])
}
Add(DS_SQLite,11171972,196,126)
{
Name="bd"
FileName=":memory:"
link(onOpen,7933638:doExec,[])
}
Add(DSC_Exec,7933638,245,126)
{
SQL="CREATE TABLE [myTable](\r\n [name] text, \r\n [city] text);"
DSManager="bd"
link(onExec,924678:doEnum,[])
}
Add(DSC_Query,9807701,231,245)
{
SQL="SELECT\r\n ROWID as 'номер_по_порядку',\r\n name,\r\n city\r\nFROM\r\n myTable;\r\n "
DSManager="bd"
link(onQuery,15038004:doAddRow,[])
link(onColumns,15038004:doAddCols,[])
}
Add(DSC_Exec,13859579,469,112)
{
DSManager="bd"
}
Add(MT_String,9368895,371,112)
{
link(onResult,653926:doString,[])
}
Add(FormatStr,653926,420,112)
{
Mask="INSERT\r\nINTO [myTable](\r\n [name], \r\n [city])\r\nVALUES('%1','%2'); \r\n"
link(onFString,13859579:doExec,[])
}
Add(MTStrTbl,9589444,350,245)
{
Left=5
Top=40
Width=510
Height=220
Name="asd"
}
Add(MST_DB,15038004,287,245)
{
MSTControl="asd"
}
Add(MST_Clear,5644650,231,203)
{
ClearAll=0
MSTControl="asd"
}
Add(Hub,11037579,189,238)
{
OutCount=3
link(onEvent1,5644650:doClear,[(214,244)(214,209)])
link(onEvent2,9807701:doQuery,[])
link(onEvent3,5774788:doColAction,[(221,258)(221,293)])
}
Add(MST_ColAction,5774788,231,287)
{
Action=11
Index=-2
MSTControl="asd"
}
Add(ArrayEnum,924678,308,126)
{
link(onItem,9368895:doMTString,[])
link(Array,3068266:Array,[])
}
--- Добавлено в 2025-02-18 16:32:51
sla8a, или даже так.
Add(MainForm,5487311,252,147)
{
Width=584
Height=344
Caption="Тест с нумерацией"
Position=1
link(onCreate,11171972:doOpen,[])
}
Add(StrList,3068266,406,105)
{
Strings=#13:Петров;Москва|12:Иванов;Минск|12:Сидоров;Киев|13:Смирнов;Киров|14:Малевич;Сидней|
Point(doGetIndex)
Point(onGetIndex)
}
Add(Button,9912960,245,273)
{
Left=105
Top=270
TabOrder=-1
Caption="Select"
Data=Integer(0)
link(onClick,11037579:doEvent1,[])
}
Add(DS_SQLite,11171972,308,161)
{
Name="bd"
FileName=":memory:"
link(onOpen,7933638:doExec,[])
}
Add(DSC_Exec,7933638,357,161)
{
SQL="CREATE TABLE [myTable](\r\n [name] text, \r\n [city] text);"
DSManager="bd"
link(onExec,924678:doEnum,[])
}
Add(DSC_Query,9807701,343,280)
{
SQL="SELECT\r\n ROW_NUMBER () OVER (ORDER BY '' ) RowNum,\r\n name,\r\n city\r\nFROM\r\n myTable;\r\n "
DSManager="bd"
link(onQuery,15038004:doAddRow,[])
link(onColumns,15038004:doAddCols,[])
}
Add(DSC_Exec,13859579,581,147)
{
DSManager="bd"
}
Add(MT_String,9368895,483,147)
{
link(onResult,653926:doString,[])
}
Add(FormatStr,653926,532,147)
{
Mask="INSERT\r\nINTO [myTable](\r\n [name], \r\n [city])\r\nVALUES('%1','%2'); \r\n"
link(onFString,13859579:doExec,[])
}
Add(MTStrTbl,9589444,462,280)
{
Left=5
Top=40
Width=510
Height=220
Name="asd"
}
Add(MST_DB,15038004,399,280)
{
MSTControl="asd"
}
Add(MST_Clear,5644650,343,238)
{
ClearAll=0
MSTControl="asd"
}
Add(Hub,11037579,301,273)
{
OutCount=3
link(onEvent1,5644650:doClear,[(326,279)(326,244)])
link(onEvent2,9807701:doQuery,[])
link(onEvent3,5774788:doColAction,[(333,293)(333,328)])
}
Add(MST_ColAction,5774788,343,322)
{
Action=11
Index=-2
MSTControl="asd"
}
Add(ArrayEnum,924678,420,161)
{
link(onItem,9368895:doMTString,[])
link(Array,3068266:Array,[])
}