Problème d'utilisation de Property loader

[Gordon F]

Bonjour à tous,

J'ai besoin d'aide concernant un problème de transfert de données d'une base Access vers un tableau 1D et 2D.

Quand j'exécute la séquence il n'y a pas d'erreur retournée.

En fait quand il s'agit de récupérer les données et de les stocker dans les variables simples cela fonctionne, en revanche si ces variables sont dans un tableau elles restent à 0.

Pour le tableau 1D je ne vois pas où se situe l'erreur, pour le 2D j'ai peut-être mal configuré le step propertyloader.

Open Database	Done
Open SQL Statement	Done
Charger vers variables	Done
NumPropertiesRead:	4
NumPropertiesApplied:	4
Charger vers tableau 1D	Done
NumPropertiesRead:	4
NumPropertiesApplied:	4
Charger vers tableau 2D	Done
NumPropertiesRead:	4
NumPropertiesApplied:	4
Close SQL Statement	Done
Close Database	Done

NB: J'utilise TS 3.5

[Antonio Lie]

Gordon,

The following properties do not exist:

FileGlobals.Var2D[0][2]
FileGlobals.Var2D[0][3]
FileGlobals.Var2D[1][2]
FileGlobals.Var2D[1][3]

The step 'Charger vers tableau 2D' is trying to import 8 properties and since 4 of them do not exist, it only imports 4 properties.

The valid elements for the 2D array are:

FileGlobals.Var2D[0][0]
FileGlobals.Var2D[1][0]
.
.
.
FileGlobals.Var2D[9][0]

FileGlobals.Var2D[0][1]
FileGlobals.Var2D[1][1]
.
.
.
FileGlobals.Var2D[9][1]

The 'Charger vers tableu 1D' step is working properly. It is configured to import only 4 element of the 1D array.

Hope it helps.

Antonio Lie.

[Gordon F]

thank you for your assistance

I modified the sequence but that still does not function in 1D or 2D.

The values are not transferred in the tables.

Look at the joined image

Begin Sequence: MainSequence
(C:\TestBase\Test base.seq)

Step	Status	Measurement	Units	Limits
				Low Limit	High Limit	Comparison Type
Open Database	Done
Open SQL Statement	Done
Charger vers variables	Done
NumPropertiesRead:	4
NumPropertiesApplied:	4
Charger vers tableau 1D	Done
NumPropertiesRead:	4
NumPropertiesApplied:	4
Charger vers tableau 2D	Done
NumPropertiesRead:	8
NumPropertiesApplied:	8
Close SQL Statement	Done
Close Database	Done

End Sequence: MainSequence

Gordon F

[Antonio Lie]

Gordon,

This behavior is due to a TS 3.5 defect.

Basically when you select an array element, its data type is not being set properly.

We are looking into the possibility of releasing a new Property Loader DLL for our TS 3.5 users in order to fix this problem.

In the mean time you can make it work by manually setting the selected property DataType to the proper value.

For your case you would have to:

Modify your property loader steps by going to each array element under Step.PropertiesList and making sure the DataType property value is set to 3.

(String =1, Boolean = 2, Number =3).

I already fixed the attached sequence file, but if you select more array elements to import, you would have to modify the DataType values manually.

Check the attached image, the selected property (DataType) value was originally  -1 and I changed it to 3 (Number) to make it work.

I'll let you know as soon as the patch is ready.

Hope it helps.

Antonio Lie.

[Antonio Lie]

Gordon,

I am attaching a zip file containing a patch that fixes this problem.
Follow the instructions in the readme.txt file in order to update your system.

NOTE: Make sure you backup your old files before updating them, so you can go back to you original state in case you find any problems.

Let me know how it goes.

Antonio Lie.

[Antonio Lie]

Gordon,

Did you Install the patch I attached in my last post?
Could you share you experience with the forum?

Best Regards.

Antonio Lie.