SQL Lite and QM

[stupomer]

Thanks Gintaras,
I got it so the columns are properly formatted EXCEPT for the ones that have data entered into them via the dbl.Exec method

Function CaseLogDisplay_FromEntryDialog

Code:

Copy      Help

db1.Open(CaseLogUserFile)
str+ InsertDemogs;;.format("INSERT INTO 'CaseLog' VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" FollowUp DxFindings PtName PtMRN ACCN ExamDate ExamName DC1 DC2 DC3 DC4 cb4 PathStatus PathStatus cb15 cb15)
db1.Exec(InsertDemogs)

I format the qmgrid columns in the case WM_INITDIALOG step, like this:

Function CaseLogDisplay_FromEntryDialog

Code:

Copy      Help

CSqlite- t_db
sel message
,case WM_INITDIALOG
,t_db.Open(CaseLogUserFile)        
,t_db.ToQmGrid(id(3 hDlg) "SELECT * FROM CaseLog" 0 "FU[]FINDINGS[]NAME[]MRN[]ACCN[]DATE[]EXAM[]Dz Category 1[]Dz Category 2[]Custom Tag 1[]Custom Tag 2[]Interest Type[]Path Pending?[]Path Dx[]SharedFrom[]SharedWith" "50[]200[]150[]75[]75[]100[]125[]125[]125[]125[]125[]125[]85[]150[]150[]150")
,int+ g=id(3 hDlg)
,SendMessage g LVM_QG_SETCOLUMNTYPE 0 QG_CHECK
,SendMessage g LVM_QG_SETCOLUMNTYPE 1 QG_EDIT|QG_EDIT_MULTILINE
,SendMessage g LVM_QG_SETCOLUMNTYPE 6 QG_COMBO
,SendMessage g LVM_QG_SETCOLUMNTYPE 7 QG_COMBO
,SendMessage g LVM_QG_SETCOLUMNTYPE 8 QG_COMBO
,SendMessage g LVM_QG_SETCOLUMNTYPE 9 QG_COMBO
,SendMessage g LVM_QG_SETCOLUMNTYPE 10 QG_COMBO
,SendMessage g LVM_QG_SETCOLUMNTYPE 11 QG_COMBO
,SendMessage g LVM_QG_SETCOLUMNTYPE 12 QG_CHECK    
,case WM_DESTROY
,case WM_COMMAND goto messages2
,case WM_NOTIFY goto messages3
ret

Am I doing the formatting in the wrong place? It's strange that everything tht already has something entered into it, doesn't respond to the formatting (acts like text edit only i.e. gridNotify2 just registeres begin and end edits).
But fields in blank rows, do respond (i.e. trigger to gridNotify2 properly)

Any ideas where I might be messing up the code?

Thanks, Stuart