Variables From List



If I have a list
e.g. X = [0,6,2,1,3,4,0,5,9]

I can convert it to variables like this
X = [A1, A2, A3, A4, A5, A6, A7, A8, A9]

How can I do it so that I don't instantiate any variables when the number is
0.
i.e the equivalent of
% A1=,
A2=6,
A3=2,
A4=1,
A5=3,
A6=4,
% A7=,
A8=5,
A9=9,

Because I subsequently want to do recursive searching like this
my_number(A1),
my_number(A2),
my_number(A3),
etc

Assuming that the database looks like this
my_number(1).
my_number(2).
my_number(3).
my_number(4).
my_number(5).
my_number(6).
my_number(7).
my_number(8).
my_number(9).


Clear as mud?

/Andrew


.



Relevant Pages

  • Re: custom class module- in another database
    ... > and the VB_Creatable attribute allows other databases to instantiate objects ... > won't be able to instantiate the object in another database. ... > 'Abs' is the name of a built-in VBA function. ... >> Public Property Let avviso ...
    (microsoft.public.access.modulesdaovba)
  • DataGrid and Selected Rows
    ... In the form I instantiate a DataTable object. ... I have a DataGrid on the form which is bound to the *second* ... How can I iterate through the rows of the grid and see which ones are ... Keep in mind that the DataGrid is not bound to the Access database, ...
    (microsoft.public.dotnet.framework.adonet)
  • DAO data control or DAO instantiation
    ... that run multiple queries against a database. ... Lately I have seen that most programmers instantiate this when they ... Which is better on memory? ... My question is not just for DAO, ADO also has a data control or I can ...
    (microsoft.public.dotnet.framework.adonet)
  • DAO (Instantiate as Object or use the Data Control)
    ... that run multiple queries against a database. ... Lately I have seen that most programmers instantiate this when they ... Which is better on memory? ... My question is not just for DAO, ADO also has a data control or I can ...
    (comp.databases.ms-access)
  • Re: public abstract static ...
    ... | I don't think it's meaningful to instantiate an instance of an object only ... | public class Customer: EntityBase ... | to get an entity from the database just to be able to delete it. ... Then how about factoring out the retrieval behaviour, ...
    (microsoft.public.dotnet.languages.csharp)