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.54 MB
Time: 0.02 c
7-22442
Alexei
2001-09-26 15:20
2002.01.08
How to determine the presence of a modem?


6-22293
Dark_Dan
2001-10-02 18:09
2002.01.08
Sockets must die !!!!!!!


1-22240
creepster
2001-12-16 19:20
2002.01.08
Tbutton


14-22340
Yuraz
2001-11-06 10:09
2002.01.08
People, tell me where the cookies in W2K are stored, and how you can bang them


1-22260
Alex_Sudakov
2001-12-17 15:28
2002.01.08
Tell me, is there a DsgnIntf ​​unit in D6?





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 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