Brian Gubb
|
| Posted: 10/16/2002, 7:51 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C275F5.13FA18F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
There don't seem to be many people in this newsgroup that answer =
questions. Hopefully all of us novices can learn enough to help other =
novices.
I get the following error everytime I try to update a record. It happens =
in all the pages I build using the Application Builder, I don't have the =
problem using the other building options. Does anyone know the answer?
Source: Record AllGrades / Update Operation
Command Text: UPDATE AllGrades SET TEAM NAME=3D'Matamata Mooloos', =
Grade=3D'8', Div=3D'8', PWin=3D2, PDraw=3D1, PLost=3D2, PPoints=3D6 =
WHERE TeamID =3D 286
Error description: Syntax error in UPDATE statement. (Microsoft JET =
Database Engine)
UPDATE AllGrades SET TEAM NAME=3D'Matamata Mooloos', Grade=3D'8', =
Div=3D'8', PWin=3D2, PDraw=3D1, PLost=3D2, PPoints=3D6 WHERE TeamID =3D =
286
Thanks in advance for your help.
Brian
------=_NextPart_000_000C_01C275F5.13FA18F0
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 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2><FONT size=3D3>There don't seem to be many people in =
this=20
newsgroup that answer questions. Hopefully all of us novices can learn =
enough to=20
help other novices.</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I get the following error everytime I try to update =
a record.=20
It happens in all the pages I build using the Application Builder, =
I don't=20
have the problem using the other building options. Does anyone know the=20
answer?</FONT></DIV>
<DIV><FONT size=3D2><FONT =
size=3D3><STRONG></STRONG></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3><STRONG>Source:</STRONG> Record =
AllGrades /=20
Update Operation<BR><B>Command Text:</B> UPDATE AllGrades SET TEAM=20
NAME=3D'Matamata Mooloos', Grade=3D'8', Div=3D'8', PWin=3D2, PDraw=3D1, =
PLost=3D2, PPoints=3D6=20
WHERE TeamID =3D 286<BR><B>Error description:</B> Syntax error in UPDATE =
statement. (Microsoft JET Database Engine)<BR>UPDATE AllGrades SET TEAM=20
NAME=3D'Matamata Mooloos', Grade=3D'8', Div=3D'8', PWin=3D2, PDraw=3D1, =
PLost=3D2, PPoints=3D6=20
WHERE TeamID =3D 286</FONT><BR></FONT></DIV>
<DIV><FONT size=3D2>Thanks in advance for your help.</FONT></DIV>
<DIV><FONT size=3D2>Brian</DIV></FONT></BODY></HTML>
------=_NextPart_000_000C_01C275F5.13FA18F0--
|
|
|
 |
