-
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.
Code:
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]
-
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?
-
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??
