Fetch data from Datagrid Row

[vh1001]

Hello AGo,

I am currently using the trial version of the SQLite Connector but I have tested this on the licenced version owned by my company and the problem persists.

Database used : World DB (From the SQLite Connector Example)
Database Table : City

I have no problem in populating the data in the DataGrid (using dataProvider)

On selecting an individual row in the DataGrid, the data shows up in the text fields, one each for ID, Name, CountryCode, District & Population.

The problem I am facing is....the "Population" field i.e. the last column of the database table, always shows up as undefined.

Method being followed
DataGridinstance.selectedItem.columnName

In fact the last column of the database table always shows up as undefined in the text field even though its value can be seen in the datagrid. The same happens with other database tables and other databases also.

Thanks in advance.

[AGo]

Have you tried it with the SQlite.as class I have sticked here?

Just recompile your App with that class and it should now work for all columns.

If you have modified your SQlite class let me know and I´ll tell you what you have to change. There was a a little bug in the AS parsing code which is propably responsible for what you are seeing.

[vh1001]

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 53: There is no method with the name 'ssCore'.
var findexe_obj = ssCore.FileSys.fileExists({path:"internal://sqlhelper.exe"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 62: There is no method with the name 'ssCore'.
var sqlite_answer = ssCore.Shell.execute({path:pathToExe, arguments:"-version", saveStdOut:"true", winState:"hidden", topmost:"false"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 92: There is no method with the name 'ssCore'.
var defaultDBexist = ssCore.FileSys.fileExists({path:defaultDB}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 96: There is no method with the name 'ssCore'.
var defaultDBatts = ssCore.FileSys.getAttrs({path:defaultDB}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 180: There is no method with the name 'ssCore'.
var sqlite_answer = ssCore.Shell.execute({path:pathToExe, arguments:exeArgs, saveStdOut:"true", winState:"hidden", topmost:"false"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 282: There is no method with the name 'ssCore'.
DBdir = ssCore.Shell.resolveMoniker({path:"startdir://"}, {sync:true}).result;

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 284: There is no method with the name 'ssCore'.
DBdir_obj = ssCore.Shell.getLongPath({pathBdir}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 291: There is no method with the name 'ssCore'.
var DBsinDir1 = ssCore.FileSys.findFiles({pathBdir, subfolders:"false", filter:"*.db", delimiter:"|"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 295: There is no method with the name 'ssCore'.
var DBsinDir2 = ssCore.FileSys.findFiles({pathBdir, subfolders:"false", filter:"*.db3", delimiter:"|"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 326: There is no method with the name 'ssCore'.
var sqlite_answer = ssCore.Shell.execute({path:pathToExe, arguments:"-readable \""+queryDB+"\"", saveStdOut:"true", winState:"hidden", topmost:"false"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 353: There is no method with the name 'ssCore'.
var sqlite_answer = ssCore.Shell.execute({path:pathToExe, arguments:"\""+queryDB+"\" \".tables\"", saveStdOut:"true", winState:"hidden", topmost:"false"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 380: There is no method with the name 'ssCore'.
var path_obj = ssCore.Shell.resolveMoniker({path:path}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 423: There is no method with the name 'ssCore'.
var inpath_obj = ssCore.Shell.resolveMoniker({path:inpath}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 464: There is no method with the name 'ssCore'.
var sqlite_answer = ssCore.Shell.execute({path:pathToExe, arguments:"\""+queryDB+"\" \"PRAGMA table_info('"+checktable+"');\"", saveStdOut:"true", winState:"hidden", topmost:"false"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 536: There is no method with the name 'ssCore'.
var sqlite_answer = ssCore.Shell.execute({path:pathToExe, arguments:"-license", saveStdOut:"true", winState:"hidden", topmost:"false"}, {sync:true});

**Error** E:\Northcode [SWF Studio Projects]\Northcode Tests\SQLite.as: Line 660: There is no method with the name 'ssCore'.
var longerg = ssCore.Shell.getLongPath({path:queryDB}, {sync:true});

Total ActionScript Errors: 16 Reported Errors: 16

This is what I am getting when I publish the .swf file in Flash.

Am I missing something.....

[AGo]

yep

http://www.northcode.com/forums/showthread.php?t=6409

[vh1001]

Thanks.....It's working.