Subject | Re: problem: PreparedStatement with "? IS NULL" |
---|---|
Author | bullitenergy |
Post date | 2004-09-23T10:52:53Z |
Hello Antonio!
--- In Firebird-Java@yahoogroups.com, <brenmcguire@t...> wrote:
> First of all, remove those horrible quotes around table and column
names,
> it is not an SQL standard. If MS SQL let you do this way, MS SQL
should be
> dropped outside the window :-P
Ah, i already noticed that not all Firebird administration tools are
working with quoted identifiers. However i thought that using "quoted"
identifiers was in the SQL standard and [bracketed] identifiers are
the MS-SQL and Access extension.
> The rest of the code is strange, it's meaningless to me. Why do you have
> to put "Types.INTEGER" as a parameter? And what do you want at the third
> parameter, a column?
The code is generated upon the structure of a table record in the
database. Instead of deleting upon a primary or unique key, i want to
be able to update/delete a record upon every column value. Many
columns are NOT NULL however some columns allow NULL values.
I don't know if i should use setNull(<nbr>, Types.INTEGER) or
setNull(<nbr>, Types.NULL).
Thank you for your reply!
Best Regards,
Bullit Energy