Click here to Skip to main content
15,916,378 members
Home / Discussions / Database
   

Database

 
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 
Member 11919722 wrote:
hope u understand my issue
Yes, I do understand your issue, but I do not think you do.
Either:

  • You have a record in your database that contains a null value, or
  • The select dt_bill_date part of your update query does not find a record, so you are passing in a null value.

So, the solution is to find out why the select part of your update is returning a null value, or why that record contains null in the database.

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 
GeneralRe: postgresql database issues Pin
Richard Deeming24-Sep-15 1:55
mveRichard Deeming24-Sep-15 1:55 
GeneralRe: postgresql database issues Pin
Member 1191972225-Sep-15 1:01
Member 1191972225-Sep-15 1:01 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:08
Member 1191972222-Sep-15 0:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:20
Member 1191972222-Sep-15 0:20 
AnswerRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 2:31
Tim Carmichael22-Sep-15 2:31 
SuggestionRe: postgresql database issues Pin
Richard Deeming22-Sep-15 4:45
mveRichard Deeming22-Sep-15 4:45 
GeneralRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 5:08
Tim Carmichael22-Sep-15 5:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:52
Member 1191972222-Sep-15 19:52 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:59
Member 1191972222-Sep-15 19:59 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:50
Member 1191972222-Sep-15 19:50 

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.