1. #1
    Ext User
    Join Date
    Sep 2007
    Posts
    9
    Vote Rating
    0
    Enygma is on a distinguished road

      0  

    Default Ext.sql

    Ext.sql


    Hi all,

    I'm interested in doing a little bit of work with Ext and AIR and I've played around a little with the Sample Tasks application. What's not entirely clear to me is how the data access code works. I can't find any documentation on Ext.sql

    Is there any overview of how to create a connection, create a table and perform operations on that table?

    Thanks!

  2. #2
    Ext User
    Join Date
    Mar 2007
    Posts
    4
    Vote Rating
    0
    raulbuta is on a distinguished road

      0  

    Default create table

    create table


    Hi Enygma, init with Simple Task v2 if you want desktop app. To create table put this code in Ext.onReady(function(){:
    tx.data.conn.open('tasks.db'); // connection with the database file
    var sql = "";
    sql += "CREATE TABLE IF NOT EXISTS my_table_name( ";
    sql += "fieldId INTEGER PRIMARY KEY AUTOINCREMENT, ";
    sql += "field1 INTEGER, ";
    sql += "field2 TEXT, ";
    sql += "field3 TEXT, ";
    sql += "field4 DATE, ";
    sql += "field5 TEXT, ";
    sql += "field6 VARCHAR(255), ";
    sql += "field7 NUMERIC CHECK (field7 >= 0) DEFAULT 0";
    sql += ")";

    tx.data.conn.exec(sql); // this will create a table in database file.
    I hope
    Sorry my enghish.

  3. #3
    Ext User
    Join Date
    Sep 2007
    Posts
    9
    Vote Rating
    0
    Enygma is on a distinguished road

      0  

    Default


    Hi,

    Thanks for that. I've been doing a little investigation and figured out how the SQL connection stuff works, it's actually dead simple as you pointed out (duh!)
    I'm currently playing about with the TaskStore and Proxy classes to figure out whats going on there.

    From my understanding the Proxy class provides a generic way of loading the data from the database whilst the Store (which contains the Proxy) provides the application with the mechanism for inserting, updating etc.

    I think anyway...

Thread Participants: 1

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi