Arrays

[kanejone]

Hi guys
I'm looking for help with arrays. I have a slight problem with running a program on a few computers and am trying to figure out whats wrong.

Dim Userss As dynaset
Dim UserAudit As Table
    Userss.Edit
    Userss![Expiry Date] = Format$(Date + PasswordExpiry, "dd/mm/yyyy")
Call logtofile(DebugLog, ":Problem is here")
   ' What I'm trying to do after this is  declare an array of type variant and put the values that are  in the Userss![Expiry Date] = Format$(Date + PasswordExpiry, "dd/mm/yyyy") into it.???
' Then what I want to do is is print all these values to a log file.
'I have the log file bit already, I just don't know how to print the values of a table to it.

I would appreciate the help. Thanks a lot
JK


[Edited by kanejone on 09-18-2000 at 07:00 AM]

[HarryW]

I don't know about dynasets, but with recordsets you have to loop through each record and explicitly work with the data, you can't just print a whole recordset to a log file in one or two commands.

Is that what you're trying to do?

[kanejone]

Thanks for the reply. Ye, that's what I was trying to do. I was trying to dim XXX as Variant an then use getRows to show the values of the RS. Is there any way this can be done??