hwd007
|
| Posted: 05/22/2003, 9:43 PM |
|
I get and error "Database command error." when I try to add a record in the database . Any ideas ???
|
|
|
 |
rrodgers
|
| Posted: 05/23/2003, 5:43 AM |
|
What language, asp, php....?
Is there any more info from the error? A number, the field that is in error?
|
|
|
|
Meshal
|
| Posted: 06/11/2003, 2:49 AM |
|
I have the same error when i try to add a record.
I am using ASP, IIS, CCS2.1
The error is:
Sorce: Record WeeklyStatus / Insert Operation
Error description: Command text was not set for the command object. (Microsoft JET Database Engine)
Please Help??
|
|
|
|
rrodgers
|
| Posted: 06/11/2003, 3:29 PM |
|
You don't say what you are using. CCS or CC? and you don't mention what language you are using. ASP, PHP... etc.?
So I will answer in CCS/ASP
>> Command text was not set for the command object
A quick search of goole.com turns up that this is likely because the sql statement has not been set or is incorrect. Why this is happening in your code charge app I don't know. I would start by "print"ing the
Formname.DataSource.SQL
Formname.DataSource.where
Formname.DataSource.Order
statements to find out what is being sent to the backend? Maybe concat them together to run your own query to see what the error may be.
|
|
|
|
rrodgers
|
| Posted: 06/11/2003, 3:52 PM |
|
Actually what I would do to diagnose the insert error would be... to put this code in the FormName_DataSource_BeforeExecuteInsert event.
Print FormName.Command.Sql
response.end
This will print out the sql that is sent to the db.
rob
|
|
|
|
|
