•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Pascal and Delphi section within the Software Development category of DaniWeb, a massive community of 426,501 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,208 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Pascal and Delphi advertiser: Programming Forums
Views: 1456 | Replies: 12
 |
•
•
Join Date: Mar 2008
Posts: 18
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thanks for the last post. I've extended the logging and noticed, that something have messed up the dataset's navigation:
(Well, the numbers are not in order, I've used the 1st database I've found, and the last error's translation is the same that you get by setting the filter to 0=1. )
It's so easy, and I would have never tought, that my code doesn't work, because one of it's command doesn't work. Now I really have enough from this.
I'll send the data back to the server, and rerequest it with aother querry every time when I show a field on a visual control... I'm still not proud of it, but at least now I know why I have to.
Calling: 01.30 | level=1 -Processing: 01.30 --beforenext: 01.30 Calling: 01.29 | level=2 OnCalcField event recall handled, returning: 01.29 --afternext: 01.29 --afterprior: 01.29 Returning: 01.29 Calling: 01.28 | level=1 -Processing: 01.28 --beforenext: 01.28 --afternext: 01.28 --afterprior: 01.28 Returning: 01.28 Calling: 01.27 | level=1 -Processing: 01.27 --beforenext: 01.27 --afternext: 01.27 --afterprior: 01.27 Returning: 01.27 Calling: 01.26 | level=1 -Processing: 01.26 --beforenext: 01.26 --afternext: 01.26 --afterprior: 01.26 Returning: 01.26 Calling: 01.06 | level=1 -Processing: 01.06 --beforenext: 01.06 --afternext: 01.06 --afterprior: 01.06 Returning: 01.06 Calling: 01.07 | level=1 -Processing: 01.07 --beforenext: 01.07 --afternext: 01.07 --afterprior: 01.07 Returning: 01.07 Calling: 01.08 | level=1 -Processing: 01.08 --beforenext: 01.08 --afternext: 01.08 --afterprior: 01.08 Returning: 01.08 !Error at DS position = 01.25: Az argumentumok nem megfelelő típusúak, az érvényes tartományon kívül esnek vagy ellentmondásosak
It's so easy, and I would have never tought, that my code doesn't work, because one of it's command doesn't work. Now I really have enough from this.
I'll send the data back to the server, and rerequest it with aother querry every time when I show a field on a visual control... I'm still not proud of it, but at least now I know why I have to.
Last edited by MoZo1 : May 13th, 2008 at 5:21 am.
•
•
Join Date: Jun 2006
Location: Blumenau, Brazil
Posts: 71
Reputation:
Rep Power: 3
Solved Threads: 4
Junior Poster in Training
•
•
•
•
Originally Posted by MoZo1 
I'll send the data back to the server, and rerequest it with aother querry every time when I show a field on a visual control...
There is some options:
- use an other query with calculated fields and OnCalcFields event, if you using DBGrid ;
- use join in SQL, if your data is only to be read;
- use an other query to show complementary data in others data controls, by using OnDataChange event from DataSource;
...
Bye
"It always has, at least, two ways to make one same thing. Exactly that they are certain and wrong"(Micheus)
Brazil - Blumenau
Brazil - Blumenau
•
•
Join Date: Mar 2008
Posts: 18
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by Micheus
There is some options:
1 - use an other query with calculated fields and OnCalcFields event, if you using DBGrid ;
2 - use join in SQL, if your data is only to be read;
3 - use an other query to show complementary data in others data controls, by using OnDataChange event from DataSource;
...
Bye
1: I mayl do this. I'll have to check how my transactions are affecting this. As much I can remember, there is some setting calles "isolation" or something associated with this... I'll google it...
2: Not only I have to write, but I would like to show changes instantly. I could join the data the calculation needs, but that wouldn't be the sollution to show changes instantly. Moreover it would be troublesome to reload it and then reset everything for the user to not notice. Reloading another read-only dataset, or sending a querry is more easy, and consumes max the same or less CPU.
3: Another cool idea. I just have to separate the calculation from the oncalc event. I can't give more reputation today... Then I'll use a memory array (or steam) instead of another visual control, to save the calculation there, EnableControls only when it's fully ready, then read this from the OnCalc event.
+1: Instead of 3, if I can, I make a persistent field, and set it to not send back to the server, maybe I can save data there, and the dataset could access it naturally. It will save me from a lot of typing. I know, I'm about to hack again, bad habit...
Anyway, see you later. The main topic have been solved, that was the point, thanks again!
Last edited by MoZo1 : May 13th, 2008 at 7:17 am.
|
•
•
•
•
•
•
•
•
DaniWeb Pascal and Delphi Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Other Threads in the Pascal and Delphi Forum
- Previous Thread: using method or dereferenced object pointer
- Next Thread: txt files in pascal
