Re: Access "Autonumber" property using LabVIEW 6.1

[scott1961_us]

Thanks for the help.  Things are working.

Re: Access "Autonumber" property using LabVIEW 6.1

[FerozP]

Hi,
You can add items using an SQL query like the one below and autonumber
will be generated for you:

Example
For the Table below
ID Name
1  Joe
2  John

SQL QUERY
INSERT INTO myTestTable ([Name]) VALUES ('Mary');

I hope this helps.

Sincerely,
Feroz
National Instruments

Re: Access "Autonumber" property using LabVIEW 6.1

[Dennis Knutson]

I don't use the toolkit so I don't know what the error code is. You
should have the text of the error. Are you trying to read or write to
the table when you get the error? When I create an Insert qurty using
SQL, I don't specify the autonumber column and I would think that you
wouldn't define it in a cluster unless you were trying to read it.

Re: Access "Autonumber" property using LabVIEW 6.1

[scott1961_us]

Sorry I wasn't clear with my question.  I currently have 2 tables in
my database.  1 table has a set of records from my application.  The
other table has the same set of records and ID column that is an
autonumber type.

The table without the ID column works fine, but the table with the ID
column won't function (Error-2147467259).  I am trying to figure out
how to configure my cluster to account for the extra column in the
table.  This is my first stab @ database vs. spreadsheet.

Re: Access "Autonumber" property using LabVIEW 6.1

[Dennis Knutson]

You don't generate the autonumber in LabVIEW. If you defined a column
in Access to autonumber, every time you insert a new row, Access
itself will populate the column.

Access "Autonumber" property using LabVIEW 6.1

[scott1961_us]

I am having problems generating an autonumber in MS Acess for test
records.  I am using LabVIEW 6.1 with the database connectivity
toolset.   If anyone has an example, it would be appreciated.