Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2004.12.12;
Download: [xml.tar.bz2];

Down

I can not make a query on the calculated field Find similar branches


Megabyte ©   (2004-11-14 13:35) [0]

Subject TTable has a calculated field. Fields 3 through 15 are numbers.
Depending on the user's choice, the sum of the selected fields is recorded in the calculated field (3% 15). Everything calculates normally, the sum is displayed in DBGrid, but this is not important. So I wrote to discard possible unnecessary questions.

When I make a query through TQuery from TTable, where I want to see the Calculated Sum_needed field.
They write to me: "Invalid field name Sum_needed".
Naturally, I checked the spelling of the field name 10 times. :)
Requests for data fields from this table pass normally.

Because the calculated field is calculated at runtime, then I tried to make a dynamic query. The same garbage.

The same garbage from with other calculated fields from other tables.
By computed field it is NOT possible to make a request? Or what I do not understand?
Help...



Anatoly Podgoretsky ©   (2004-11-14 13:54) [1]

Once again, how is TQuery from TTable



KSergey ©   (2004-11-14 14:03) [2]

> By computed field DO NOT make a request?

Yes.
For a request, the database engine is sent. Computed fields exist only in the client application with the brain power of the DataSet.



DrPass ©   (2004-11-14 14:41) [3]


> Or what I do not understand?

Do not understand. Did you look at the matrix? "Actually the spoon does not exist."
The calculated field also does not exist - it is created at the TDataSet level. But if your database engine allows you to create calculated fields in the database using its native tools, create them there - then it will work



Johnmen ©   (2004-11-14 16:15) [4]

In the query itself, the calculated field.



Megabyte ©   (2004-11-15 20:22) [5]

Hm. Those. I can not extract information from the calculated field of the table?

In general, I will have to find the maximum in the calculated field (more precisely, the 3 maximum numbers, but it doesn’t matter).

In the Paradox, in my opinion, this is not:
> But if your database engine allows you to create calculated fields
> in the database using her native tools, create them there-then
> will work



Johnmen ©   (2004-11-15 23:01) [6]

A few questions...
1. What database?
2. What do you mean by field? Field in the table, in the query or in the ND?
3. What exactly is the question?



Megabyte ©   (2004-11-16 00:38) [7]

And there is no way to extract Old from the calculated field? :(


> But if your database engine allows you to create calculated fields
> in the database using her native tools, create them there-then
> will work

My field summarizes in the general case always different fields at the user's choice.



sniknik ©   (2004-11-16 00:48) [8]

> And there is no way to extract Old from the calculated field? :(
get together and try to answer even so even if the questions seem meaningless to you.

> 1. What database?
> 2. What do you mean by field? Field in the table, in the query or in the ND?
> 3. What exactly is the question?

> My field summarizes in the general case always different fields at the user's choice.
hmm ... then I guess where it is calculated from you ... in connection with this there is still a question that is not original at all; o).
> Once again, how is TQuery from TTable
??? show very interesting.



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2004.12.12;
Download: [xml.tar.bz2];

Top





Memory: 0.57 MB
Time: 0.06 c
11-1084133815
Alex ^
2004-05-10 00:16
2004.12.12
Component list


3-1100089389
Term
2004-11-10 15:23
2004.12.12
QReport how to make a subtotal in the report


14-1100855778
WondeRu
2004-11-19 12:16
2004.12.12
Something from the army VS. Graduate School


3-1100069354
first_may
2004-11-10 09:49
2004.12.12
Mistake...


3-1100006041
eugene32
2004-11-09 16:14
2004.12.12
IBQuery. Open v potoke: kak ubit potok vo vremia raboti Open?





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic Indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish ภาษาไทย turkish Ukrainian urdu Tiếng Việt welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish