Web Development·12,146 discussions

Adding Fields to existing Recordset

Locked

I have a hidden data control that I am assigning a *.dbf file to. I would like to add fields to the Recordset, but can’t seem to be able to use the append property. Short of manually recreating the entire Recordset, does anyone have any ideas or am I missing something?

Topic

Adding Fields to existing Recordset

In reply to Adding Fields to existing Recordset

Sorry, you can’t do it unless you change your SQL and requery.

Adding Fields to existing Recordset

In reply to Adding Fields to existing Recordset

The question was auto-closed by TechRepublic

Adding Fields to existing Recordset

In reply to Adding Fields to existing Recordset

I only know of two ways to do what you’re wanting. Apparently, you already know that you can create another recordset with the structure you want and manually copy the data into the new recordset. Or, you can use constants in your SELECT to createthe columns you want. For example:

SELECT *, ” as XtraField1, 0 as XtraField2
FROM MyTable

This will give you one empty string column and one empty numeric column. You might have to adjust the constant values to get the columns to the size you wish.

Good luck!

Adding Fields to existing Recordset

In reply to Adding Fields to existing Recordset

The question was auto-closed by TechRepublic

Adding Fields to existing Recordset

In reply to Adding Fields to existing Recordset

This question was auto closed due to inactivity

[Author]

Replies