Inserting new Table Row through a form?

  • Thread starter Thread starter FirebirdGM
  • Start date Start date
F

FirebirdGM

Hello,

I have a form which I have made to *hopefully* easily add a field to
table. Is there a way to parse the entered data from the form an
create a new Row in a table?

Thank you much. :
 
Hi Firebird,

1) Do you mean "field" when you say "row", or "row" when you say
"field"?

2) If your database design requires fields to be added to tables as part
of normal operation, there is something wrong with the design. There's a
saying "Fields are expensive, rows are cheap". This is because adding a
field to a table has all sorts of consequences elsewhere in the database
application (queries, forms and reports are all likely to need
modification to use the new field). Perhaps you'd like to say a bit more
about the problem you're trying to solve.
 
FirebirdGM said:
Hello,

I have a form which I have made to *hopefully* easily add a field to a
table. Is there a way to parse the entered data from the form and
create a new Row in a table?
Click to expand...

Strange but not impossible, you can use an INSERT INTO... query,
composing it from the pieces you have on the form.

But: Consider using the built-in functionality of bound fields. Play
with control types like comboboxes.
 
Back
Top