Databases
StackOverflow2013
Usersdbo
USMiraino Hikari
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USMiraino Hikari
    primarykey
    data
    text
    plurals
    1. POiis and apache combination on real server for 403
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POCreate a non editable attribute in Excel cells that is still readable for a c# program
      singulars
      1. PTQuestion
    1. PO
      singulars
      1. PTAnswer
    2. POCreate a non editable attribute in Excel cells that is still readable for a c# program
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO@RBarryYoung It was an example, but in fact, no. The ItemID is like a serial number generate from other properties and can sometimes change a little. ItemName is only a descriptive that can be widely changed. Globaly, my real object has around 26 properties, and sometimes 1 or 2 that can't change, but it's not enough to recognize them (example : vg05 - tomato that will become fr05 - red tomato for some obscure reasons) because of that, i can't know if it's a new item or an updated one, and with the validation, may occure to be dupplicated and not be considered at all.
      singulars
      1. POCreate a non editable attribute in Excel cells that is still readable for a c# program
      1. USMiraino Hikari
    2. COI'm not directly in excel. Excel itself is not my problem, nor is my software importation feature. It's both together. In the past, they only used Excel and paper. At the first with our software, they could export data to Excel for visualization purpose. Recently, they ask to be able to "reimport data" they changed in the Excel file. So we need to keep trace of what is what. So we store the db pks formated rangename (sort issue) or another column (edit or interact issue). I try to find some hidden properties that will follow in case of sorting AND not being editable by user, not even viewable.
      singulars
      1. PO
      1. USMiraino Hikari
    3. COYeah, but it must not protect it, since they can delete lines... Created via reflective com. Yeah, I can lock the sheet, but i mustn't since user need "full control. That's the why of my problem. They are in transition mode. Some of them still use their excel, and some other already use the soft (at least I hope). But maybe, as you say, the only solution will be user training and still adding my pk in a cell and say them not to erease it... anyway, my validator verify for duplicate and forbid duplicate entries in database. Thanks anyway for your help
      singulars
      1. PO
      1. USMiraino Hikari
 

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