Search:

Type: Posts; User: digitalShaman

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    3
    Views
    375

    VS 2017 Re: Secondary X axis on column chart

    maybe draw an exampe of the chart you want in paint together with the data so that we can better understand what you are looking for.
  2. Re: VB.NET and OLE Dataprovider - Calling CLP on AS400 passing parms

    looks like when passing a parameter, the stored procedure TGCLOCKRCV.TGDSQL takes a path where a type "*N" is referenced that does not exist?
    maybe.
  3. Re: plese urgent access reapair free tool

    https://www.google.com/search?q=access+database+repair
  4. Re: plese urgent access reapair free tool

    super glue is quite common.
    scnr
  5. Replies
    10
    Views
    1,584

    VS 2022 Re: Random

    A warning: I am not so sure anymore that this approach will generate evenly distributed numbers.
    For example the result of Int.max-1 / int.max will only be possible with these exact two numbers...
  6. Replies
    10
    Views
    1,584

    VS 2022 Re: Random

    x = BitConverter.Touint32(byteVal.ToArray, 0)
    y = BitConverter.Touint32(byteVal.ToArray, 4)
    rv = x / y

    add code to care about the edge cases (y=0 and x=y if you do not want 1 as possible result)...
  7. Replies
    6
    Views
    1,112

    Re: So.....Is AI taking over?

    AI is taking over if you want to phrase it like this. I am convinced that there will be further progress in AI development and whatever astonishes us today will become even more astonishing.
    As of...
  8. Replies
    14
    Views
    1,716

    Re: Total duration of all video files

    how does this perform?


    Dim TotalDuration As TimeSpan

    For Each File In FileList
    TotalDuration += GetVideoDuration(File)
    Next
  9. Replies
    14
    Views
    1,716

    Re: Total duration of all video files

    Please, if you are concerned about speed, do not create new instances of things like objShell and objFolder with every file you process. create one objShell and reuse it, create one objFolder for...
  10. Re: How to fetch maximum record from my table in mySql database

    SELECT * FROM purchases WHERE purchase_id =
    (SELECT TOP 1 purchase_id FROM purchases WHERE fuel_type_id = 1 ORDER BY date_of_purchase DESC)
  11. Replies
    23
    Views
    1,808

    VS 2022 Re: Adding Time mm:ss

    I would assume the table was just an example? ChrisE, what's the table doing here? ;)
    If you prefer, feel free to create a text file with example values instead to be compliant with #4.
  12. Replies
    23
    Views
    1,808

    VS 2022 Re: Adding Time mm:ss

    Public Class Form1
    Dim tb As New DataTable


    Private Sub Form7_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    tb.Columns.Add("ID")
    ...
  13. Re: FileSystemWatcher.Changed event get triggred when shared excel file gets closed

    If (and from your description it sounds like that) this is common excel behavior, then there is probably nothing you can do about it.
    It makes sense that excel writes the Share information (Who has...
  14. Replies
    6
    Views
    1,196

    VS 2019 Re: Execute PowerShell code in VB.NET

    The difference could be a result of one running as 32bit process and the other as 64bit. Try compiling the .net app as 32bit.
  15. Replies
    10
    Views
    1,057

    Re: Corrupt SQL Server

    I'd think the first thing to do is check database integrity: https://www.google.com/search?q=check+mssql+database
    potentially followed by chkdsk and mem test.
  16. Re: Pass Login details from main website to popup window automatically using WebView2

    the link you posted refers to making popups MDIchilds of the application. your thread title says pass login details to popup. so not the same thing.

    you usually pass logon details with a...
  17. VS 2015 Re: Reading data from Virtual COM Port slower than expected.

    I am not here to argue with you. But for my defence, in the initial post i read "I'm trying to receive the data and store it in a queue in a separate thread so that the application remains responsive...
  18. VS 2015 Re: Reading data from Virtual COM Port slower than expected.

    my fault. it should have been:

    txt.AppendText(Date.Now & " another package received." & Environment.NewLine)

    So you do not set the BaudRate of the SerialPort? That would mean it uses the...
  19. VS 2015 Re: Reading data from Virtual COM Port slower than expected.

    I'd suggest, and this goes along with what dbasnett aksed earlier, that you remove all processing of the data from your VB app for now. Strip it down to just receive data, count the bytes and throw...
  20. Re: Ideas for handling large CSV files with malformed lines

    agreed, but this is not limited you csv. have you ever seen an xml file containing unencoded ampersand's or "less than" signs? I have. The Devs just concated strings to create the xml instead of...
  21. Re: How to validate an INSERT, after Executing

    cn.execute can return the number of rows affected in a second parameter.
    see here: https://stackoverflow.com/questions/12676747/how-to-get-the-affected-rows-in-vba-ado-execute

    This should be >0...
  22. VS 2015 Re: Reading data from Virtual COM Port slower than expected.

    yeah, maybe you are right... maybe not.

    i found it strange that the OP sends a packet with 4096 bytes but waits for 8192 as he statet in #3. But i see now that it looks like he is continuously...
  23. VS 2015 Re: Reading data from Virtual COM Port slower than expected.

    that was actually an assumption of mine. i dont know what valuedata is. so maybe forget it.

    the other two points still apply though.
  24. VS 2015 Re: Reading data from Virtual COM Port slower than expected.

    why would you expect 8192 bytes i.e., two buffers when you only send one?
    And you dont have to mess around with a separate thread on datareceive event, it is already running separete from GUI.
    And ...
  25. Re: Ideas for handling large CSV files with malformed lines

    i dont think there is a general answer to the question. or at least only this: fail gracefully.
    it depends on things like: is your program automated running in the background? vs user attended? how...
  26. Replies
    2
    Views
    628

    Re: SQL Server - Possible to split a string, sort both parts, and put them back toget

    If i understand it right, this would just be an ORDER BY



    SELECT * FROM tbl
    ORDER BY CAST(SUBSTRING(field,2,999) AS int)


    be aware that this will only work if there are only digits after...
  27. Re: Ideas for handling large CSV files with malformed lines

    Sounds like TextFieldParser won't get you anywhere with this crippled source data.
    I'd switch to a custom read/parsing function that first splits the file into lines and then validates each single...
  28. Re: Get rows till the sum() is equal to or greater than

    thats what i was going to say: if you loop through the records (i.e. do not stuff like adapter.Fill), you should get row by row and can cancel whenever done. the server might/might not chache/lock...
  29. Replies
    10
    Views
    1,334

    Re: Cancel Long Running Query/Queries

    i understand you say your loop runs 20 seconds. please try the below instead. it's untested and a i am not doing alot c# so please forgive the mistakes. But you should see some improved performance...
  30. Replies
    8
    Views
    1,135

    Re: Tasking Thread Question

    I am not sure if i understand you and the last code you posted would end up as an multithreaded recursive infinite loop (Foo starting a new thread calling Foo).

    But: as far as i understand Outer,...
  31. Replies
    8
    Views
    1,135

    Re: Tasking Thread Question

    maybe something is changing your theSurvey.TotalWaypointSet.count so your cntTotal is off?

    change to

    Task.WaitAll(tsklist.ToArray)
    For x = 0 To tsklist(x).count - 1
    Dim resLLID =...
  32. Re: Something interesting from where you are...

    as far as i understood the story is as follows: on Feb. 3rd a train with a quite huge amount of quite toxic chemicals derailed in ~5k souls town of East Palestine. The chemicals spilled and...
  33. Re: Something interesting from where you are...

    no fotos of some dead fish from ohio yet?
  34. Thread: ChatGPT

    by digitalShaman
    Replies
    388
    Views
    36,159

    Re: ChatGPT

    just crazy :)

    https://www.youtube.com/watch?v=mHgsnMlafwU&t=317s
  35. Re: advice on linked server trigger insert

    Hey sapa, check you network settings/logs. I recall having issues with linked servers due to firewalls blocking.
    Are these inserts happening on every 10 minute job execution or is the job running...
  36. Replies
    24
    Views
    3,276

    Re: Double buffering

    Looking at your vid i guess you mean the "flickers" @0:25 and 0:29, these are not intentional, right?

    your problem is not double buffering in this case. something in your code triggers multiple...
  37. Replies
    2
    Views
    921

    Re: User Level RSA Key Container

    Thats how i understood it:
    there is some user logged in to the workstation that is running your application. This user (and code in your app) has access to the user specific keystore, i.e....
  38. Replies
    30
    Views
    2,867

    2000 Mules

    Anyone seen it yet? Opinions? All bullshit or true?

    Have not yet watched but hope to do so soon.
  39. Replies
    1,251
    Views
    124,884

    Re: Current Russia Ukraine tensions

    Noam Chomsky, an old wise man worth spending one hour listening:
    https://www.youtube.com/watch?v=8Jr0PCU4m7M
  40. Replies
    1,251
    Views
    124,884

    Re: Current Russia Ukraine tensions

    btw, did you follow the developments of the kramatorsk rail way station bombing? there first was big fuzz in our media about this alleged yet another russian war crime. now that there are doubts...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width