|
nmathews -> RE: Edit/Delete records (2/21/2002 11:45:37)
|
I've tried:
delete DISTINCTROW * FROM CALENDAR ::event_name::::event_time::::misc::::browser::
and that deletes all the records in the database.
I've tried this:
UPDATE results
SET posted_by='::posted_by::',event_name='::event_name::'
WHERE event_date='::event_date::' and event_disc='::event_disc::'
but this gives me an error:
Database Results Error
Description: [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'results'. Make sure the object exists and that you spell its name and the path name correctly.
Number: -2147217865 (0x80040E37)
Source: Microsoft OLE DB Provider for ODBC Drivers
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
If i use the sugestion from microsoft:
Double-click Submit and change the Value/Label field to Update .
Right-click inside the form and then click Form Properties on the menu that appears.
In the Form Properties dialog box, select Send to other , and then click Options .
In the Action box, type Update.asp . Click OK twice and save the page as Update_Form.asp.
It sends all the information i want to change to the form fields on page 2 but i have no idea how to save it from there to the database.
|
|
|
|
