Getting Started with the Force.com Toolkit for Adobe AIR and Flex

[THM068]

Hie mate ,

I am getting this error :

offline but we will succeed at logging in anyways

query - offline

Error: Error #3104: A SQLConnection must be open to perform this operation.

at Error$/throwError()

at flash.data::SQLStatement/check­Allowed()

at flash.data::SQLStatement/check­Ready()

at flash.data::SQLStatement/execu­te()

at com.salesforce::AIRConnection/­query()

[reppin505]

Wow, looks like Flex is the way to go when developing web services to integrate with your salesforce data.

Question, when you say the data is being cache'd into the database, are you speaking of Salesforce as the dB, or a seperate dB? Thanks.

[carrolldave]

The data is cached in a sqlLite db on the local computer. When the app detects that it is offline, it automatically switches to the local db for all data interaction. Once back online, if there were any modifications, additions or deletions to the data, then that is automatically "replayed" to the salesforce db.

[reppin505]

Perfect, thanks for the respnose. I went throught the tutorial this morning and got to work. Now i have the direction to get this to work with my CMS and mySQL. Thanks again Dave.

[roswellsc]

bro.. I've been developing in Flex for 4 years now.. and it's the most amazing development tool... And integration with sales force it's great!.. Right now I'm having some troubles but i'm working on that

[georgepeden]

When I run this code get this error:

query - offline

SQLError: 'Error #3115: SQL Error.', details:'no such table: 'Contact'', operation:'execute', detailID:'2013'

SELECT Id, LastName FROM `Contact`;

SQLError: 'Error #3115: SQL Error.', details:'no such table: 'Contact'', operation:'execute', detailID:'2013'

SELECT Id, LastName FROM `Contact`;

why are you online by default from the login and I am not?

[carrolldave]

Sounds like you may be using the Free Edition which does not include the Contacts object. Try changing the SOQL statement to an object that you know you have.

[rodsayers]

This makes it look simple. Thanks!