dcsimg

Search:

Type: Posts; User: Peekay

Page 1 of 7 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    These are very helpful routines. I will try them out.
    Thank you!
    PK
  2. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Thanks so much. I understand now.
    PK
  3. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Ok I have solved this error thanks.
    The error was that I tried to update a record without updating the non null Boolean fields, not realizing that SQL Server Boolean fields could be set to be not...
  4. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    I get an error which seems unlikely:

    I call this from my program:


    Fields_Values.Add "ParticipantName", UserName
    Fields_Values.Add "AppointNo",...
  5. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    I have found that this one works.


    "SELECT IDENT_CURRENT('Tablename')"
  6. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    I wish to get the ID of the last record created and use this:


    Set rsADOtemp = modRemoteDB.GetRs("Select @@Identity as ID")


    But, it returns a null value?
    Is there any other way I can get...
  7. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    That's good thanks.
    PK
  8. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Incredible technology this!

    Two questions if I may:
    1. I find it difficult to search. You said that I do not need any apostrophes or % before or after the search text inserted as ?. The way I...
  9. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    It works beautifully, thanks so much.
    PK
  10. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Indeed, it gave a fatal error as the recordset Rs passed to it is equal Nothing, so I stop before that.



    Indeed I used that to keep it simple, but I have now changed it by using actual field...
  11. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    I have done yesterday what you advised me to do and did not interfere with any process until it reached the client GetRs function EndFunction line, but the recordset Rs received there was equal to...
  12. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Olaf,

    There is an error somewhere which I cannot trace.

    Here is the http.responsetext after filteringtags, from which I can see that there are three records in the recordset:


    TG! ...
  13. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    I find something amiss in the code.

    When I use your GetRs function in module modRemoteDB which is on the client side and I follow it through, I can see the following:

    1. There is no error in...
  14. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Very lucid, thank you Olaf. I will implement.
    PK
  15. Replies
    24
    Views
    786

    Re: Implementation of RPC server side code

    Here it is:


    Public Sub GetRsByQueryID()
    Dim Cnn As ADODB.Connection, rsADO As ADODB.Recordset, SQL As String, i As Integer, RsGetRecordset As New ADODB.Recordset, QueryID As String

    ...
  16. Re: Your first BASIC computer? Has your software survived?

    168977
    I started Basic in 1975 on the first Wang PC, leaving mainframes and Fortran IV behind.
    It had one tape drive, of the old cassette music era, for storing data and programs in sequential...
  17. Replies
    24
    Views
    786

    Implementation of RPC server side code

    When I open an ADO recordset on the server side, it gives me an Automation Error regardless of the actual error.
    Is there a way to get the real server side error on the client side?
    Thanks
    PK
  18. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Thanks Olaf,

    I appreciate your continued help and support.
    I hope I can ask (intelligent?) questions as I proceed to implement these and for that I intend to start a new thread on the...
  19. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Thanks Olaf,

    It is a lot for me to absorb and try and understand. I will try it out and try to figure it out - and thanks so much for the help you have given me.
    What I know now is that that I...
  20. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Here is my UpdateRow from event:


    Private Sub cmdUpdateRow_Click()
    Dim B() As Byte, B0() As Byte, B1() As Byte, B2() As Byte, B3() As Byte, B4() As Byte, B5() As Byte, B6() As Byte, B7() As Byte...
  21. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Here is my DeleteRow form event:


    Private Sub cmdDeleteRow_Click()
    Dim B() As Byte, C() As Byte, S(0 To 1) As String, RsResult As ADODB.Recordset

    S(0) = "DailyJournal": S(1) = "5"
    B = S(0):...
  22. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    I used this code for inserting a new row:

    In the form event:


    Private Sub cmdAddRow_Click()
    Dim B() As Byte, B0() As Byte, B1() As Byte, B2() As Byte, B3() As Byte, B4() As Byte, B5() As...
  23. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    qvb6,
    I hold you and Olaf and many others here in veneration.
    However, I think that whilst we are mostly nerds we can enjoy some diversion.
    Rest assured that I am here to support the forum.
    PK
  24. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    I am publishing this variation on the song High Noon with the greatest respect:

    Do not forsake me, oh, my mentor
    On this, my ignoramus day
    Do not forsake me, oh, my mentor
    help, help along

    I...
  25. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Olaf,
    I wish to raise some points if I may:

    1. I have used your GetRs routine in modADODB with and without parameters with some success in posts #70 to #72. However, your silence is deafening, so...
  26. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    I have also done one with a parameter:

    In the form event:


    Private Sub cmdGetRecordsetWithParameters_Click()

    Dim S(0 To 9) As String, B() As Byte, C() As Byte, RsResult As ADODB.Recordset,...
  27. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Here is the visualized result:

    168689
  28. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Olaf,

    Thanks, this is very lucid now, as I did not understand the '?' previously.
    In this exercise I have used the SQL without parameters.

    Here is my Form event:


    Private Sub...
  29. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    I have gone so far with the code as CreatingParameter in:


    For i = 0 To UBound(P)
    Select Case VarType(P(i))
    Case vbString
    Cmd.Parameters.Append Cmd.CreateParameter(,...
  30. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Thank you so much - I appreciate. I do read every sentence many times over, but some times I do not understand it well.



    I have included this new routine in my server side code previously...
  31. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Let me try strike 3.

    In the form event I have this:


    Private Sub cmdAddRow_Click()
    Dim S(0 To 9) As String, B() As Byte, C() As Byte, D() As Byte, E() As Byte, F() As Byte, G() As Byte, H()...
  32. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Olaf,

    My understanding of the project we are busy working with, it is to prevent SQL injection.
    Where this injection can originate and how it is done, I do not know, because by serializing the...
  33. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Strike 2:
    In the form event:



    Private Sub cmdAddRow_Click()

    Dim S(0 To 6) As String, B() As Byte, RsResult As ADODB.Recordset
    S(0) = "DailyJournal": S(1) = "Date": S(2) = Date: S(3) =...
  34. Replies
    2
    Views
    146

    Re: Creating 3D objects in space

    One such instance of real time 3D can be viewed here:

    http://www.warframe.com/game/warframes/vauban

    PK
  35. Replies
    2
    Views
    146

    Creating 3D objects in space

    dilettante has whetted my appetite for 3D objects by using CreatObject to print documents with an automation interface in another thread.

    I have three applications where I use 3D physical object...
  36. Re: How to programmically open a file by an application

    dilettante,

    I use this function:



    ShellExecute Me.hWnd, vbNullString, App.Path & "\HelpFiles\Documentname.pdf", vbNullString, vbNullString, vbNormalFocus


    Does it have restrictions that...
  37. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Here is my first strike at the handler routine:



    Public Sub CrudOperations()

    Dim B() As Byte, i As Integer, strConn As String, Cnn As ADODB.Connection, rsADO As ADODB.Recordset, SQL...
  38. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Shaggy Hiker,

    Thanks for that. I only learned this week how to use the #.

    I understand your concern in your second comment, and it bothers me somewhat to keep coming back here for some un...
  39. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    Olaf,

    I have tried and I think succeeded in sending a byte array in post 55 to DoRPC, but I do not know how to transform the following into a byte array if you wish me to send the parameters to...
  40. Replies
    84
    Views
    2,992

    Re: SQL server connection string

    I have tried a routine to add a new row - here is it:

    In ftestfrm:



    Set RsResult = RPC.DoRPC("AddNewRow", "DailyJournal", "Date", Date, "UserNo", 1, "Entry", "May 11 entry")


    In the...
Results 1 to 40 of 266
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width