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

Down

What is this mistake? Capability not suppoted Find similar branches


SklifF   (2001-12-04 15:59) [0]

begin
sql.clear;
sql.add ("select (mod (((sum (Tel." Hour ") * 3600 + sum (Tel." Min ") * 60 + sum (Sec))), 60)) as sec_time from" Tel.db "Tel");
sql.add ("where Tel.Telephon Like" 8% "and Tel.Nomber =" + # 39 + ComboBox1.Items [ComboBox1.ItemIndex] + # 39);
Open;
ComboBox1.SetFocus;
end;
At performance of this code such error gets out
most likely because of the mod? and then how to correctly insert functions in SQL



Val   (2001-12-04 16:47) [1]

if they are not in SQL, then apply when processing the result already obtained



Dick Gonsales   (2001-12-04 21:50) [2]

The MOD () function does not support my
one ODBC or Naivy driver. It is supported by SQL server
at home. Here you probably will be easier to use
in TDBGird calculated fields and there already do MOD ()



Pages: 1 whole branch

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

Top









Memory: 0.81 MB
Time: 0.036 c
1-22129
Aleksandr
2001-12-19 16:04
2002.01.08
How to remove the flicker of your scrollbar?


3-21979
MAXMEM
2001-12-06 13:21
2002.01.08
DBTreeView


1-22099
Yulyashka
2001-12-19 17:43
2002.01.08
Question about DBGrid !!


1-22197
T2
2001-12-16 07:17
2002.01.08
Is it possible to programmatically disable the Windows basket?


1-22264
Anatoly
2001-12-17 06:36
2002.01.08
Chart





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 Español swahili Swedish thai turkish Ukrainian urdu vietnamese 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