database interfaceProblems

J

JOHN B

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
 
J

Jim Buyens

-----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
Click to expand...

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)
|/---------------------------------------------------
*----------------------------------------------------
 
G

Guest

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
 
J

Jim Buyens

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
Click to expand...

Yes. Please try the instructions at:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.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)
|/---------------------------------------------------
*----------------------------------------------------
 
J

John Jansen \(MSFT\)

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.
 
Top