dcsimg

Search:

Type: Posts; User: KenBZim2

Page 1 of 2 1 2

Search: Search took 0.05 seconds.

  1. Replies
    4
    Views
    295

    Re: MYSQL - Function Not working

    Apologies once again, i have just seen my mistake document_number and documentnumber!!!
  2. Replies
    4
    Views
    295

    Re: MYSQL - Function Not working

    apologies code should be:


    CREATE DEFINER = 'root'@'localhost' FUNCTION `test`()
    RETURNS char(12) CHARSET latin1
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    ...
  3. Replies
    4
    Views
    295

    Re: MYSQL - Function Not working

    apologies code should be:


    CREATE DEFINER = 'root'@'localhost' FUNCTION `test`()
    RETURNS char(12) CHARSET latin1
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    ...
  4. Replies
    4
    Views
    295

    MYSQL - Function Not working

    Hi All

    I have written a function in Mysql and it is returning nothing and i cannot see what the problem is.
    I have simplified it to test it and it still returns nothing



    CREATE DEFINER =...
  5. Replies
    3
    Views
    275

    Re: Object properties in VS 2019

    Thanks Shaggy That makes sense, appreciate your reply
  6. Replies
    3
    Views
    275

    [RESOLVED] Object properties in VS 2019

    Hi All

    I have just downloaded visual studio 2019 community edition having only ever
    used VS2008
    I have noted a lot of changes from VS2008 but one in particular is that when you create a public...
  7. Re: Mysql Insert which inherits records from another user

    Thank you si works perfectly!
  8. Re: Mysql Insert which inherits records from another user

    Thanks si will try it out when i get to the office, cheers
  9. Mysql Insert which inherits records from another user

    165255

    Hi all what i am trying to achieve is an insert into the above table.
    basically i want User #2 to inherit access to all the reports that User #1 has access to, providing that user #2 does...
  10. VS 2008 Re: Highlight text in [Brackets] inside Richtextbox

    Excellent ChrisE thank you, works like a dream
  11. VS 2008 Re: Highlight text in [Brackets] inside Richtextbox

    Thanks Guys for your assistance
  12. VS 2008 Highlight text in [Brackets] inside Richtextbox

    how do i highlight any text that is enclosed in square brackets i.e.

    [HIGHLIGHT] that is found within a rich text box
    I know that it is possible to find and highlight text using
    ...
  13. Re: Mysql Select last price based on document type, group by item code

    Thanks, i will check it out when i am back in my office, thanks for your time and effort
  14. Mysql Select last price based on document type, group by item code

    163547

    The first table shows the raw data, the second table is the record set that i am trying to achieve.

    The record set is build using the following logic:

    to select the item code and the...
  15. VS 2008 Re: Listview Item.Check Event and Tab control

    Thanks for the advice guys
  16. VS 2008 Listview Item.Check Event and Tab control

    I have a form with a tab control and multiple tab pages, each tab page contains a listview with checkboxes set to true.
    what i am trying to do is trap the item click event on each list view to...
  17. VS 2008 Re: Sorting a Dataview based on the row filter

    Thanks Very much guys
  18. VS 2008 Re: Sorting a Dataview based on the row filter

    Apologies the return order should be:

    8
    1
    7
    3
  19. VS 2008 Sorting a Dataview based on the row filter

    I have a Data view that filters data from a datatable and i want to sort the results
    so that the records return in the same order as their primary key occurs in the row filter.

    This may better...
  20. VS 2008 Re: System.Net.Mail using Google SMTP

    Thank you topshot, you are a star, that is exactly what needed to be done, much appreciated
  21. VS 2008 Re: System.Net.Mail using Google SMTP

    Thanks Sapator I tried this, adding in the credentials but am still getting the same error, it is driving me crazy


    Dim mail As New System.Net.Mail.MailMessage()
    Dim AttachData As New...
  22. VS 2008 Re: System.Net.Mail using Google SMTP

    Hi jm no i am not required to use VS2008, i bought it in about 2010 and have been using it since then. Yes i am a lone developer. I did download VS2017 but had issues with the mysql connector (I use...
  23. VS 2008 [RESOLVED] System.Net.Mail using Google SMTP

    Hi All

    I have been struggling for 2 days to try and get this to work but cannot see where it is going wrong
    I have googled the problem and tried numerous alternatives such as changing the port to...
  24. Replies
    3
    Views
    521

    Re: Delete not working in Mysql sproc

    my apologies, thank you
  25. Replies
    3
    Views
    521

    Delete not working in Mysql sproc

    Hi All

    The following sproc physically deletes the record provided that it is the last document
    of its document prefix in the table, if it is not the last record then it records the document as...
  26. Re: Mysql Multiple update statements in one single update

    Thanks tg
  27. Re: Mysql Multiple update statements in one single update

    Thanks Guys, one question tg, would there be any difference in execution speed between the two above examples?
  28. Re: Mysql Multiple update statements in one single update

    sorry, my apologies the data in that example is fictitious, the values would not be consecutive
    Basically what i have works, but i was hoping to encapsulate it into a single update
  29. Mysql Multiple update statements in one single update

    I currently have the following:

    update doc_transactions set transport_allocation_value=120,transport_colour_integer=16000 where TRN_ID=1
    update doc_transactions set...
  30. Replies
    1
    Views
    259

    VS 2008 Uncompressing Text VB.NET

    I have the 2 following functions
    One compresses a string of text and saves it as a file, the other decompresses the file and returns the original text

    The first function has been in use for...
  31. Replies
    1
    Views
    282

    VS 2017 VS2017 and Mysql Connector problem

    I have just downloaded and installed VS2017
    I was perviously using VS2008 but my hdd crashed on the weekend and
    I no longer have the installation disk or product key.

    I was able to open one of...
  32. VS 2008 Re: How to see which mouse button has been clicked when an Addhandler mouse down eve

    Thank you for that, much appreciated
  33. VS 2008 [RESOLVED] How to see which mouse button has been clicked when an Addhandler mouse down event o

    The following code works correctly but i am unable th establish which
    mouse button fired the event. I need the event only to activate if the
    user right clicked the mouse


    Private Sub...
  34. Re: MySql Join - Is this possible in Mysql?

    Thank you si_the_geek, works perfectly
  35. Re: MySql Join - Is this possible in Mysql?

    Thanks, I tried this:

    select
    `contacts_domain`.`display_name` AS `display_name`,
    `Landline`.`actual_data` AS `Landline`,
    `Mobile`.`actual_data` AS `Mobile`
    from
    `contacts_domain`
    LEFT join...
  36. [RESOLVED] MySql Join - Is this possible in Mysql?

    I have 2 tables:

    `contact_domain`

    contact_domain_id (INT) [Primary Key]
    display_name VARCHAR(30)



    `contact_lines`
  37. Re: Out of Memory error loading image from Mysql to picture box VB.net

    I have changed the insert as follows, but now get a different error on the insert:
    max_packet_allowed
    I have researched this on the internet and found this:
    "The largest possible packet that can...
  38. Re: Out of Memory error loading image from Mysql to picture box VB.net

    Hi there, thankyou for you advice. I have made some changes, but am now getting a different error
    'Parameter Is Not Valid'
    This is the revised code:

    I welcome any help or further suggestions
  39. Out of Memory error loading image from Mysql to picture box VB.net

    Hi there, using VB2008 and Mysql Database:

    The following code is intended to write a jpeg file into the Mysql database as a BLOB, then select the BLOB image from the
    database and assign it to a...
  40. VS 2008 Re: Add Items to StandardValuesCollection at run time

    Thank you that works perfectly
Results 1 to 40 of 52
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width