wwdatagrid Wont load
-
sorry for the duplicate post..
I have a demo of firepower. I am attracted for the DataAware aspects. I have a fire monkey app, dropped a grid on the form, with BindSourceDB, which is attached to a query (Unidac).. If inside the IDE, I switch the active property of the query to true, I see data on my grid, no problem.. But if I run my app, run the query, I see nothing on my grid. I have confirmed that there is data in my dataset, Tried refreshing my grid.. Nothing.. Im sure Im doing something dumb..
-
I would be tempted to leave the datagrid as it is, but add another one that points to the same datasource to see if that one shows records. (the configuration of the datagrid will not be the same but the idea is just to see if it shows any records.
If it does, then I'd examine the FMX file and make a text copy of the original datagrid and use that information to configure the new datagrid. You could paste into the FMX file but that might just replicate the problem. If it does, then you could delete that datagrid and add another fresh one, and this time just add the parameter changes to configure it to match the first one.
If the 2nd datagrid works, you could just move it in to replace the original but I'd also try to look at the FMX file to see how the parameters are different from the text I had saved from the first one.
-
I guess you don't have the option of trying FireDAC but you've already tried with a memtable. If the DB is MS SQL Server I suppose you could try dbGo (ADO) just for a test. I suppose if it were me, I'd be doing this testing in a stand-alone/single-purpose app to speed up testing. Having such an app might make it easier for Roy to replicate your tests.
-
OK, I got it to work.. If I put the source and query in DataModule.. It wont work .. If I put them on the same form as the grid, it works as it should. I am not at all strong in live bindings..but I suspect that its something there.. It just cant bind if its not on the same form? I would hate to think that I have to put my db components on my working forms. My whole reason for wanting these compoents is to NOT have to learn live bindings.. They seem like a lot of work for simple things. I have never gotten the hang of them. Hence your components.
Ideas?
-
You still have not told me the questions I asked.
What version of FirePower are you using? It should not be that difficult. Could you email us one of your projects that is not working? Also what database type are you using? SQLite, etc
Not sure of your problem then without looking at a project. You could try using your form's OnShow event and calling the method RefreshGrid to see if that helps..
-
Also I recommend trying to see if you can reproduce without using 3rd party back-ends that I won't be able to connect to. Try copying your unidac dataset to a TClientDatasSet at design time (Right Click TClientDataSet and select Assign Local Data). Then connect your grid to that to see if it still fails. Then I don't need to have your server to run your projct.
-
Yes, I tried to put a TKBMMemTable and a FDMemTable i the Datamodule..Then Loaded it from my query.. Same issue.. BUT, if I put any of these components on my Grid form, all is well. So, I dont think its a compat issue with the datasets.. None of them work on the DataModule.. ALL of them work if I move them into the grid form.. . In the IDE designtime, it works fine.. Its at runtime it fails. So weird.
-
You can send them to support@woll2woll.com
-
Gordon, thanks for the project.
Unfortunately your demo is using 3rd party components which I do not have, so I am not able to run your project. However in your project, your auto-created forms you have the data module in there twice so you would be creating two instances of it. You should not have two instances and this could be contributing to your problems.
Look at your list of auto-created forms and you can see what I mean.
Please sign in to leave a comment.
Comments
26 comments