How do I put my function in an SQL query?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 11 of 11

Thread: How do I put my function in an SQL query?

  1. #1
    Dav Guest

    How do I put my function in an SQL query?


    I'm trying to figure out a way to add my function (or rather, the result of)
    to an SQL query as a sorted column. Has anyone ever done this? It seems
    like it shouldn't be to hard (I hope.)

    Basically...

    I have a table with 2 fields (a & b).

    I desire for the output to be a, b, c. Sorted on c.

    c = the result of a function that takes a and b, does some process, and then
    returns a computed result.

    The SQL might look something like...

    SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    FROM db
    ORDER BY c

    Since I can similarly process data and yeild a result with the SUM function,
    I would imagine this is possible to do with a function of my own. Just where
    in the world do I put my function so it is avaiable to the query?????

    Any help would be much appreciated!!!

  2. #2
    Russ Guest

    Re: How do I put my function in an SQL query?


    "Dav" <dav@dhsports.com> wrote:
    >
    >I'm trying to figure out a way to add my function (or rather, the result

    of)
    >to an SQL query as a sorted column. Has anyone ever done this? It seems
    >like it shouldn't be to hard (I hope.)
    >
    >Basically...
    >
    >I have a table with 2 fields (a & b).
    >
    >I desire for the output to be a, b, c. Sorted on c.
    >
    >c = the result of a function that takes a and b, does some process, and

    then
    >returns a computed result.
    >
    >The SQL might look something like...
    >
    >SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    >FROM db
    >ORDER BY c
    >
    >Since I can similarly process data and yeild a result with the SUM function,
    >I would imagine this is possible to do with a function of my own. Just

    where
    >in the world do I put my function so it is avaiable to the query?????
    >
    >Any help would be much appreciated!!!


    Dav,
    What database are you using. If you are using Access, you can put the function
    in a standard module. If you are using something else like Oracle, you can
    create a stored function to do this.

    -Russ.

  3. #3
    Dav Guest

    Re: How do I put my function in an SQL query?


    "Russ" <russell.thompson@adlink.com> wrote:
    >
    >"Dav" <dav@dhsports.com> wrote:
    >>
    >>I'm trying to figure out a way to add my function (or rather, the result

    >of)
    >>to an SQL query as a sorted column. Has anyone ever done this? It seems
    >>like it shouldn't be to hard (I hope.)
    >>
    >>Basically...
    >>
    >>I have a table with 2 fields (a & b).
    >>
    >>I desire for the output to be a, b, c. Sorted on c.
    >>
    >>c = the result of a function that takes a and b, does some process, and

    >then
    >>returns a computed result.
    >>
    >>The SQL might look something like...
    >>
    >>SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    >>FROM db
    >>ORDER BY c
    >>
    >>Since I can similarly process data and yeild a result with the SUM function,
    >>I would imagine this is possible to do with a function of my own. Just

    >where
    >>in the world do I put my function so it is avaiable to the query?????
    >>
    >>Any help would be much appreciated!!!

    >
    >Dav,
    >What database are you using. If you are using Access, you can put the function
    >in a standard module. If you are using something else like Oracle, you

    can
    >create a stored function to do this.
    >
    >-Russ.


    Russ,
    Thanks for your response. I'm using Access as the db and VB6.

    I tried doing something like you suggested, I think. I'm using the Data
    Enviroment to connect to the Access database. I put a function called 'Public
    Function MyFunc( s AS String) AS String' in a module in my project. Using
    the Query designer I coded the SQL with one of the fields as 'myfunc() As
    MyFunction'. Then I run the query (in design-time.) I thought that would
    do it, but I'm getting an error myfunc is valid/found...

    I guess I'm just having problems figuring out where to/how to expose my function
    to the sql query.

  4. #4
    Arthur Wood Guest

    Re: How do I put my function in an SQL query?


    Dav,
    What you are trying to do CANNOT be done, directly. Access and the JET
    engine will not recognize your function, much less be able to evaluate it.
    What you will need to do is to do the calculation AFTER the fact. That is
    , run the query to get the values of A and B, then loop through the recordset,
    saving into an array of User Defined Type, the values of a, b and c(the result
    of your calcualtion on a and b). Once that array has been filled, then you
    can sort the array on the value of c. Tedious, but that is the way life
    is sometimes.


    Arthur Wood

    "Dav" <dav@dhsports.com> wrote:
    >
    >"Russ" <russell.thompson@adlink.com> wrote:
    >>
    >>"Dav" <dav@dhsports.com> wrote:
    >>>
    >>>I'm trying to figure out a way to add my function (or rather, the result

    >>of)
    >>>to an SQL query as a sorted column. Has anyone ever done this? It seems
    >>>like it shouldn't be to hard (I hope.)
    >>>
    >>>Basically...
    >>>
    >>>I have a table with 2 fields (a & b).
    >>>
    >>>I desire for the output to be a, b, c. Sorted on c.
    >>>
    >>>c = the result of a function that takes a and b, does some process, and

    >>then
    >>>returns a computed result.
    >>>
    >>>The SQL might look something like...
    >>>
    >>>SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    >>>FROM db
    >>>ORDER BY c
    >>>
    >>>Since I can similarly process data and yeild a result with the SUM function,
    >>>I would imagine this is possible to do with a function of my own. Just

    >>where
    >>>in the world do I put my function so it is avaiable to the query?????
    >>>
    >>>Any help would be much appreciated!!!

    >>
    >>Dav,
    >>What database are you using. If you are using Access, you can put the

    function
    >>in a standard module. If you are using something else like Oracle, you

    >can
    >>create a stored function to do this.
    >>
    >>-Russ.

    >
    >Russ,
    >Thanks for your response. I'm using Access as the db and VB6.
    >
    >I tried doing something like you suggested, I think. I'm using the Data
    >Enviroment to connect to the Access database. I put a function called 'Public
    >Function MyFunc( s AS String) AS String' in a module in my project. Using
    >the Query designer I coded the SQL with one of the fields as 'myfunc() As
    >MyFunction'. Then I run the query (in design-time.) I thought that would
    >do it, but I'm getting an error myfunc is valid/found...
    >
    >I guess I'm just having problems figuring out where to/how to expose my

    function
    >to the sql query.



  5. #5
    Dav Guest

    Re: How do I put my function in an SQL query?


    Authur,

    Thanks for your reply. Wasn't what I wanted to hear even though I feared
    that. In the future I'll probably. port over to SQL server. Can I do what
    I'm talking about, using stored proceedures?

    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Dav,
    > What you are trying to do CANNOT be done, directly. Access and the JET
    >engine will not recognize your function, much less be able to evaluate it.
    > What you will need to do is to do the calculation AFTER the fact. That

    is
    >, run the query to get the values of A and B, then loop through the recordset,
    >saving into an array of User Defined Type, the values of a, b and c(the

    result
    >of your calcualtion on a and b). Once that array has been filled, then

    you
    >can sort the array on the value of c. Tedious, but that is the way life
    >is sometimes.
    >
    >
    >Arthur Wood
    >
    >"Dav" <dav@dhsports.com> wrote:
    >>
    >>"Russ" <russell.thompson@adlink.com> wrote:
    >>>
    >>>"Dav" <dav@dhsports.com> wrote:
    >>>>
    >>>>I'm trying to figure out a way to add my function (or rather, the result
    >>>of)
    >>>>to an SQL query as a sorted column. Has anyone ever done this? It seems
    >>>>like it shouldn't be to hard (I hope.)
    >>>>
    >>>>Basically...
    >>>>
    >>>>I have a table with 2 fields (a & b).
    >>>>
    >>>>I desire for the output to be a, b, c. Sorted on c.
    >>>>
    >>>>c = the result of a function that takes a and b, does some process, and
    >>>then
    >>>>returns a computed result.
    >>>>
    >>>>The SQL might look something like...
    >>>>
    >>>>SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    >>>>FROM db
    >>>>ORDER BY c
    >>>>
    >>>>Since I can similarly process data and yeild a result with the SUM function,
    >>>>I would imagine this is possible to do with a function of my own. Just
    >>>where
    >>>>in the world do I put my function so it is avaiable to the query?????
    >>>>
    >>>>Any help would be much appreciated!!!
    >>>
    >>>Dav,
    >>>What database are you using. If you are using Access, you can put the

    >function
    >>>in a standard module. If you are using something else like Oracle, you

    >>can
    >>>create a stored function to do this.
    >>>
    >>>-Russ.

    >>
    >>Russ,
    >>Thanks for your response. I'm using Access as the db and VB6.
    >>
    >>I tried doing something like you suggested, I think. I'm using the Data
    >>Enviroment to connect to the Access database. I put a function called

    'Public
    >>Function MyFunc( s AS String) AS String' in a module in my project. Using
    >>the Query designer I coded the SQL with one of the fields as 'myfunc()

    As
    >>MyFunction'. Then I run the query (in design-time.) I thought that would
    >>do it, but I'm getting an error myfunc is valid/found...
    >>
    >>I guess I'm just having problems figuring out where to/how to expose my

    >function
    >>to the sql query.

    >



  6. #6
    Arthur Wood Guest

    Re: How do I put my function in an SQL query?


    Dav,
    Depends on how complicated what you are trying to do, is. I cannot give
    you any specifics, as where I work, we all use Access for tha back-end at
    this point in time. We may be migrating to SQL Server in the future, but
    even that is not very definite.

    Arthur Wood


    "Dav" <dav@dh.com> wrote:
    >
    >Authur,
    >
    >Thanks for your reply. Wasn't what I wanted to hear even though I feared
    >that. In the future I'll probably. port over to SQL server. Can I do

    what
    >I'm talking about, using stored proceedures?
    >
    >"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>
    >>Dav,
    >> What you are trying to do CANNOT be done, directly. Access and the

    JET
    >>engine will not recognize your function, much less be able to evaluate

    it.
    >> What you will need to do is to do the calculation AFTER the fact. That

    >is
    >>, run the query to get the values of A and B, then loop through the recordset,
    >>saving into an array of User Defined Type, the values of a, b and c(the

    >result
    >>of your calcualtion on a and b). Once that array has been filled, then

    >you
    >>can sort the array on the value of c. Tedious, but that is the way life
    >>is sometimes.
    >>
    >>
    >>Arthur Wood
    >>
    >>"Dav" <dav@dhsports.com> wrote:
    >>>
    >>>"Russ" <russell.thompson@adlink.com> wrote:
    >>>>
    >>>>"Dav" <dav@dhsports.com> wrote:
    >>>>>
    >>>>>I'm trying to figure out a way to add my function (or rather, the result
    >>>>of)
    >>>>>to an SQL query as a sorted column. Has anyone ever done this? It

    seems
    >>>>>like it shouldn't be to hard (I hope.)
    >>>>>
    >>>>>Basically...
    >>>>>
    >>>>>I have a table with 2 fields (a & b).
    >>>>>
    >>>>>I desire for the output to be a, b, c. Sorted on c.
    >>>>>
    >>>>>c = the result of a function that takes a and b, does some process,

    and
    >>>>then
    >>>>>returns a computed result.
    >>>>>
    >>>>>The SQL might look something like...
    >>>>>
    >>>>>SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    >>>>>FROM db
    >>>>>ORDER BY c
    >>>>>
    >>>>>Since I can similarly process data and yeild a result with the SUM function,
    >>>>>I would imagine this is possible to do with a function of my own. Just
    >>>>where
    >>>>>in the world do I put my function so it is avaiable to the query?????
    >>>>>
    >>>>>Any help would be much appreciated!!!
    >>>>
    >>>>Dav,
    >>>>What database are you using. If you are using Access, you can put the

    >>function
    >>>>in a standard module. If you are using something else like Oracle, you
    >>>can
    >>>>create a stored function to do this.
    >>>>
    >>>>-Russ.
    >>>
    >>>Russ,
    >>>Thanks for your response. I'm using Access as the db and VB6.
    >>>
    >>>I tried doing something like you suggested, I think. I'm using the Data
    >>>Enviroment to connect to the Access database. I put a function called

    >'Public
    >>>Function MyFunc( s AS String) AS String' in a module in my project. Using
    >>>the Query designer I coded the SQL with one of the fields as 'myfunc()

    >As
    >>>MyFunction'. Then I run the query (in design-time.) I thought that would
    >>>do it, but I'm getting an error myfunc is valid/found...
    >>>
    >>>I guess I'm just having problems figuring out where to/how to expose my

    >>function
    >>>to the sql query.

    >>

    >



  7. #7
    Bob Rouse Guest

    Re: How do I put my function in an SQL query?


    If you can code your function as part of a series of multi-line SQL commands,
    you can do just about anything inside a stored procedure. However, you cannot
    call a stored procedure as part of another SQL Command. In other words, you
    cannot do something like:

    Select Name, Address, sp_GetAvgSalary

    This is because when calling a stored procedure using a SQL command, it needs
    to be prefaced with the "Exec" command. You can call stored procedures using
    ADO or RDO (but again, not as part of a SQL statement).

    In short, either you need to do the function stuff in your app, or in a stored
    procedure. The stored procedure method would be preferred, since it takes
    advantage of the servers power, its proximity to the data, and if you need
    to make changes, you don't need to recompile and redistribute your app.

    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Dav,
    > Depends on how complicated what you are trying to do, is. I cannot give
    >you any specifics, as where I work, we all use Access for tha back-end at
    >this point in time. We may be migrating to SQL Server in the future, but
    >even that is not very definite.
    >
    >Arthur Wood
    >
    >
    >"Dav" <dav@dh.com> wrote:
    >>
    >>Authur,
    >>
    >>Thanks for your reply. Wasn't what I wanted to hear even though I feared
    >>that. In the future I'll probably. port over to SQL server. Can I do

    >what
    >>I'm talking about, using stored proceedures?
    >>
    >>"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>>
    >>>Dav,
    >>> What you are trying to do CANNOT be done, directly. Access and the

    >JET
    >>>engine will not recognize your function, much less be able to evaluate

    >it.
    >>> What you will need to do is to do the calculation AFTER the fact. That

    >>is
    >>>, run the query to get the values of A and B, then loop through the recordset,
    >>>saving into an array of User Defined Type, the values of a, b and c(the

    >>result
    >>>of your calcualtion on a and b). Once that array has been filled, then

    >>you
    >>>can sort the array on the value of c. Tedious, but that is the way life
    >>>is sometimes.
    >>>
    >>>
    >>>Arthur Wood
    >>>
    >>>"Dav" <dav@dhsports.com> wrote:
    >>>>
    >>>>"Russ" <russell.thompson@adlink.com> wrote:
    >>>>>
    >>>>>"Dav" <dav@dhsports.com> wrote:
    >>>>>>
    >>>>>>I'm trying to figure out a way to add my function (or rather, the result
    >>>>>of)
    >>>>>>to an SQL query as a sorted column. Has anyone ever done this? It

    >seems
    >>>>>>like it shouldn't be to hard (I hope.)
    >>>>>>
    >>>>>>Basically...
    >>>>>>
    >>>>>>I have a table with 2 fields (a & b).
    >>>>>>
    >>>>>>I desire for the output to be a, b, c. Sorted on c.
    >>>>>>
    >>>>>>c = the result of a function that takes a and b, does some process,

    >and
    >>>>>then
    >>>>>>returns a computed result.
    >>>>>>
    >>>>>>The SQL might look something like...
    >>>>>>
    >>>>>>SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    >>>>>>FROM db
    >>>>>>ORDER BY c
    >>>>>>
    >>>>>>Since I can similarly process data and yeild a result with the SUM

    function,
    >>>>>>I would imagine this is possible to do with a function of my own.

    Just
    >>>>>where
    >>>>>>in the world do I put my function so it is avaiable to the query?????
    >>>>>>
    >>>>>>Any help would be much appreciated!!!
    >>>>>
    >>>>>Dav,
    >>>>>What database are you using. If you are using Access, you can put the
    >>>function
    >>>>>in a standard module. If you are using something else like Oracle,

    you
    >>>>can
    >>>>>create a stored function to do this.
    >>>>>
    >>>>>-Russ.
    >>>>
    >>>>Russ,
    >>>>Thanks for your response. I'm using Access as the db and VB6.
    >>>>
    >>>>I tried doing something like you suggested, I think. I'm using the Data
    >>>>Enviroment to connect to the Access database. I put a function called

    >>'Public
    >>>>Function MyFunc( s AS String) AS String' in a module in my project.

    Using
    >>>>the Query designer I coded the SQL with one of the fields as 'myfunc()

    >>As
    >>>>MyFunction'. Then I run the query (in design-time.) I thought that would
    >>>>do it, but I'm getting an error myfunc is valid/found...
    >>>>
    >>>>I guess I'm just having problems figuring out where to/how to expose

    my
    >>>function
    >>>>to the sql query.
    >>>

    >>

    >



  8. #8
    Russ Guest

    Re: How do I put my function in an SQL query?


    "Bob Rouse" <brouse@netuitive.com> wrote:
    >
    >If you can code your function as part of a series of multi-line SQL commands,
    >you can do just about anything inside a stored procedure. However, you cannot
    >call a stored procedure as part of another SQL Command. In other words,

    you
    >cannot do something like:
    >
    >Select Name, Address, sp_GetAvgSalary
    >
    >This is because when calling a stored procedure using a SQL command, it

    needs
    >to be prefaced with the "Exec" command. You can call stored procedures using
    >ADO or RDO (but again, not as part of a SQL statement).
    >
    >In short, either you need to do the function stuff in your app, or in a

    stored
    >procedure. The stored procedure method would be preferred, since it takes
    >advantage of the servers power, its proximity to the data, and if you need
    >to make changes, you don't need to recompile and redistribute your app.
    >


    Just to clarify all that has been said and what was originally asked...
    As Bob is saying, it depends on what your function is doing. As long as
    your function is doing a single row operation this WILL work WITHIN the database.
    For example-

    Test Table "db"-
    a b
    5 6
    3 4
    7 8
    1 2

    Using a function in a standard module...
    Public Function MyFunc(n1 As Integer, n2 As Integer) As Integer
    MyFunc = n1 + n2
    End Function


    then, refering back to Dav's original post-
    > SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    > FROM db
    > ORDER BY c <--This is wrong..


    This is perfectly valid except for the ORDER BY clause. You must use the
    function call, not the alias.

    SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    FROM db
    ORDER BY MyFunc(db.a, db.b);

    This query would yield...
    a b c
    1 2 3
    3 4 7
    5 6 11
    7 8 15

    This will work in both Access and Oracle. I cannot speak to SQL Server as
    we do not use it here. **However**, as Arthur pointed out, if you try to
    do this using the data environment, the data environment will not recognize
    MyFunc() and will not be able to execute this query.

    Since Dav later clarified that he was trying to use the data environment,
    this is all sort of a moot point, but, for what it's worth...

    -Russ.





  9. #9
    Douglas J. Steele Guest

    Re: How do I put my function in an SQL query?

    "Russ" <russell.thompson@adlink.com> wrote in message
    news:3aa69572$1@news.devx.com...
    >
    > "Bob Rouse" <brouse@netuitive.com> wrote:
    > >
    > >If you can code your function as part of a series of multi-line SQL

    commands,
    > >you can do just about anything inside a stored procedure. However, you

    cannot
    > >call a stored procedure as part of another SQL Command. In other words,

    > you
    > >cannot do something like:
    > >
    > >Select Name, Address, sp_GetAvgSalary
    > >
    > >This is because when calling a stored procedure using a SQL command, it

    > needs
    > >to be prefaced with the "Exec" command. You can call stored procedures

    using
    > >ADO or RDO (but again, not as part of a SQL statement).
    > >
    > >In short, either you need to do the function stuff in your app, or in a

    > stored
    > >procedure. The stored procedure method would be preferred, since it takes
    > >advantage of the servers power, its proximity to the data, and if you

    need
    > >to make changes, you don't need to recompile and redistribute your app.
    > >

    >
    > Just to clarify all that has been said and what was originally asked...
    > As Bob is saying, it depends on what your function is doing. As long as
    > your function is doing a single row operation this WILL work WITHIN the

    database.
    > For example-
    >
    > Test Table "db"-
    > a b
    > 5 6
    > 3 4
    > 7 8
    > 1 2
    >
    > Using a function in a standard module...
    > Public Function MyFunc(n1 As Integer, n2 As Integer) As Integer
    > MyFunc = n1 + n2
    > End Function
    >
    >
    > then, refering back to Dav's original post-
    > > SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    > > FROM db
    > > ORDER BY c <--This is wrong..

    >
    > This is perfectly valid except for the ORDER BY clause. You must use the
    > function call, not the alias.
    >
    > SELECT db.a AS a, db.b AS b, MyFunc(db.a, db.b) AS c
    > FROM db
    > ORDER BY MyFunc(db.a, db.b);
    >
    > This query would yield...
    > a b c
    > 1 2 3
    > 3 4 7
    > 5 6 11
    > 7 8 15
    >
    > This will work in both Access and Oracle. I cannot speak to SQL Server as
    > we do not use it here. **However**, as Arthur pointed out, if you try to
    > do this using the data environment, the data environment will not

    recognize
    > MyFunc() and will not be able to execute this query.
    >
    > Since Dav later clarified that he was trying to use the data environment,
    > this is all sort of a moot point, but, for what it's worth...
    >
    > -Russ.


    Just a comment, Russ. What you've shown will only work in Access if you're
    running within Access itself. If you're connecting to an Access database
    (or, more precisely, a Jet database) from some other client (such as VB), it
    won't work. This is because, unless you're running in Access, your only
    connection to the database is through the Jet engine, which doesn't
    understand user defined functions.

    HTH

    --

    Doug Steele, Microsoft Access MVP
    Beer, Wine and Database Programming. What could be better?
    Visit "Doug Steele's Beer and Programming Emporium"
    http://I.Am/DougSteele/






  10. #10
    Paul Clement Guest

    Re: How do I put my function in an SQL query?

    On Wed, 7 Mar 2001 20:21:12 -0500, "Douglas J. Steele" <djsteele@canada.com> wrote:


    Just a comment, Russ. What you've shown will only work in Access if you're
    running within Access itself. If you're connecting to an Access database
    (or, more precisely, a Jet database) from some other client (such as VB), it
    won't work. This is because, unless you're running in Access, your only
    connection to the database is through the Jet engine, which doesn't
    understand user defined functions.

    Right on - that is unless you are using pass-through queries.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  11. #11
    Russ Guest

    Re: How do I put my function in an SQL query?


    Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:
    >On Wed, 7 Mar 2001 20:21:12 -0500, "Douglas J. Steele" <djsteele@canada.com>

    wrote:
    >
    >
    > Just a comment, Russ. What you've shown will only work in Access if you're
    > running within Access itself. If you're connecting to an Access database
    > (or, more precisely, a Jet database) from some other client (such as VB),

    it
    > won't work. This is because, unless you're running in Access, your only
    > connection to the database is through the Jet engine, which doesn't
    > understand user defined functions.
    >
    >Right on - that is unless you are using pass-through queries.
    >
    >
    >Paul ~~~ pclement@ameritech.net
    >Microsoft MVP (Visual Basic)



    Hence the comment,
    >> .. WILL work WITHIN the database.


    I just felt that the general consensus was that it could not be done period,
    based on all the comments that followed my original response. And again,
    those comments were based upon the fact that Dav wanted to use the data environment.
    His original post did not mention this.

    -Russ.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center