Search In
SQL Update statement is used to modify the records in table in database . We can modify either by change data or deleting data or to update the existing data .
We can modify the rows based on condition and condition come with where clause .
Syntax :
SQL Join query is used to join the two tables i.e add or combine two or more tables .
This clause take data from two or more table in database and then combine them to produce new table .
Joining is based upon the common fields from the tables .
Adva
Hello all,
When we install module in openerp version 6.1 we face the following error shown below and to resolve this issue I have provided the code below, mentioned in solution part.
Error look like this on terminal
<---------------------------
These are the simple steps for inserting,updating and deleting records in ListView control.
Create new project
Configure entity data model with the project :
i) Add new item ->Data->ADO.NET Entity Data Model-> add
ii) Select Generat
Hello all,
In asp.net we show our database records in tabular format using GridView control and to export that GridView Data to excel, we can use following code packet.
protected void gridViewExportToExcel()
{
if (GridView.Rows.Count &
Properties file:
It is basically used to store data that is constant and can be used anywhere in the program.
Example: You can store the database credentials and connection parameters in the file and fetch it when required.
How to use:
PropertyP
In openerp to create print template of the survey means that first check response or survey and if response is available then print this response otherwise print survey form and the current row, from the database cursor and also the current user&rsqu
Statement interface:
It provides methods to interact with database means using Statement interface we can execute SQL queries.The createStatement() is present in java.sql.Connection interface and it does not take any argument.
To use Statement inte
It is used for conjunction with the select statement to eliminate the all the duplicate record and fetch only the unique record.
There are many situation that we found duplicate data on the database and better to get unique ones.
SELECT DISTINCT c
To implement drag and drop in cakephp using jquery, you need to follow following steps :-
Step 1: Make index.ctp and add following code in it :-
<head>
<style>
#sortable-list { padding:0; }
#sortable-list li { padding:4
