SQL report help

[markstaylor]

Need help with this code.

I run a query based on what the user selected and pull all data that matches the query DECRYPTIT then send to a grid object. It's not working correct.

I get random results. If i select recordid and name only the name is displayed but in the record id column and nothing is in the name field.

PLEASE HELP.



if sqlString ~= "" then
tbResults = SQLite.QueryToTable(db, sqlString);

TextFile.WriteFromString("AutoPlay\\Docs\\report.csv", headerString .."\r\n", false);

for nRow =1, tbResults.Rows do

sRowData = "";

for nCol = 1, tbResults.Columns do

sRowData = Crypto.BlowfishDecryptString(tbResults.Data[nRow][tbResults.ColumnNames[nCol]],"passoword")
sRowData= String.Replace(sRowData, "\r\n", " ");
sRowData= sRowData ..",";
end

TextFile.WriteFromString("AutoPlay\\Docs\\report.csv", sRowData .."\r\n", true);

end
DialogEx.Show("ReportResults", true, nil, nil);
end

[Dermot]

With your code sRowData will only ever contain data from one column. Try this


sRowData = sRowData..Crypto.BlowfishDecryptString(tbResults.D ata[nRow][tbResults.ColumnNames[nCol]],"passoword")
sRowData = String.Replace(sRowData, "\r\n", " ");
sRowData= sRowData ..",";

Why not just put the data straight into the grid instead of writing out to a file?

[markstaylor]

That did work, thanks BUT the record ID is blank.

I couldn't get the data to the grid with the header without writing it to a csv file first. Man if you can help with that to that would be greatly appreciated.

[Dermot]

Without knowing what the database looks like, its hard to know. Maybe post your app or at least a scaled down version.

[RizlaUK]

I couldn't get the data to the grid with the header without writing it to a csv file first. Man if you can help with that to that would be greatly appreciated.

look at the below example, it contains some functions for loading sqlite directly into the grid :yes

http://www.indigorose.com/forums/showpost.php?p=125215&postcount=7