Working with Large Forms

[Roman_Candle]

I have a large form (30 fields) submitting to a DB (access).


When i write my SQL statements or DBCommands do i have to reference all the fields in the statement (ie ("INSERT INTO
MyTable (NUMBER, DATE, NAME,etc,etc.....30) VALUES (?, ?, ?....30)")

is there a shorter version or way of doing this?
or do i have some monster SQL statements

 

[Paszt]

If you want to send all the data to the dataBase, you must include all the fields.
There is however, a dataForm Wizard which will create the schema and code for you.
You can also use the Data Adapter Configuration Wizard and the Query Builder to build the SQL statement visually.

 

[TPM]

If your planning on doing a lot of inserts you could use BULK INSERT.

TPM

 

[mzim]

I have a large form (30 fields) submitting to a DB (access).


When i write my SQL statements or DBCommands do i have to reference all the fields in the statement (ie ("INSERT INTO
MyTable (NUMBER, DATE, NAME,etc,etc.....30) VALUES (?, ?, ?....30)")

is there a shorter version or way of doing this?
or do i have some monster SQL statements

if your table has 30 fields.

you could do this:

insert into mytable values(etc...30)

by not specifying the fields.

 

[Roman_Candle]

thanks for your help !

 

[Schenz]

NOTE: If you do not specify the field names you MUST Insert the data exactly in the same order as the database has it set up. You may NOT skip any of the fields, if there is nothing to Insert for a field you must either tell it to insert NULL or "".

It is much better practice to specify the field names. And in 6 months when you come back to work on that code it is easier to remember exactly what it is doing.