Databases
StackOverflow2013
Usersdbo
USJerkSnout
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USJerkSnout
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. POUpdate DATETIME column where said DATETIME < current DATETIME
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COYou are completely correct. I had moved `PageLoadTime` inside of my `if (!IsPostBack)` block, but that doesn't do any good if I also initialized the dang thing right before that. I removed `PageLoadTime` and replaced it with a session variable that is only updated if `IsPostBack` is false. Problem solved.
      singulars
      1. PO
      1. USJerkSnout
    2. COWell, switching over to parameterized queries hasn't fixed my problem on its own. I've added a label on the page to display the value of `PageLoadTime`. I loaded the page at 10:40am (verified by the lable), and then manually set `timestamp_m` in the DB for 10:44am and attempted to update. It did not let me update until 10:44am, so clearly part of this is working. But it still does not work when USER1 loads the page at 10:40am, USER2 updates at 10:44am, USER1 (without reloading, so his `PageLoadTime` is still 10:40) can immediately update even though 10:44 < 10:40 is not true.
      singulars
      1. PO
      1. USJerkSnout
    3. CO@DaveZych: Yes, I have checked in debug, and the value appears to be correct and matches the format of my SQL DATETIME column. I've gone as far as adding a break on the `ExecuteNonQuery()` line, grabbed the actual sql string from the debugger, run it manually against the DB before resuming. When I run it manually, it updates when it should, but when I let my app resume, it updates the row no matter what.
      singulars
      1. POUpdate DATETIME column where said DATETIME < current DATETIME
      1. USJerkSnout
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload