FP98: Database Column Values Inserted Into Same Table Cell (175783)


The information in this article applies to:

  • Microsoft FrontPage 98 for Windows
This article was previously published under Q175783

SYMPTOMS

When you attempt to insert a database column value into a database table, the database column value is inserted into the current cell rather than a new cell in the table.

CAUSE

This behavior occurs if you select the "Show the query in a table " check box while you are creating the database table by using the Database Region Wizard. Once the Wizard inserts the table, you cannot add or remove column values.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

WORKAROUND

To work around this problem, follow these steps:
  1. Insert a new table cell into the database table. To do this,

    1. Click in any database column so that the Column Value command will be available when you point to Database on the Insert menu.
    2. On the Table menu, click "Insert Rows or Columns."
    3. In the "Insert Rows or Columns" dialog box, click Columns.
    4. In the Number Of Columns box, type 1 or click the arrows to select one column.
    5. Click either Left Of Selection or Right Of Selection.
    6. Click OK.
  2. Insert a database column value into the new table cell:

    1. Click in the cell you created in step 1.
    2. On the Insert menu, point to Database, and click Column Value.
    3. In the Database Column Value dialog box, type a query field name or select one from the list box.
    4. Click OK.

REFERENCES

For more information about database column values, click the Index tab in FrontPage Help, type the following text

Database Column Value command

and then double-click the selected text to go to the "Database Column Value command" topic.
Modification Type:MajorLast Reviewed:12/1/2000
Keywords:kbbug KB175783
©2002 Microsoft Corporation. All rights reserved.