I need to query a db and eventually split the data results into temp files.
I need to query a database based on three fields “myID”, “myTry” and “myDate”. Myid is a client id number, myTry is the number of times they have been contacted, and myDate is the particular time when a notification is set to go out.
I need to query the database once (select myID, myTry, myAmt, myItem from mytable where myDate = '" & txtMYDATE.text &"'). A user enters in myDate. I need to create an array that will split the data into groups:
All of the
myId's = 00001 and myTry = 1 need to be grouped together
myId's = 00001 and myTry = 2 need to be grouped together
myId's = 00002 and myTry = 1 need to be grouped together
Each result set needs to be written into temp files (csv, txt).