Codecharge
|
| Posted: 10/17/2002, 1:03 AM |
|
Brian
In the hope of renewing your faith in the group:
The most obvious options as far as I can see are
(a) you're passing string values to the Grade and Div fields -perhaps these
should be integers. If that's the case you need to change the "Data Type"
property for the fields to Integer.
or
(b) is it possible the field TEAM NAME (2 words) is causing a problem? I
haven't tried this out, but changing it to TEAMNAME may help.
Hope this helps
Alistair McFadyen
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:aol8jg$5st$1@news.codecharge.com...
There don't seem to be many people in this newsgroup that answer questions.
Hopefully all of us novices can learn enough to help other novices.
I get the following error everytime I try to update a record. It happens in
all the pages I build using the Application Builder, I don't have the
problem using the other building options. Does anyone know the answer?
Source: Record AllGrades / Update Operation
Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8',
Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
Error description: Syntax error in UPDATE statement. (Microsoft JET Database
Engine)
UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
Thanks in advance for your help.
Brian
|
|
|
|
guest
|
| Posted: 10/17/2002, 7:39 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_006C_01C275C0.B94C4830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
try this. change TEAM NAME to [TEAM NAME]. I had to do this when using field
names with spaces. You might want to cut and paste the SQL into the query
builder in access to get a better error code.
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:aol8jg$5st$1@news.codecharge.com...
There don't seem to be many people in this newsgroup that answer
questions. Hopefully all of us novices can learn enough to help other
novices.
I get the following error everytime I try to update a record. It happens
in all the pages I build using the Application Builder, I don't have the
problem using the other building options. Does anyone know the answer?
Source: Record AllGrades / Update Operation
Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos',
Grade='8', Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
Error description: Syntax error in UPDATE statement. (Microsoft JET
Database Engine)
UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
Thanks in advance for your help.
Brian
------=_NextPart_000_006C_01C275C0.B94C4830
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 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>try this. change TEAM NAME to [TEAM =
NAME]. I had to=20
do this when using field names with spaces. You might want to cut and =
paste the=20
SQL into the query builder in access to get a better error =
code.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:aol8jg$5st$1@news.codecharge.com">news:aol8jg$5st$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2><FONT size=3D3>There don't seem to be many people =
in this=20
newsgroup that answer questions. Hopefully all of us novices can learn =
enough=20
to help other novices.</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I get the following error everytime I try to =
update a=20
record. It happens in all the pages I build using the Application =
Builder, I don't have the problem using the other building options. =
Does=20
anyone know the answer?</FONT></DIV>
<DIV><FONT size=3D2><FONT =
size=3D3><STRONG></STRONG></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3><STRONG>Source:</STRONG> Record =
AllGrades /=20
Update Operation<BR><B>Command Text:</B> UPDATE AllGrades SET TEAM=20
NAME=3D'Matamata Mooloos', Grade=3D'8', Div=3D'8', PWin=3D2, =
PDraw=3D1, PLost=3D2,=20
PPoints=3D6 WHERE TeamID =3D 286<BR><B>Error description:</B> Syntax =
error in=20
UPDATE statement. (Microsoft JET Database Engine)<BR>UPDATE AllGrades =
SET TEAM=20
NAME=3D'Matamata Mooloos', Grade=3D'8', Div=3D'8', PWin=3D2, =
PDraw=3D1, PLost=3D2,=20
PPoints=3D6 WHERE TeamID =3D 286</FONT><BR></FONT></DIV>
<DIV><FONT size=3D2>Thanks in advance for your help.</FONT></DIV>
<DIV><FONT size=3D2>Brian</DIV></BLOCKQUOTE></FONT></BODY></HTML>
------=_NextPart_000_006C_01C275C0.B94C4830--
|
|
|
|
Brian Gubb
|
| Posted: 10/17/2002, 10:32 AM |
|
Hi Alistair
Thanks for the reply, I've tried both your suggestions but still have the
problem. If you have any other suggestions I'd be happy to hear them, but
I'll keep trying to find what I'm doing wrong. It's a great way to learn
even though its frustrating.
Brian
"Codecharge" <amcfayen@netfocus-solutions.co.uk> wrote in message
news:aolqs3$6cf$1@news.codecharge.com...
> Brian
>
> In the hope of renewing your faith in the group:
>
> The most obvious options as far as I can see are
>
> (a) you're passing string values to the Grade and Div fields -perhaps
these
> should be integers. If that's the case you need to change the "Data Type"
> property for the fields to Integer.
>
> or
>
> (b) is it possible the field TEAM NAME (2 words) is causing a problem? I
> haven't tried this out, but changing it to TEAMNAME may help.
>
> Hope this helps
>
> Alistair McFadyen
>
> "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
>news:aol8jg$5st$1@news.codecharge.com...
> There don't seem to be many people in this newsgroup that answer
questions.
> Hopefully all of us novices can learn enough to help other novices.
>
> I get the following error everytime I try to update a record. It happens
in
> all the pages I build using the Application Builder, I don't have the
> problem using the other building options. Does anyone know the answer?
>
> Source: Record AllGrades / Update Operation
> Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos',
Grade='8',
> Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> Error description: Syntax error in UPDATE statement. (Microsoft JET
Database
> Engine)
> UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
> PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
>
> Thanks in advance for your help.
> Brian
>
>
|
|
|
|
Dave Rexel
|
| Posted: 10/17/2002, 12:06 PM |
|
Hello Brian
This newgroup is quite slow moving and usually Alex from Code Charge dev
team is the first to answer questions.
CCS is a very capable app but it is in its first iterations and therefore
quite poorly documented and provokes much frustration sometimes.
I did a quick test with Access and yes CCS does bug out with spaces in DB
column names...
I do remember some posts way back on this but my news reader doesnt remember
that far back.
Is it possible for you to post the table structure so I can test it further.
Best regards
Dave
<dontspamme_dsafar@hotmail.com> wrote in message
news:aomi39$h1r$1@news.codecharge.com...
try this. change TEAM NAME to [TEAM NAME]. I had to do this when using field
names with spaces. You might want to cut and paste the SQL into the query
builder in access to get a better error code.
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:aol8jg$5st$1@news.codecharge.com...
There don't seem to be many people in this newsgroup that answer questions.
Hopefully all of us novices can learn enough to help other novices.
I get the following error everytime I try to update a record. It happens in
all the pages I build using the Application Builder, I don't have the
problem using the other building options. Does anyone know the answer?
Source: Record AllGrades / Update Operation
Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8',
Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
Error description: Syntax error in UPDATE statement. (Microsoft JET Database
Engine)
UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
Thanks in advance for your help.
Brian
|
|
|
|
Brian Gubb
|
| Posted: 10/17/2002, 7:21 PM |
|
Hi Dave,
Thanks for your offer to help. How do I post the structure of my database?
Brian
"Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
news:aon1oc$e8q$1@news.codecharge.com...
> Hello Brian
> This newgroup is quite slow moving and usually Alex from Code Charge dev
> team is the first to answer questions.
> CCS is a very capable app but it is in its first iterations and therefore
> quite poorly documented and provokes much frustration sometimes.
> I did a quick test with Access and yes CCS does bug out with spaces in DB
> column names...
> I do remember some posts way back on this but my news reader doesnt
remember
> that far back.
> Is it possible for you to post the table structure so I can test it
further.
> Best regards
> Dave
>
> <dontspamme_dsafar@hotmail.com> wrote in message
>news:aomi39$h1r$1@news.codecharge.com...
> try this. change TEAM NAME to [TEAM NAME]. I had to do this when using
field
> names with spaces. You might want to cut and paste the SQL into the query
> builder in access to get a better error code.
> "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
>news:aol8jg$5st$1@news.codecharge.com...
> There don't seem to be many people in this newsgroup that answer
questions.
> Hopefully all of us novices can learn enough to help other novices.
>
> I get the following error everytime I try to update a record. It happens
in
> all the pages I build using the Application Builder, I don't have the
> problem using the other building options. Does anyone know the answer?
>
> Source: Record AllGrades / Update Operation
> Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos',
Grade='8',
> Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> Error description: Syntax error in UPDATE statement. (Microsoft JET
Database
> Engine)
> UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
> PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
>
> Thanks in advance for your help.
> Brian
>
>
|
|
|
|
Dave Rexel
|
| Posted: 10/20/2002, 2:35 PM |
|
pls which DB are you using ?
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:aonr7i$rq1$1@news.codecharge.com...
> Hi Dave,
>
> Thanks for your offer to help. How do I post the structure of my database?
>
> Brian
>
>
> "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
>news:aon1oc$e8q$1@news.codecharge.com...
> > Hello Brian
> > This newgroup is quite slow moving and usually Alex from Code Charge dev
> > team is the first to answer questions.
> > CCS is a very capable app but it is in its first iterations and
therefore
> > quite poorly documented and provokes much frustration sometimes.
> > I did a quick test with Access and yes CCS does bug out with spaces in
DB
> > column names...
> > I do remember some posts way back on this but my news reader doesnt
> remember
> > that far back.
> > Is it possible for you to post the table structure so I can test it
> further.
> > Best regards
> > Dave
> >
> > <dontspamme_dsafar@hotmail.com> wrote in message
> >news:aomi39$h1r$1@news.codecharge.com...
> > try this. change TEAM NAME to [TEAM NAME]. I had to do this when using
> field
> > names with spaces. You might want to cut and paste the SQL into the
query
> > builder in access to get a better error code.
> > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> >news:aol8jg$5st$1@news.codecharge.com...
> > There don't seem to be many people in this newsgroup that answer
> questions.
> > Hopefully all of us novices can learn enough to help other novices.
> >
> > I get the following error everytime I try to update a record. It happens
> in
> > all the pages I build using the Application Builder, I don't have the
> > problem using the other building options. Does anyone know the answer?
> >
> > Source: Record AllGrades / Update Operation
> > Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos',
> Grade='8',
> > Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> > Error description: Syntax error in UPDATE statement. (Microsoft JET
> Database
> > Engine)
> > UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
> > PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> >
> > Thanks in advance for your help.
> > Brian
> >
> >
>
>
|
|
|
|
Brian Gubb
|
| Posted: 10/21/2002, 5:24 AM |
|
I decided to start again from scratch and it's working fine now. Don't know
what is different, but it's working. Thanks anyway.
Brian
"Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
news:aov7jm$mch$1@news.codecharge.com...
> pls which DB are you using ?
>
> "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
>news:aonr7i$rq1$1@news.codecharge.com...
> > Hi Dave,
> >
> > Thanks for your offer to help. How do I post the structure of my
database?
> >
> > Brian
> >
> >
> > "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
> >news:aon1oc$e8q$1@news.codecharge.com...
> > > Hello Brian
> > > This newgroup is quite slow moving and usually Alex from Code Charge
dev
> > > team is the first to answer questions.
> > > CCS is a very capable app but it is in its first iterations and
> therefore
> > > quite poorly documented and provokes much frustration sometimes.
> > > I did a quick test with Access and yes CCS does bug out with spaces in
> DB
> > > column names...
> > > I do remember some posts way back on this but my news reader doesnt
> > remember
> > > that far back.
> > > Is it possible for you to post the table structure so I can test it
> > further.
> > > Best regards
> > > Dave
> > >
> > > <dontspamme_dsafar@hotmail.com> wrote in message
> > >news:aomi39$h1r$1@news.codecharge.com...
> > > try this. change TEAM NAME to [TEAM NAME]. I had to do this when using
> > field
> > > names with spaces. You might want to cut and paste the SQL into the
> query
> > > builder in access to get a better error code.
> > > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> > >news:aol8jg$5st$1@news.codecharge.com...
> > > There don't seem to be many people in this newsgroup that answer
> > questions.
> > > Hopefully all of us novices can learn enough to help other novices.
> > >
> > > I get the following error everytime I try to update a record. It
happens
> > in
> > > all the pages I build using the Application Builder, I don't have the
> > > problem using the other building options. Does anyone know the answer?
> > >
> > > Source: Record AllGrades / Update Operation
> > > Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos',
> > Grade='8',
> > > Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> > > Error description: Syntax error in UPDATE statement. (Microsoft JET
> > Database
> > > Engine)
> > > UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8', Div='8',
> > > PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> > >
> > > Thanks in advance for your help.
> > > Brian
> > >
> > >
> >
> >
>
>
|
|
|
|
Dave Rexel
|
| Posted: 10/21/2002, 1:51 PM |
|
Your're welcome, good luck
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:ap0rla$hco$1@news.codecharge.com...
> I decided to start again from scratch and it's working fine now. Don't
know
> what is different, but it's working. Thanks anyway.
>
> Brian
>
>
> "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
>news:aov7jm$mch$1@news.codecharge.com...
> > pls which DB are you using ?
> >
> > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> >news:aonr7i$rq1$1@news.codecharge.com...
> > > Hi Dave,
> > >
> > > Thanks for your offer to help. How do I post the structure of my
> database?
> > >
> > > Brian
> > >
> > >
> > > "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
> > >news:aon1oc$e8q$1@news.codecharge.com...
> > > > Hello Brian
> > > > This newgroup is quite slow moving and usually Alex from Code Charge
> dev
> > > > team is the first to answer questions.
> > > > CCS is a very capable app but it is in its first iterations and
> > therefore
> > > > quite poorly documented and provokes much frustration sometimes.
> > > > I did a quick test with Access and yes CCS does bug out with spaces
in
> > DB
> > > > column names...
> > > > I do remember some posts way back on this but my news reader doesnt
> > > remember
> > > > that far back.
> > > > Is it possible for you to post the table structure so I can test it
> > > further.
> > > > Best regards
> > > > Dave
> > > >
> > > > <dontspamme_dsafar@hotmail.com> wrote in message
> > > >news:aomi39$h1r$1@news.codecharge.com...
> > > > try this. change TEAM NAME to [TEAM NAME]. I had to do this when
using
> > > field
> > > > names with spaces. You might want to cut and paste the SQL into the
> > query
> > > > builder in access to get a better error code.
> > > > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> > > >news:aol8jg$5st$1@news.codecharge.com...
> > > > There don't seem to be many people in this newsgroup that answer
> > > questions.
> > > > Hopefully all of us novices can learn enough to help other novices.
> > > >
> > > > I get the following error everytime I try to update a record. It
> happens
> > > in
> > > > all the pages I build using the Application Builder, I don't have
the
> > > > problem using the other building options. Does anyone know the
answer?
> > > >
> > > > Source: Record AllGrades / Update Operation
> > > > Command Text: UPDATE AllGrades SET TEAM NAME='Matamata Mooloos',
> > > Grade='8',
> > > > Div='8', PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> > > > Error description: Syntax error in UPDATE statement. (Microsoft JET
> > > Database
> > > > Engine)
> > > > UPDATE AllGrades SET TEAM NAME='Matamata Mooloos', Grade='8',
Div='8',
> > > > PWin=2, PDraw=1, PLost=2, PPoints=6 WHERE TeamID = 286
> > > >
> > > > Thanks in advance for your help.
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
