LabVIEW-SQL Toolkit-MS Access

[kghanke@my-deja.com]

Hi,

I have two questions:

1.) When I insert say two fields of data, say ten (10) records for
both, starting at record 1. Then, I come back later to insert ten
records into two different fields of the same table, BUT starting at
record 1 also. SQL Toolkit wants to append (by default?) rather than
insert the records alongside the previous insert. How do I insert
without appending, say 2 fields of data out of 10 fields (columns) in
the same table?

2.) Is it possible to insert data into A MS Access by whole columns at
one time, or at least whole rows????

Thanks for your response!


Sent via Deja.com http://www.deja.com/
Before you buy.

[Rolf Østvik]

On Mon, 25 Oct 1999 16:42:30 GMT, kghanke@my-deja.com wrote:
>1.) When I insert say two fields of data, say ten (10) records for
>both, starting at record 1. Then, I come back later to insert ten
>records into two different fields of the same table, BUT starting at
>record 1 also. SQL Toolkit wants to append (by default?) rather than
>insert the records alongside the previous insert. How do I insert
>without appending, say 2 fields of data out of 10 fields (columns) in
>the same table?

If i understand you correct:
You want to update record number 1 (to 10) with putting new data into
a field.

When you insert a new record you use the SQL command:
INSERT INTO table (field1,field2) VALUES (value1,value2);

to update a table use:
UPDATE table SET field3 = value3, field
4 = value4 WHERE condition;

This will update field3 and field4 of all records which satisfies
condition.

Without the WHERE condition you will update all records.

>2.) Is it possible to insert data into A MS Access by whole columns at
>one time, or at least whole rows????

Whole column at a time: see above.
Whole row at a time:
INSERT INTO table VALUES (value1,value2,value3......);
may work.

I have not tested the UPDATE command from LabVIEW but it is just an
ordinary SQL command.

To get some ideas of how to do things design Queries in MS-access and
take a look at the SQL code there. (There are three views of a Query:
design, table and SQL.

Also look at
http://w3.one.net/~jhoffman/sqltut.htm

Regards
Rolf