Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h3>Pointers exist but they're called object references</h3> <p><em>(Now other posters, please don't quibble with me about the actual differences here. I am talking about the high level task the OP wants to accomplish)</em></p> <p>Obviously you can't do literally what you've said - that is, surgically manipulate one member. But if you have control of the code, you can do almost as well. And from what you describe is your problem, this method will be much better, as you can pass references to an object that has many members you wish to update, instead of having to pass many individual pointers.</p> <p>First define a class: </p> <pre><code>Class MyScreenValues ' Properties will work... using public fields for brevity Public TextBox1Value as String Public SpinControl1Value as Integer public CheckBox1Value as Boolean End Class </code></pre> <p>Now the equivalent of the code you posted: </p> <pre><code>Dim x as new MyScreenValues 'int x; dim foo as MyScreenValues = x 'int&amp; foo = x; '// c++: foo is now a reference to x so this sets x to 56 '// .net: foo is now a reference to x so this sets x.SpinControl1Value to 56 foo.SpinControl1Value = 56; </code></pre> <p>If what you're doing is trying to pass pointers to, say, every control on your form's value to a sub, like so:</p> <pre><code>Button1_Click(... Dim MyObject as new BusinessObject MyObject.DoSubmit(TextBox1.Text, SpinButton1.Value, CheckBox1.Checked) </code></pre> <p>You can use the method provided by superbDeveloper, and use the ByRef keyword on the definition of the DoSubmit Sub:</p> <pre><code>Public Sub DoSubmit(ByRef Name as String, ByRef Age as Integer, ByRef Employed as boolean) ... business logic... </code></pre> <p>However this just gives you a 2-layer separation. Look into MVP, MVC, etc - however consider submitting the entire view worth of data. It's a lot of research you you may settle with what you have now. For example your business logic will be firing events on the form as it changes the form values (well, actually, they won't fire until the sub exits, due to the way VB deals with byref properties [=temp variable], but it needs to be considered).</p> <p>You can also map an object's properties to a Form's properties with other libraries. Check out <strong>VALUE INJECTOR</strong> on the web. It can take a webform/winform and maybe even a WPF form and map the control values to and from an object you have predefined. Excellent for complete separation. </p>
    singulars
    1. This table or related slice is empty.
    1. POIs it possible to declare a local/class instance member reference variable in VB.net to read/update same object referred by another variable
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USFastAl
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs it possible to declare a local/class instance member reference variable in VB.net to read/update same object referred by another variable
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COthanks @FastAl I'll look at your answer when more time.
      singulars
      1. PO
      1. UStherobyouknow
    2. CO(within the next day or so, I'm keen to reward everyone for their time)
      singulars
      1. PO
      1. UStherobyouknow
    3. CO+1 I think this one will be accepted as it also deals with the form scenario. I'll look into it more - thanks - and then get back to you.
      singulars
      1. PO
      1. UStherobyouknow
 

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