Subject Antw: Re: [IBO] TIBOQuery ParamsByName SQL Error -804 data
Author Uwe Cramer
Hello Helen, thanks for all,
i wrote my own ":parameter" parser to set the right values in then
sqlstrings and put this ready strings without params in the sql property.
This works.
For your Information i hold all statements in SQL.TXT Files, load them at
runtime and change the :params to the needed values. My Applications are
changed from lokalSQL(paradox) to Interbase and i haven�t known before, that
the params handling is so different between lokalSLQ and IBSQL.
Thanks again and regards

>>> Helen Borrie (TeamIBO<helebor@... ")"Newsgroups> 17.02.2002
20:36:49 >>>
At 08:25 PM 17-02-02 +0200, you wrote:
>Hello, i find out that the problem is a float param instead of the date.
>when i use query.params.parambyname and not query.parambyname

Perhaps you need to tell us more about how you are collecting user inputs.
If you are using non-data-aware controls to collect parameters, then you
must parse and cast the inputs in most cases.

>i got the error later when i set the parameter
>query.params.parambyname('MyFloat').asFloat := MyFloatVar;
>the first problem is that when i look in parm...text there is
>"1,1" instead of "1.0" (comma instead of point)
>in german the decimal separator is comma not point

If you use data-aware controls you can set display attributes and edit masks
to handle format problems.

>so i try a simple integer value
>query.params.parambyname('MyInt').asInteger := StrToInt(edit1.text);
>and the statement
>"select nr, nr * :MyInt as MultiNr from MyTable where nr = 2"
>produced error -601 array/blob/data type no allowed in arithmetik

This problem is due to bad SQL syntax. Parameters to dynamic SQL statements
"stand in place" of a column value (in the case of tables) or an input
argument (in the case of stored procedures). The colon-prefix in SQL marks
an array element (although this statement wouldn't work for an array element

To achieve what you wanted to do you would need to pass your Delphi variable
value into your statement as a constant:

MyInt := Edit1.Text;
(* Make sure you test to make sure there is a value *)
MyQuery.SQL.Add('select nr, nr * ' + StrToInt(MyInt) + ' as MultiNr from
MyQuery.SQL.Add('where nr = 2');

>i don�t know how to go on.

A good place to start would be to study the SQL language. It is not
"free-form" - it adheres to very tight syntax rules. Because FB/IB is
highly compliant with the SQL-92 level 0 and level 1 standards, any good
"starter" book would be useful. There are some recommendations on the IBO
bookstore page ( ); alternatively,
you could search on "SQL" at the website and read some of
titles and reviews there. The Data Definition Guide (DataDef.pdf) and the
Language Reference (LangRef.pdf) also provide basic syntax and examples.

If you are going to use non-data-aware controls, you also need to study the
IB/FB data types so that you understand how Delphi performs conversions from
string inputs. In many cases you will have to cast them yourself as there
is not 1:1 correspondence between Delphi and IB datatypes.

Good luck, keep asking. Oh, and please would you trim your replies...

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to