Database and Print questions

[thickbrain]

I am investigating the best Flash standalone third party tool to integrate kwith our application. I have installed the SWFKit demo and played a bit.

Although I didn't test the DB access speed yet, I'm impress with the level of control provided by SWFKit. I did encounter few problems though:

1. record = conn.Execute("select textValue from options where ID=21"); returns undefine
while
record = conn.Execute("select * from options where ID=21"); returns the proper value.

The Flash application is already working in conjonction with ASP/IIS on an standalone computer and the record = conn.Execute("select textValue from options where ID=21"); works fine. Why it doesn't work within SWFKit?

2. How can I used a field name instead of its numerical position in the DB table?

var1 = record.Fields("firstname").Value.toString();
instead of
var1 = record.Fields(2).Value.toString();

Also, printing is another area where we need functionality. How SWFKit can help us print formatted report like with CrystalReport? I gather that you can output the value to a text file but how can you control the text appearance (Bold, font size, etc).

Thankx.

[Madcha]

Can't be of anyhelp for the print pb, but 4 your database question:

1°) when u call a SQL statement you should allways put the key field (if any) in your SQL string if you want a single value or not, anyhow you will get an empty result.

2°) u can use record.Fields["firstname"].Value.toString(); if u want to used the field name 'cuze it's not very eazy to deal with field number.

But, in most cases it's quicker and much more evident to use field numbers when dealing with special fields that have particular values.