Front Page DataBase wizard

[sifte.farooqui]

How to change the datatype in the editor Pag eof Front
page database interface editor page. I can change the
datatype easily in teh submission form but can not accept
new datatype in teh editor page..

 

[Jim Buyens]

-----Original Message-----

How to change the datatype in the editor Pag eof Front
page database interface editor page. I can change the
datatype easily in teh submission form but can not accept
new datatype in teh editor page..

What are the from and to datatypes?

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

 

[Guest]

Jim,

I explained it on my other question also,
The Database wizard creat the result page, submission
page and the Editor page.
I was trying to edit soen data, but the datatype is
different, then i initially put in teh database, before
making this wizard.

The submission page is a simple form. if you go there,
and double click the text box, it will ask you what
datatype, then its upto you what data type you seslect.

So, in submission page, changing the d/type is no
problem, but the real game is in teh "editor page" any
hint.. thanks

 

[Jim Buyens]

When you right-click a form element, choose Form Properties, click
Validate, and change the data type, all you're changing are the
syntax-editing rules for the field. This *doesn't* change the SQL code
that appears in INSERT, UPDATE, and DELETE statements, and that's
what's causing your problem.

If you can get to those SQL statements and correct the delimiters that
surround the form field values, that will most likely fix the problem.
Otherwise, delete and recreate the database editor.

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