sql refresh

[Bjarne]

I got a problem when I collect data from a MS Sql server database with the Database Connectivity toolset.

The data I get is not all correct.

I got these data

AdjustedQuantityPerExpanded   OrderQuantity   ComponentItemNumber   ComponentItemDescription     TotalQuantityRequired

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

But the correct data should look like this.

AdjustedQuantityPerExpanded   OrderQuantity   ComponentItemNumber   ComponentItemDescription     TotalQuantityRequired

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

3                                                         10                        60001929                             CONN SL M 4 LEADED            30

1                                                         10                        60001929                             CONN SL M 4 LEADED            10

I have made the two query'es in Access.

With the right one I have made a RefreshLinks before the query.

The question is, how do I make a refresh in Labvview ?

Here is a picture of the funktions I use in labview

I use:

Labview 6.1

Database connectivity toolset 1.0.1

Best regards

Bjarne

[Bjarne]

Sorry, I put put this question in the wrong forum. It belongs to the Labview forum.

Bjarne