Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-07-2009
Member
 
Join Date: Feb 2009
Posts: 71
How to write SQL statement to get all data

A SQLStatement instance is linked to a SQLConnection but i have problem about how do I write a SQL statement to get the data stored in the table when we called subscrib? I have set up instance by setting up the SQLConnection instance as the value of the SQLStatement instance's sqlConnection property. In addition, in synchronous mode if the methods fail the runtime throws an exception rather than dispatching an error event.
Reply With Quote
  #2  
Old 31-07-2009
Member
 
Join Date: Mar 2008
Posts: 672
Re: How to write SQL statement to get all data

SQL represents an SQL statement. SQL statements are used internally to Data:: ObjectDriver:: Driver :: DBI object drivers to convert database operations, The ExecuteDataReader function is defined to be public and static (shared in VB). In asynchronous execution mode, the execute() and next() methods are executed in the background, and the runtime dispatches events to registered event listeners. It is public so it can be called from any other code.
Reply With Quote
  #3  
Old 31-07-2009
Member
 
Join Date: Mar 2008
Posts: 433
Re: How to write SQL statement to get all data

select_map (hashref)

The map of database column names to object fields in a SELECT query. Use this mapping to convert members of the select list to column names.The function has two parameters. The first is the SQL statement. Since this code returns a single stream of data, it assumes that the SQL statement contains one Select statement. For a complete description of the SQL dialect supported in local SQL databases, see the appendix SQL support in local databases.
Reply With Quote
  #4  
Old 31-07-2009
Member
 
Join Date: Oct 2008
Posts: 180
Re: How to write SQL statement to get all data

This code can not use a Using statement because a single AIR application can access one or many separate databases (i.e. separate database files) and using statement closes the connection at the end of the statement. A SQLStatement instance is used to execute a SQL statement against a local SQL database that is open through a SQLConnection instance. A developer can specify the location in the file system where the database file is stored.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to write SQL statement to get all data"
Thread Thread Starter Forum Replies Last Post
My data drive is write protected, how do I fix this KEATON! Windows x64 Edition 4 09-10-2010 07:48 AM
?Torrent can not write data to hdd Chadwick Windows Software 4 21-06-2010 09:54 AM
How to insert artificial data into a select statement? MAHAH Software Development 5 12-03-2010 09:03 PM
How to write a SQL statement in Visual Basic? - Empty Shell - Software Development 4 27-02-2010 03:54 AM
What is Data Flow Diagrams and how to write it Steyn Windows Software 3 18-05-2009 06:44 PM


All times are GMT +5.5. The time now is 12:37 AM.