Click here to Skip to main content
16,015,697 members
Home / Discussions / Database
   

Database

 
QuestionMSaccess query to access random value from database Pin
Member 1202314130-Sep-15 4:50
Member 1202314130-Sep-15 4:50 
QuestionMusic Database Pin
morrism3530-Sep-15 2:30
morrism3530-Sep-15 2:30 
AnswerRe: Music Database Pin
Richard MacCutchan30-Sep-15 3:05
mveRichard MacCutchan30-Sep-15 3:05 
QuestionQuery is not producing the correct results(SOLVED) Pin
samflex28-Sep-15 5:45
samflex28-Sep-15 5:45 
AnswerRe: Query is not producing the correct results Pin
Richard Deeming28-Sep-15 6:22
mveRichard Deeming28-Sep-15 6:22 
GeneralRe: Query is not producing the correct results Pin
samflex28-Sep-15 7:32
samflex28-Sep-15 7:32 
QuestionMove GROUP_CONCAT's comma values to columns Pin
Jassim Rahma22-Sep-15 22:03
Jassim Rahma22-Sep-15 22:03 
Questionpostgresql database issues Pin
Member 1191972221-Sep-15 22:09
Member 1191972221-Sep-15 22:09 
update sc_bill_details set dt_open_date=(select dt_bill_date from sc_bill where sc_bill.st_bill_no=sc_bill_details.st_bill_no and dt_bill_date>='1-7-2015')

when m writing above query in sql pane of postgresql database then m getting follwing error...though there is no null value..i have changed date datatype of above tables from timestamp to date.

ERROR: null value in column "dt_open_date" violates not-null constraint
DETAIL: Failing row contains (VC2012030000303, VC20100300266, null, 11, 5, RBS, 1, 40, 40, 0, 14, 0, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0).


and when m writing above query taking different table as an example then am getting desired output...i dont understand whats wrong with it..Please get this issue resolved .
Thanks
AnswerRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 22:50
mveRichard MacCutchan21-Sep-15 22:50 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:23
Member 1191972221-Sep-15 23:23 
GeneralRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 23:27
mveRichard MacCutchan21-Sep-15 23:27 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:31
Member 1191972221-Sep-15 23:31 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:34
Member 1191972221-Sep-15 23:34 
GeneralRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 23:52
mveRichard MacCutchan21-Sep-15 23:52 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:56
Member 1191972221-Sep-15 23:56 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 0:00
mveRichard MacCutchan22-Sep-15 0:00 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:04
Member 1191972222-Sep-15 0:04 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 0:29
mveRichard MacCutchan22-Sep-15 0:29 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:49
Member 1191972222-Sep-15 0:49 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 20:57
mveRichard MacCutchan22-Sep-15 20:57 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 21:05
Member 1191972222-Sep-15 21:05 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 21:31
mveRichard MacCutchan22-Sep-15 21:31 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 21:35
Member 1191972222-Sep-15 21:35 
GeneralRe: postgresql database issues Pin
Richard MacCutchan23-Sep-15 2:23
mveRichard MacCutchan23-Sep-15 2:23 
GeneralRe: postgresql database issues Pin
Member 1191972223-Sep-15 19:34
Member 1191972223-Sep-15 19:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.