|
| |
|
|
lpdds
Posts: 31
Joined: 10/6/2002
Status: offline
 |
Syntax error in Delete query - 7/31/2009 15:17:26
I am getting a syntax error when I try to delete a record from an Access Database using FP03 using this custom query:
Delete * FROM [Patient]
WHERE [DateofAdmission]='::DateofAdmission::' and [PatientLastName]='::PatientLastName::' and [PatientFirstName]='::PatientFirstName::'
This is the error that is displayed when I verify the query:
Server error: Unable to retrieve schema information from the query:
SELECT * FROM * FROM [Patient]
against a database using the connection string
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=Covermedoc/access_db/Data.mdb.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
The syntax seems correct. I there something that I am missing?
|
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Syntax error in Delete query - 8/1/2009 9:30:19
quote:
ORIGINAL: lpdds
I am getting a syntax error when I try to delete a record from an Access Database using FP03 using this custom query:
Delete * FROM [Patient]
WHERE [DateofAdmission]='::DateofAdmission::' and [PatientLastName]='::PatientLastName::' and [PatientFirstName]='::PatientFirstName::'
The syntax seems correct. I there something that I am missing?
Remove the asterisk, like this:
Delete FROM [Patient]
WHERE [DateofAdmission]='::DateofAdmission::' and [PatientLastName]='::PatientLastName::' and [PatientFirstName]='::PatientFirstName::'
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
lpdds
Posts: 31
Joined: 10/6/2002
Status: offline
|
RE: Syntax error in Delete query - 8/1/2009 15:25:14
Thank you for your reply. It worked. I like simple solutions.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 