Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Search In

Use of Case while updation in SQL

While doing updation or insertion you can select or insert values based on case selection in SQL For doing that will provide a better way to get filtered data updated or inserted ALTER PROC [dbo].[uspGetNudgesDetails] @AccessToken VARCHAR(50), @Be

Get Facebook profile pic url by user id using graph api

It is very easy to get the url of profile picture from facebook if we have user id. We just create a url like this: Here id is the user id of the Facebook account. try { // Type may be normal,large or small

What is FOREIGN KEY Constraint in MySQL?

Note that the "P_Id" column in the "Orders" table points to the "P_Id" column in the "Persons" table. In MySQL, the FOREIGN KEY on one table is used to point a PRIMARY KEY in another table. We have two tables with the following values. user i

How to create Membership State for Given Partner in OpenERP

In OpenERP first create partner and then validate the partner form. After this compare it with the membership of the other partner. Then standard dictionary for contextual values and the dictionary of Membership state Value. Use this function show b

Merging Panda Dataframes

I have two dataframes. One is user(UserID, Name) and other one is rating (srcUserId, dstUserId, RatingValue). I have to merge these two dataframes such that in place of srcUserId I get the name of the user corresponding to userid from user dataf

How to add penalty in customer invoice in OpenERP-6.1?

In OpenERP first, install the account module and then create the own module and relate it to the fields payment term in account module. Follow these steps given below: Step1- First create add_penalty.py file in your own module and pass this file in

Function calling on button click in OpenERP

Adding a button on an OpenERP view is very easy and calling a function on it too. For example I created a function to add cartage amount on the sales order, I created a field to add cartage amount on it and then on button click it will be added to th

How to Include only parent level class in OpenERP(Odoo)?

To Include only parent level class in OpenERP(Odoo) below is the method/code In below example I have written Python script to Include only parent level class. You can directly use below python code in .py file : def addMaterialsRecursive(componen

How to copy invoice automatically in OpenERP(Odoo)?

Step-1 install the account_invoice_copy module. Step-2 After that customize .py file in account_invoice_copy module. In below example, I have custmozied .py file. You can directly copy the below python code in your .py file - def copy(self, c

Consume product with specific quantity from specific source location in openerp

The quantity from specific source location with Consumed product and param product_qty means that Consumed product quantity and param location_id is Source location and returns Consumed lines in this function. Use the below function in .py file def

1 … 58 … 466
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: