Database interface Wizard

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Net55 (net55_at_frontpagewiz.com)
Date: 04/30/04


Date: Fri, 30 Apr 2004 11:21:19 -0700

You can do a view query, it will show up on the database
dropdown menu.

Try a custom query if you want the timestamp field, FP
will allow pure sql.

Net55
net55@frontpagewiz.com
http://www.frontpagewiz.com

>-----Original Message-----
>I am trying to connect to an MSSQL database. The Table I
need to work with has a timestamp field. The Wizard fails
when it connects to the table as that is an unsupported
datatype.
>Quick solution use a view in MSSQL and leave that field
out.
>But the wizard won't allow the creation of interface
pages on a view.
>
>I guess the answer is my DB is can't be used with the
wizard
>
>
>.
>



Relevant Pages

  • Re: Access and Front Page 2003 -- Syntax Error
    ... Did you tried in the custom query changing all the "" ... | they support Access DB's but don't support the Access Web View portion ... Started off by importing an access 2003 database into Front Page ... and got "database results wizard failed. ...
    (microsoft.public.frontpage.client)
  • Re: Can FP Handle Complex Queries
    ... While using the FP Database Results Wizard to set up the custom query, ...
    (microsoft.public.frontpage.programming)
  • Custom Query Size Limit in FP 2000
    ... FP 2000 seems to have a size limit on placing large SQL ... Statements into the Custom Query box in the Database ... Results wizard. ...
    (microsoft.public.frontpage.client)
  • Re: Data keeps alphabatizing
    ... Access doesn't store data in any consistent order, ... It can however *retrieve* data in any order that you ... the timestamp field. ... >then close the database, when I open it again the ...
    (microsoft.public.access.tablesdbdesign)
  • GridView not updating table with timestamp field
    ... I'm using .NET 2.0 and I have a problem with a GridView that not update the ... table in the database. ... In that table I have a timestamp field, but I've excluded them from update ... What I'm wronging? ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)