grs blog

Category: Χωρίς κατηγορία

  • sql server, find foreign keys associated with given primary key

    sql server, find foreign keys associated with given primary key

    —

    by

    dm
    in

    If you work with an unknown schema and try to investigate the relationships between primary and foreign keys, there is a great answer on stackoverflow originally posted by db2. SELECT o1.name AS FK_table, c1.name AS FK_column, fk.name AS FK_name, o2.name AS PK_table, c2.name AS PK_column, pk.name AS PK_name, fk.delete_referential_action_desc AS Delete_Action, fk.update_referential_action_desc AS Update_Action FROM…

  • embedding ftp client in your android app

    embedding ftp client in your android app

    —

    by

    dm
    in

    Open your favorite IDE for android development and create a new project. Unless you choose to implement RFC 959 on your own, include a good ftp client library like this one http://commons.apache.org/proper/commons-net/download_net.cgi If you already know how to include a jar in your android project, skip the following bullets. For android studio fans: copy-paste jar to libs folder of your project,…