Changeset 822 for BMXNET_RPMS_dotNET_UTILITIES-BMX/trunk/cs/bmx_0200scr/BMX2/BMXNet/RPMSDb.cs

Timestamp:

Jul 6, 2010, 8:09:10 AM (14 years ago)

Author:

Sam Habiel

Message:

Support for other encodings besides ASCII. Constructors available in BMXNetLib and and BMXNetConnectInfo.
Comments in several files.

File:

• BMXNET_RPMS_dotNET_UTILITIES-BMX/trunk/cs/bmx_0200scr/BMX2/BMXNet/RPMSDb.cs (modified) (7 diffs)

BMXNET_RPMS_dotNET_UTILITIES-BMX/trunk/cs/bmx_0200scr/BMX2/BMXNet/RPMSDb.cs

@@ -165 +165 @@
                                 Type tType;
 
-                                int nTemp = 10;
+                                int nTemp = 10; //length of @@@meta@@@
+                //actual header
                                 sHeader = sHeader.Substring(10,(sHeader.Length - nTemp));
                                 string[] sRecordSetInfo = sHeader.Split(cFldDelim);
 
+                //substract one because 1st item is RecordId|File# -- rest is columns
                                 numCols = sRecordSetInfo.GetLength(0)-1;
                                 m_aResultSets[nSet].metaData = new RPMSDbResultSet.MetaData[numCols];
 
-                                //First ^-Piece is recordset-level info: RecordIdentifier|File#
+                                //Set FileID
+                //First ^-Piece is recordset-level info: RecordIdentifier|File#
                                 string[] sRecordInfo = sRecordSetInfo[0].Split(cBar);
                                 m_aResultSets[nSet].fmFileID = sRecordInfo[1];
+
+                //What is the seed???
                                 if (sRecordInfo.GetLength(0) > 2)
                                 {
@@ -190 +195 @@
                                 }
 
+                // Foreign key is included
                                 if (sRecordInfo.GetLength(0) > 3)
                                 {
@@ -197 +203 @@
 
                                         m_aResultSets[nSet].fmKeyField = "";
-                                //2nd through nth ^-Pieces are Column info: Fileman File#FileMan Field#|DataType|Field Length|Column Name|IsReadOnly|IsKeyField
+                                //2nd through nth ^-Pieces are Column info: Fileman File#|FileMan Field#|DataType|Field Length|Column Name|IsReadOnly|IsKeyField|????
                                 for (j=1; j < sRecordSetInfo.GetLength(0); j++)
                                 {
@@ -208 +214 @@
                                         //Field 5 = IsReadOnly
                                         //Field 6 = IsKeyField
+                    //Field 7 {MISSING}
                                         sFileID = sColumnInfo[0];
                                         string sFieldID = sColumnInfo[1];
@@ -302 +309 @@
                         string sFldDelim = "^";
                         char[] cFldDelim = sFldDelim.ToCharArray();
+            // nRecords-1 because last record is empty (Where $C(31) (end of record) is)
                         m_aResultSets[nSet].data = new object[nRecords-1, numCols];
                         string[] saRecord;
@@ -310 +318 @@
                                 for (int k = 0; k< saRecord.GetLength(0); k++)
                                 {
+                    //Date Time validation
+                    //TODO: Support Fileman DateTime
                                         if (m_aResultSets[nSet].metaData[k].type == typeof(DateTime))
                                         {
@@ -385 +395 @@
                         int             nRecordSetCount;        //Count of recordsets
 
+            //Gets Records[sets] (val is number of records for each set), Headers[sets] (val is header location in array), and number of record sets.
                         IndexRecords(sResultArray, out naRecords, out naHeaderIndex, out nRecordSetCount);
+            //Create array of result sets
                         m_aResultSets = new RPMSDbResultSet[nRecordSetCount];