dcsimg

Search:

Type: Posts; User: Peekay

Page 1 of 11 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    Zvoni,



    Can you please elaborate how I set this.

    Thanks
    PK
  2. Replies
    10
    Views
    238

    Re: Sql Server copying table

    I thank you all for such rich contributions which I will disseminate.
    PK
  3. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    Thank you very much FunkyDexter. This thread has been an eye opener for me, and I have already started implementing FKeys.
  4. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    Very lucid, thank you Zvoni.
    PK
  5. Replies
    10
    Views
    238

    Re: Sql Server copying table

    Ok thanks, I will rather do that then.
    PK
  6. Replies
    10
    Views
    238

    Sql Server copying table

    I use this query to copy an existing table structure without data:


    SELECT TOP 0 * INTO BusDataNew FROM BusData

    It works well, but in the process no contraints are copied and I need to add...
  7. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    Is this how it is done?

    174491

    PK
  8. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    jmcilhinney,

    Thanks for that. I was under the understanding that with a foreign key I could delete the parent and let the child remain, which would be disasterous, except for auditing purposes as...
  9. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    Zvoni,
    Thanks for the link.
    I think I understand that process, but I fail to see the application.
    Unlike the link, I would never wish to change the primary key value of the parent table. I also...
  10. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Re: Foreign keys

    Very intersting thanks. I will try it.
    PK
  11. Thread: Foreign keys

    by Peekay
    Replies
    23
    Views
    337

    Foreign keys

    Why do I need foreign keys? I do not know.
    If I have a table Customers with primary key named ID and I have an orders table with CustId in my orders table. Is that not enough to join te table? I...
  12. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    TysonLPrice,
    I will respect your view and open a new thread. I just did it here not to lose the valuable inputs of Zvoni, FunkyDexter and others and I am sure they will participate in the new...
  13. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    I wish to respond to the idea of the FK, although it may be a new thread, but I do not really to open one.
    I am at a loss if you talk about FK's. Of course I join one table on a field of a second...
  14. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    GaryMazzone,
    No, it was not the case and I am too ignorant to do such a thing.
    PK
  15. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    FunkyDexter,

    Well .. what can I say?
    In the first instance I wish to thank you for your excellent contribition. I have learned a lot.
    And ... some introspection says I have OCD. That can be...
  16. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    It was quite an interesting excursion.
    There are two solutions that Zvoni's link gives.
    This one is even more detailed for newbies:
    ...
  17. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    Yes, dee-u has the right solution for Sql Server 2017 to set IDENTITY_CACHE = OFF, but it is not available in Sql Server 2012 with which I work.
    Zvoni, I am aware of losing deleted records ID's.
    ...
  18. Replies
    24
    Views
    302

    SQL Server not increasing by 1 but by 100

    Sometimes, when I create a new record in a table which has its indentity set to increase by 1, it increases it by 100 as in this graphic.
    What can be the source of this error?
    Thanks
    PK

    174385
  19. Re: Subtract date and time fields in SQL Server query

    GaryMazzone and FunkyDexter,

    Thanks for your valuable contributions.
    I have tried that of FunkyDexter and it works excellent.

    PK
  20. Subtract date and time fields in SQL Server query

    I have four fields in table1 in Sql Server 2012.

    Two are of type date (storing date1 and date2) and two are of type datetime (storing time1 and time2).
    How do I calculate the difference in hours...
  21. Re: [RESOLVED] Setting up SQL Server on a remote server

    Olaf,

    I registered the .dll's on the remote server and everything works perfect on it.
    Thank you so much!!!!!!!

    PK
  22. Re: [RESOLVED] Setting up SQL Server on a remote server

    Olaf,



    You are right. I forgot about that.
    I understand all you say quite well and will implement.

    Thanks so much!

    PK
  23. Re: [RESOLVED] Setting up SQL Server on a remote server

    I have tried that regfree, but there is obviously a problem.

    Here is my URL call:


    RPC.RPCUrl = "http://192.168.1.11/asp/ServerLib_regfree.asp"


    Is there an easy way to register the...
  24. Re: Setting up SQL Server on a remote server

    Olaf,

    Thanks so much.



    I have set up the TestServer exactly as per the above instructions.


    Dim Cnn
  25. Re: Setting up SQL Server on a remote server

    OptionBase1

    I have been using SQL server now for 6 months, having previously worked with Access and I am still in the process of learning how to adapt to the new environment. This is the first SQL...
  26. Re: Setting up SQL Server on a remote server

    I have not been able to solve the access problem with any of the tips above, mainly because they are mostly cryptic and incomplete and cannot be implemented unambiguously, or they are in conflict...
  27. Re: Setting up SQL Server on a remote server

    TysonLPrice and GaryMazzone,

    I am on a Windows 7 test server - so no domains. My SSMS runs under windows authentication, so I can understand that there is a problem.
    I specified SSPI security...
  28. [RESOLVED] Setting up SQL Server on a remote server

    I have now installed SQL Server on one of our local network servers which acts as a remote server for local and internet access.
    As a start I cannot access the database from our local network...
  29. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Olaf,

    My program group in VB6 IDE, client program in VB6 IDE and compiled client all work with serverlib.asp and serverlib_regfree.asp.
    Can you please give me the steps to migrate to the remote...
  30. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Thank you for the touch of the master!!
  31. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Here is the complete code for cASP.cls:


    Option Explicit 'in this "Main-Entry-Class" we just delegate further into a Handler-Class (cHandler)

    Public Sub HandleRequest(Application As Object,...
  32. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Olaf,



    I do exactly as you say and it works fine in the project group, but as soon as I go to the Client project alone in the VB6 IDE, then I get this error on the first call to the database:...
  33. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Let me state my steps clearly - sorry.

    1. The project group on HostDev works perfectly.
    2. Next I compiled the servelib.dll file on the HostDev and place it in the asp/bin/ folder of the HostDev....
  34. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Oladf,
    Thanks for your detailed and elaborate help in the above two posts. I appreciate it.
    Yes, previous all the instances on my localhost worked, but not anymore.
    I have found the problem. My...
  35. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    What I cannot understand is that my project group works fine on the localhost, but as soon as I use only the client, it does not find the database error. Maybe it cannot create the object in the .asp...
  36. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    Olaf,

    Thanks so much. It is indeed a very lucid explanation.



    The Client project works perfectly in both the Project group attached and in the Client project with no server group attached....
  37. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    To Schmidt:



    Can you be more specific of the two helper functions you refer to and elborate on the meaning of the post-compile-step.
    My understanding is that, after I compiled Serverlib.dll,...
  38. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    I just can't get the remote server on the local network to access the SQL server database.

    I have the files Serverlib.dll and Serverlib.manifest on the remote server in the /bin folder and I have...
  39. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Re: Manifest file

    It says under .assert that it cannot create the object. I have registered it and it still gives me the same error.
  40. Thread: Manifest file

    by Peekay
    Replies
    19
    Views
    923

    Manifest file

    Schmidt gratuitously gave me this code for creating a manifest file:



    Option Explicit

    Private Declare Function CLSIDFromProgID Lib "ole32" (ByVal psProgID As Long, pClsID As Any) As Long...
Results 1 to 40 of 421
Page 1 of 11 1 2 3 4



Featured


Click Here to Expand Forum to Full Width