Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FlipOver

    A rouding problem with VB?

    Thank you all for all your help in this subject.. Guess thread222-318384 is self-explanatory and i'de like to thank specially to Shroeder for all it's help also (in practical sense) and to Codefish and jonhwm (thread222-318384).. Because time is running out on us here.. the first thing we...
  2. FlipOver

    A rouding problem with VB?

    Hi there, My company is co-working with another and something came out that made us go hmmm.. Apparently there are some wrong rouded values between this company and our partners.. they say if you round (in any form.. using Round() or Format() functions...) the value 0.5 to a number without any...
  3. FlipOver

    Finding SQL server name using DNS properties.

    Hi there, Can anyone tell me if it is possible and how do i get a SQL server name through a DNS property in an ADODB connection? I have all the other information and the only thing i need to know is the SQL server name where the app is connected. I think i can do it using API calls, but i need...
  4. FlipOver

    And i wonder... What if ? (VB 6 + SQL)

    Thank you BobWman, I guess this is it.. :) You made my weekend.. Thanks again.
  5. FlipOver

    And i wonder... What if ? (VB 6 + SQL)

    But that brings us to my inicial question.. if optimistic locking just locks the current record during the Update time, if someone deletes the record before the Update command is executed..... That's what i've been trying to figure out, a way to lock the record for editing/deleting and enable...
  6. FlipOver

    And i wonder... What if ? (VB 6 + SQL)

    BobWman thankx for your reply, but i didn't understand quite well the downside of one and the other.. (in the app i'm using standerdly the pessimistic lock, but i'de really aprecite you to point out the real diferences between de optimistic and pessimistic locks..)
  7. FlipOver

    And i wonder... What if ? (VB 6 + SQL)

    If i set the lock type to pessimistic isn't it true the other users would not be able to even see te data from the hole table? (this is another doubt that i have) The hole idea is to enable the viewing of the data that of a table that another user is editing, but preventing others to edit or...
  8. FlipOver

    And i wonder... What if ? (VB 6 + SQL)

    Hi there, First of all i'd like to appologise not describing this post in its subject, because i really don't know how to do it in few words. I've finished an app that uses ADODB recordsets and connections using an SQL database.. the thing is: I started to wonder what if someone starts to edit...

Part and Inventory Search

Back
Top