jamesbondski / qvdlib Goto Github PK

using System.IO;
using System.Text;
using Bondski.QvdLib;

Console.WriteLine("Hello, World!");

var fileName = "C:\\Transactions.qvd";
QvdReader reader = new QvdReader(fileName);
var data = new List<List<string>>();

var headerRow = new List<string>();
foreach (var fieldName in reader.Header.Fields)
{
    headerRow.Add(fieldName.Name);
}
data.Add(headerRow);

var capRows = false;
var maxRowCount = 10000;
var iterator = 0;
while (reader.NextRow() && (iterator < maxRowCount || !capRows))
{
    var row = new List<string>();

    foreach (var fieldName in reader.Header.Fields)
    {
        row.Add(reader[fieldName.Name].ToString());
    }

    data.Add(row);
    iterator++;
}

Console.WriteLine("test");

Characters:
Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;
 
ASCII:
Load 
 if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,
 Chr(RecNo()) as AsciiAlpha, 
 RecNo() as AsciiNum
autogenerate 255
 Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;
 
Transactions:
Load
 TransLineID, 
 TransID,
 mod(TransID,26)+1 as Num,
 Pick(Ceil(3*Rand1),'A','B','C') as Dim1,
 Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,
 Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,
 Round(1000*Rand()*Rand()*Rand1) as Expression1,
 Round(  10*Rand()*Rand()*Rand1) as Expression2,
 Round(Rand()*Rand1,0.00001) as Expression3;
Load 
 Rand() as Rand1,
 IterNo() as TransLineID,
 RecNo() as TransID
Autogenerate 1000
 While Rand()<=0.5 or IterNo()=1;

 Comment Field Dim1 With "This is a field comment";

STORE Transactions into "Transactions.qvd" (qvd);