I have used the database interface wizard to create pages
for my sybase server

everything works except the add new record

I can serach view edit records but cannot update any
records

any help would be appreciated

>-----Original Message-----
>I have used the database interface wizard to create pages
>for my sybase server
>
>everything works except the add new record
>
>I can serach view edit records but cannot update any
>records

What's the bad behavior and/or error message?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

The confiramtion page appears saying data has been updated

no error messages occur

When the database wizard added the pages i had to chnage
the code on the inc files sections of all pages
the ../../_fpclass had to be changed to _fpclass

does this help at all
>-----Original Message-----
>>-----Original Message-----
>>I have used the database interface wizard to create
pages
>>for my sybase server
>>
>>everything works except the add new record
>>
>>I can serach view edit records but cannot update any
>>records
>
>What's the bad behavior and/or error message?
>
>Jim Buyens
>Microsoft FrontPage MVP
>http://www.interlacken.com
>Author of:
>*----------------------------------------------------
>|\---------------------------------------------------
>|| Microsoft Office FrontPage 2003 Inside Out
>||---------------------------------------------------
>|| Web Database Development Step by Step .NET Edition
>|| Microsoft FrontPage Version 2002 Inside Out
>|| Faster Smarter Beginning Programming
>|| (All from Microsoft Press)
>|/---------------------------------------------------
>*----------------------------------------------------
>
>.
>

<(E-Mail Removed)> wrote in message news:<5d3201c3e5f5$05b08ab0$(E-Mail Removed)>...
> The confiramtion page appears saying data has been updated
>
> no error messages occur
>
> When the database wizard added the pages i had to chnage
> the code on the inc files sections of all pages
> the ../../_fpclass had to be changed to _fpclass
>
> does this help at all

Yes. Please try the instructions at:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tip...ow.aspx?tip=35

This won't fix the problem, but it should display an error message you
can investigate.

The bit with having to change ../../_fpclass to _fpclass is probably
caused by your ASP application and your FrontPage Web not starting at
the same folder.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

One thing that I forget to do sometimes is make sure the Form fields are
mapped to the Database columns.

Right click your form in design view in FrontPage
Form Properties
Click Options
Saved Fields tab

Verify that the form fields are mapped to the proper columns in the
database.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"JOHN B" <(E-Mail Removed)> wrote in message
news:554801c3e586$d513d150$(E-Mail Removed)...
> I have used the database interface wizard to create pages
> for my sybase server
>
> everything works except the add new record
>
> I can serach view edit records but cannot update any
> records
>
> any help would be appreciated