M.Masri
|
| Posted: 08/15/2001, 6:24 AM |
|
Hello,
I get the followin error:
[Easysoft][Interbase]Dynamic SQL Error, SQL error code = -104, Token
unknown - line 1, char 51, Null
/EG/Site/V98/Common.asp, regel 34
when trying to insert a new record through Gridform FormAction
How to overide the sWhere in the so that the sWhere in the Select statement
changed from '= NULL' to 'IS NULL'
TIA
M.Masri
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 08/15/2001, 7:19 AM |
|
Wirte the following in Form/Event/Open - sWhere= ' IS NULL"
--
Alex
Ceritfied CodeCharge Developer
Develop database-connected web sites
without coding: http://www.codecharge.com
ASP, ASP.NET, PHP, JSP, Perl, ColdFusion
M.Masri <moutaz.masri@wanadoo.nl> wrote in message
news:9ldt69$iti$1@news.codecharge.com...
> Hello,
>
> I get the followin error:
>
> [Easysoft][Interbase]Dynamic SQL Error, SQL error code = -104, Token
> unknown - line 1, char 51, Null
>
> /EG/Site/V98/Common.asp, regel 34
>
> when trying to insert a new record through Gridform FormAction
>
> How to overide the sWhere in the so that the sWhere in the Select
statement
> changed from '= NULL' to 'IS NULL'
>
> TIA
> M.Masri
>
>
|
|
|
|
M.Masri
|
| Posted: 08/19/2001, 3:10 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01C128A7.E31C0B80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
=20
I still get the error because if the parameter is empty then generated =
select statment will be as follow:=20
=20
SELECT firstfield, secondfield FROM myTable WHERE firstfield =3D NULL
=20
In Interbase Null is state and not a value! the correct Select statment =
should be:
=20
SELECT firstfield, secondfield FROM myTable WHERE firstfield IS NULL
=20
Is there a way to change the syntax before the code will be generated, =
because I have around 40 Forms?
=20
Tia
M.Masri
"Alexey Alexapolsky" <alexa@codecharge.com> schreef in bericht =
news:9le0d9$pc0$1@news.codecharge.com...
> Wirte the following in Form/Event/Open - sWhere=3D ' IS NULL"
>=20
> --
> Alex
> Ceritfied CodeCharge Developer
> Develop database-connected web sites
> without coding: http://www.codecharge.com
> ASP, ASP.NET, PHP, JSP, Perl, ColdFusion
>=20
> M.Masri <moutaz.masri@wanadoo.nl> wrote in message
>news:9ldt69$iti$1@news.codecharge.com...
> > Hello,
> >
> > I get the followin error:
> >
> > [Easysoft][Interbase]Dynamic SQL Error, SQL error code =3D -104, =
Token
> > unknown - line 1, char 51, Null
> >
> > /EG/Site/V98/Common.asp, regel 34
> >
> > when trying to insert a new record through Gridform FormAction
> >
> > How to overide the sWhere in the so that the sWhere in the Select
> statement
> > changed from '=3D NULL' to 'IS NULL'
> >
> > TIA
> > M.Masri
> >
> >
>=20
>=20
------=_NextPart_000_0016_01C128A7.E31C0B80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2> <BR>I still get the error because =
if the=20
parameter is empty then generated select statment will be as follow:=20
<BR> <BR>SELECT firstfield, secondfield FROM myTable WHERE =
firstfield=20
<STRONG><FONT color=3D#0000ff>=3D NULL</FONT></STRONG><BR> <BR>In =
Interbase=20
Null is state and not a value! the correct Select statment should =
be:<BR> =20
<BR>SELECT firstfield, secondfield FROM myTable WHERE firstfield =
<STRONG><FONT=20
color=3D#0000ff>IS NULL</FONT></STRONG><BR> <BR>Is there a way to =
change the=20
syntax before the code will be generated, because I have around 40=20
Forms?<BR> <BR>Tia<BR>M.Masri<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Alexey Alexapolsky" <</FONT><A=20
href=3D"mailto:alexa@codecharge.com"><FONT face=3DArial=20
size=3D2>alexa@codecharge.com</FONT></A><FONT face=3DArial size=3D2>> =
schreef in=20
bericht </FONT><A href=3D"news:9le0d9$pc0$1@news.codecharge.com"><FONT =
face=3DArial=20
size=3D2>news:9le0d9$pc0$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> Wirte the =
following in=20
Form/Event/Open - sWhere=3D ' IS NULL"<BR>> <BR>> --<BR>> =
Alex<BR>>=20
Ceritfied CodeCharge Developer<BR>> Develop database-connected web=20
sites<BR>> without coding: </FONT><A =
href=3D"http://www.codecharge.com"><FONT=20
face=3DArial size=3D2>http://www.codecharge.com</FONT></A><BR><FONT =
face=3DArial=20
size=3D2>> ASP, ASP.NET, PHP, JSP, Perl, ColdFusion<BR>> <BR>> =
M.Masri=20
<</FONT><A href=3D"mailto:moutaz.masri@wanadoo.nl"><FONT face=3DArial =
size=3D2>moutaz.masri@wanadoo.nl</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message<BR>> </FONT><A =
href=3D"news:9ldt69$iti$1@news.codecharge.com"><FONT=20
face=3DArial =
size=3D2>news:9ldt69$iti$1@news.codecharge.com</FONT></A><FONT=20
face=3DArial size=3D2>...<BR>> > Hello,<BR>> ><BR>> > =
I get the=20
followin error:<BR>> ><BR>> > [Easysoft][Interbase]Dynamic =
SQL=20
Error, SQL error code =3D -104, Token<BR>> > unknown - line 1, =
char 51,=20
Null<BR>> ><BR>> > /EG/Site/V98/Common.asp, regel 34<BR>> =
><BR>> > when trying to insert a new record through Gridform=20
FormAction<BR>> ><BR>> > How to overide the sWhere in the so =
that=20
the sWhere in the Select<BR>> statement<BR>> > changed =
from '=3D=20
NULL' to 'IS NULL'<BR>> ><BR>> > TIA<BR>> =
>=20
M.Masri<BR>> ><BR>> ><BR>> <BR>> </FONT></BODY></HTML>
------=_NextPart_000_0016_01C128A7.E31C0B80--
|
|
|
|
Nadeem
|
| Posted: 08/24/2001, 4:34 AM |
|
I have tried these:
sWhere= ' IS NULL"
sWhere= '"IS NULL"
But it do not work. Please advise correct syntax.
Thanks.
Nadeem
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9le0d9$pc0$1@news.codecharge.com...
> Wirte the following in Form/Event/Open - sWhere= ' IS NULL"
>
> --
> Alex
> Ceritfied CodeCharge Developer
> Develop database-connected web sites
> without coding: http://www.codecharge.com
> ASP, ASP.NET, PHP, JSP, Perl, ColdFusion
>
> M.Masri <moutaz.masri@wanadoo.nl> wrote in message
>news:9ldt69$iti$1@news.codecharge.com...
> > Hello,
> >
> > I get the followin error:
> >
> > [Easysoft][Interbase]Dynamic SQL Error, SQL error code = -104, Token
> > unknown - line 1, char 51, Null
> >
> > /EG/Site/V98/Common.asp, regel 34
> >
> > when trying to insert a new record through Gridform FormAction
> >
> > How to overide the sWhere in the so that the sWhere in the Select
> statement
> > changed from '= NULL' to 'IS NULL'
> >
> > TIA
> > M.Masri
> >
> >
>
>
|
|
|
|
|
