Int3g3r Posted October 8, 2020 Posted October 8, 2020 Hello, I'm using TIBC Components on all other projects so far. www.devart.com/ibdac/ It's the first time that i'm trying to make a Firebird Database Connection in UniguiMobile. So i did the same thing as always. 1) Created a Datamodule 2) Placed TIBCConnection, TIBCQuery and a TIBCDatasource 3) Connected it to a UnimDBGrid. 4) Data gets Displayed without any trouble. Now i need to search in this Grid. I created a new SQL Query Statement like follow: dmMain.qryAIs.SQL.Text := 'select * from ais WHERE ais.AIS_NAME CONTAINING '+QuotedStr(edtSearch.Text); dmMain.qryAIs.Execute This code gets executed and the UnimDBGrid displays "Loading". The loading screen doesn't disappear. I waited for 20 Seconds. The table has 100 records in it so it sould be finished for sure. My Question: a) Is UniguiMobile compatible with IBDAC ? b) Why does the "Loading" screen not dissappear ? c) Is there any example with a real database ? (The UniGuiDemos don't connect to a real database so i don't know how to setup TClientDataset) Regards, Interger
Sherzod Posted October 8, 2020 Posted October 8, 2020 2 minutes ago, Int3g3r said: 1) Created a Datamodule 2) Placed TIBCConnection, TIBCQuery and a TIBCDatasource 3) Connected it to a UnimDBGrid. 4) Data gets Displayed without any trouble. Now i need to search in this Grid. I created a new SQL Query Statement like follow: dmMain.qryAIs.SQL.Text := 'select * from ais WHERE ais.AIS_NAME CONTAINING '+QuotedStr(edtSearch.Text); dmMain.qryAIs.Execute This code gets executed and the UnimDBGrid displays "Loading". The loading screen doesn't disappear. I waited for 20 Seconds. The table has 100 records in it so it sould be finished for sure. Hello, Can you make a simple app?
x11 Posted October 8, 2020 Posted October 8, 2020 I use UniDAC (DevArt). There are no big problems. But there are problems with infinite scrolling in Smart Load mode 1
Int3g3r Posted October 8, 2020 Author Posted October 8, 2020 5 minutes ago, x11 said: But there are problems with infinite scrolling in Smart Load mode Disabled infinite scroll and it works now .... 11 minutes ago, Sherzod said: Can you make a simple app? So you want a example, or what do you mean with this ?
Sherzod Posted October 8, 2020 Posted October 8, 2020 38 minutes ago, Int3g3r said: So you want a example, or what do you mean with this ? Yes, the example.
Int3g3r Posted October 8, 2020 Author Posted October 8, 2020 See attachment for the exampleApp. I've encountered two bugs. - TUnimDBGrid -> stuck at "loading" if i use "infiniteScroll". - TUnimLabel -> overlaps to the window form. You need to install Firebird 2.5 for the example to work. The setup is included. Regards, Int3g3r UniGuiDBApp.zip
Recommended Posts