Front Page 2002 Database Wizard

[sifte.farooqui]

How to change the datatype in the editor Page of Front
page database interface editor page. I can change the
datatype easily in the submission page (form. But when I
used other data type in EDITOR page I got the error
message. In submission page i can change the datatype
from numbers to text. Can anybody tell me how to cahnge
the datatype in the editor page.. Thanks

 

[Jim Buyens]

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

How to change the datatype in the editor Page of Front
page database interface editor page. I can change the
datatype easily in the submission page (form. But when I
used other data type in EDITOR page I got the error
message. In submission page i can change the datatype
from numbers to text. Can anybody tell me how to cahnge
the datatype in the editor page.. Thanks

One way is to firts change your table, then delete and
recreate the database editor.

Otherwise, you have the find the UPDATE statement for your
table, and add apostrophes around the text value. For
example, if the SQL statement was

UPDATE mytable SET prodid = :rodid::, ...

when the prodid field was numeric, it needs to read

UPDATE mytable SET prodid = ':rodid::', ...

for a text field.

This is going to be a little inconvenient if you have
FP2003, because you can't run the Database Results Wizard
to edit the UPDATE statement as a custom query on page 2
of the wizard. Instead, you'll need to find it and correct
it in Code view.

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,

Thanks, for quick response. I will recreate the wizard
after reselecting the newly required database, on my
version column in teh table. The other alternative is not
possible in the editor wizard.

At this point, can i ask, why we can not change this in
the editor page, Should i delete all the submission and
result pages also, before running teh wizard.


Thanks

 

[Jim Buyens]

Jim,

Thanks, for quick response. I will recreate the wizard
after reselecting the newly required database, on my
version column in teh table. The other alternative is not
possible in the editor wizard.

At this point, can i ask, why we can not change this in
the editor page, Should i delete all the submission and
result pages also, before running teh wizard.

The Database Results Wizard was never intended for running INSERT,
UPDATE, and DELETE queries. However, someone figured out a way to make
it do that, and that's the facility the Database Editor uses.
Unfortunately, this leads to a lot of rough edges.

The Database Editor is produces a very simple-minded application. Take
it for what it is, or write your own application in ASP, ASP.NET, or
whatever your host supports.

Even if the Database Editor were significantly improved, most Web
developers would write their own update pages anyway. That's the only
way they can get the control and security their application requires.

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