SySo®
|
| Posted: 04/22/2001, 1:30 AM |
|
Hi NG ....
even since in february this problem already has been discussed,
I can't find a solution for the SYNTAX-ERROR, when updating
a recordset.
Everything works fine - the grid is shown correctly, an I can
delete and insert new recordsets,
IF THERE WASN'T THE PROB WITH UPDATING ......
Whenever I click the button to update a selected recordset,
the message
"Syntaxfehler in UPDATE-Anweisung. (Microsoft JET Database Engine)"
appears ....
I'm using the german version, and the message just tells me,
there was an error in the syntax refering to the update-operation.
I tried to include the primary-key, not to include the primary-key,
tried all field-options like URL, LABEL, HIDDEN and so on ...
nothing worked at all up to now ....
perhaps someone knows, how to get solved this problem.
I even tried another database in MS-ACCESS, without primary-
key - this also didn't help <sigh>
EVERY solution-idea will be appreciated thankfully ..
thanks in advance,
Ralf S.
|
|
|
 |
SySo®
|
| Posted: 04/22/2001, 2:46 AM |
|
OKAY - I've found the thing which caused the problem,
by myself, but didn't find a solution yet.
The SYNTAX-Error-Message appears, because several
fields in the database are numeric, but formated as currency
with two decimales.
When trying to update these fields, and there are decimales
like 9,95 for example, the error appears. When only numeric
values like 9 for example is entered, no error appears, and
the UPDATE-Procedure works fine.
Any suggestions appreciated thankfully,
Ralf S.
> Hi NG ....
> even since in february this problem already has been discussed,
> I can't find a solution for the SYNTAX-ERROR, when updating
> a recordset.
>
> Everything works fine - the grid is shown correctly, an I can
> delete and insert new recordsets,
>
> IF THERE WASN'T THE PROB WITH UPDATING ......
>
> Whenever I click the button to update a selected recordset,
> the message
> "Syntaxfehler in UPDATE-Anweisung. (Microsoft JET Database Engine)"
> appears ....
>
> I'm using the german version, and the message just tells me,
> there was an error in the syntax refering to the update-operation.
>
> I tried to include the primary-key, not to include the primary-key,
> tried all field-options like URL, LABEL, HIDDEN and so on ...
> nothing worked at all up to now ....
>
> perhaps someone knows, how to get solved this problem.
> I even tried another database in MS-ACCESS, without primary-
> key - this also didn't help <sigh>
>
> EVERY solution-idea will be appreciated thankfully ..
> thanks in advance,
> Ralf S.
>
>
|
|
|
|
Henrik B. Rasmussen
|
| Posted: 04/22/2001, 3:16 AM |
|
This is not a CC problem, but I sometimes also have a problem like this. I
use ASP and thesolution is often to force a conversion of the field-content
before updating the db. Many times the content of a field will be "seen" as
text by ASP, so using something like cDbl() (Convert to a doubel
variabeltype) is often usen or writing a custom typeconversion function your
self is the solution.
Hope it helps to understand what is going on....
/Henrik
|
|
|
|
|
