Int3g3r Posted October 8, 2020 Share 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 Link to comment Share on other sites More sharing options...
Sherzod Posted October 8, 2020 Share 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? Link to comment Share on other sites More sharing options...
x11 Posted October 8, 2020 Share 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 Link to comment Share on other sites More sharing options...
Int3g3r Posted October 8, 2020 Author Share 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 ? Link to comment Share on other sites More sharing options...
Sherzod Posted October 8, 2020 Share Posted October 8, 2020 38 minutes ago, Int3g3r said: So you want a example, or what do you mean with this ? Yes, the example. Link to comment Share on other sites More sharing options...
Int3g3r Posted October 8, 2020 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts