Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds.

  1. Replies
    98
    Views
    4,501

    Re: Another complicated query but perhaps possible

    WITH
    TR AS (SELECT SC.ID, SC.Student_ID, COALESCE(SC.Price, S.SubjectPrice) AS SubjectPrice,
    S.SName As SubjectName, TE.TName As TeacherName, SC.NumOfSessions,
    ...
  2. Replies
    98
    Views
    4,501

    Re: Another complicated query but perhaps possible

    No, he‘s right. I didn’t consider what he said.
    unfortunatly, it‘ll be thursday i can have a look at it since i‘m out of office the next 2 days.

    but i think it’s easy. I do have an idea, how to...
  3. Replies
    98
    Views
    4,501

    Re: Another complicated query but perhaps possible

    WITH
    SSC AS (SELECT SC.Class_ID, SC.Student_ID, SC.NumOfSessions, COALESCE(SC.Price,S.SubjectPrice) As SubjectPrice,
    COALESCE(SC.Price,S.SubjectPrice)*SC.NumOfSessions As...
  4. Re: TRYING TO RUN EXCEL OUTPUT USING Latest MS Office 365 (Versioin 16)

    And Elroy told you the solution: Late binding
  5. Replies
    11
    Views
    373

    Re: Challenge: Which Device Used for Entry | VB6

    That's your opinion (and i respect it).

    Everything else: Enought truth in it (didn't consider it)
  6. Re: mysql 8 cannot drop some databases I created, others do drop?

    Try it out?

    My Guess: Depends. If the Database "testy5" is completely empty (no tables and what not associated with it in INFORMATION_SCHEMA) you might get lucky.
    If INFORMATION_SCHEMA has any...
  7. Re: mysql 8 cannot drop some databases I created, others do drop?

    Show Databases doesn't "read" the available files from disk.
    It just reads the entries from INFORMATION_SCHEMA (or was it from "mysql"?)
    Meaning: You have an entry "testy5" in the...
  8. Replies
    11
    Views
    373

    Re: Challenge: Which Device Used for Entry | VB6

    Or buy 2 Raspberry Pi's (70-90$ each), put Raspbian (Free) on it, write the App in Lazarus/Freepascal (Free),
    and you'll come out below 300 $ (cost for RFID-Reader not withstanding)
  9. Replies
    21
    Views
    28,903

    Re: How to compare the similarity of two words in VB?

    Think google-search and/or Regex
  10. Replies
    11
    Views
    373

    Re: Challenge: Which Device Used for Entry | VB6

    Check if the RFID-Readers support virtual Serial-Mode.
    Then it's easy, because you see the COM-Port it comes from
  11. Replies
    10
    Views
    505

    Re: BeforeColEdit Problem

    Yes, since when is KeyAscii=0 the delete-key?
  12. Re: TRYING TO RUN EXCEL OUTPUT USING Latest MS Office 365 (Versioin 16)

    I'll take your word for it.
    And i did write "My Guess is..."
  13. Replies
    9
    Views
    1,091

    Re: React Native Login connect with sql server ?

    You know: I admit not having a single clue about JavaScript (or whatever language he uses),
    but i'm trying to marry "app.js", which opens a SQLite-Database (locally?), with "server.js", which is...
  14. Re: TRYING TO RUN EXCEL OUTPUT USING Latest MS Office 365 (Versioin 16)

    My guess is: Kaboom comes from Office 64-Bit vs. vb6-32Bit

    and ods is "OpenDocument"-Format (whatever the "s" stands for).
    When running Excel the first time, the User has to specify which...
  15. Re: Cant add any new tables to an existing database, can create database and add tab

    Well, some 40 years ago there was leaded fuel.
    This has been abandoned no idea how many years ago.
    Do you really want to argue like that?

    If MySQL8 is kind of "state of the art"-Version for...
  16. Re: Cant add any new tables to an existing database, can create database and add tab

    Well, in your case, i'd nuke the whole installation, and start anew
  17. Re: Cant add any new tables to an existing database, can create database and add tab

    mysqlcheck is a program of its own.
    You don't use it within the mysql-CLI
    https://dev.mysql.com/doc/refman/8.0/en/programs-client.html
    https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
  18. Re: Cant add any new tables to an existing database, can create database and add tab

    And NOT 20 years ago (as of now) MyISAM is deprecated
  19. Re: How do I use the byte arrays returned from Read method of the ADODB.Stream object

    adodb.stream.read returns a variant
    you assign it to bytearray which is a variant, too

    Why would you expect to have an array-access to it?

    Have you tried to read out the Sub-type of bytearray...
  20. Replies
    4
    Views
    316

    Re: Package and deployment app throws error

    And since noone asked the pertinent question:
    Ist this error coming while "packaging" or while trying to use it to install on the target-machine?
  21. Re: Cant add any new tables to an existing database, can create database and add tab

    Shut the server down, clean up the data-folder and/or reinstall the Server again.
    Maybe you are using reserved Words: https://dev.mysql.com/doc/refman/8.0/en/keywords.html

    Next: is the my.ini in...
  22. Thread: Post Race!

    by Zvoni
    Replies
    68,853
    Views
    17,967,222

    Re: Post Race!

    Paranoid much? :D


    https://www.youtube.com/watch?v=-2n6bRMTlQ4
  23. Re: How to show a message to user that No record for this Primary Key?

    1) String-Concatenation of the SQL. Use Parameters

    2) Isn't there a "Records Affected" Property or similar? If RecordsAffected=0 --> No record found

    3) His code should never enter the...
  24. Thread: Post Race!

    by Zvoni
    Replies
    68,853
    Views
    17,967,222

    Re: Post Race!

    ZZ Top look-a-like??

    That said: to get this Thread back on track (way to serious):

    In another Forum a User asked what the abbreviation FFTL stands for (I think it was a shorthand for some...
  25. Thread: Very slow access

    by Zvoni
    Replies
    24
    Views
    1,709

    Re: Very slow access

    LOL.... i still can't believe, that there are users here, who haven't figured it out.

    To quote our Boss here (Steve R Jones): "It involves tom-foolery"
  26. Replies
    59
    Views
    1,525

    Re: Adding a huge number of records to a MariaDB

    OK, i'll take your word for it.

    That said: I agree. Probably best to use an ActiveX-Dll.
    The execution inside the dll can be "on hold" for as long as the server needs to insert the records.
    The...
  27. VS 2019 Re: Copying and loading files from Microsoft Teams

    My Condolences.
    My Company did the same, and boy did i swear up a storm.

    Problem 1: Teams allows to name Channels like "[AM] Blablablab Sometext"
    Problem 2 (inheriting from Problem 1): Teams...
  28. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Then i'm out of ideas.
    I don't bother with Windows for the last 7 Years exactly because of Bullsh*t like that...
  29. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Because Workbench connects natively, not via ODBC

    Look here
    https://www.connectionstrings.com/mysql/

    Look in your ODBC-32-Bit-Manager if there is a 3.51, 5.1 or 5.2 AFTER installing the...
  30. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Use Code-Tags!
    Remove/Comment out the On Error Goto Errhandler.
    The errhandler itself is wrong, and there is your problem: on an Error it jumps into errhandler, finds no code there and exits the...
  31. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Look in your ODBC-32-Bit Manager in Driver-Tab?!?!?!

    Why do i have to explain basic facts?!?!
  32. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    On Error Resume Next


    I thought picking up bones is illegal??

    https://dev.mysql.com/blog-archive/32-bit-odbc-driver-8-0-for-windows-is-back/

    Here switch to Version 8.0.36...
  33. Thread: Very slow access

    by Zvoni
    Replies
    24
    Views
    1,709

    Re: Very slow access

    If you meant "Quick Links - View Site Leaders", then i just received something "cryptic"

    Site-response



    Cannot use assign-op operators with string offsets on line 5445 in ...
  34. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Probably, the source code is riddled with OERN's
  35. Replies
    59
    Views
    1,525

    Re: Adding a huge number of records to a MariaDB

    How do you fire off that statement? There is a parameter….

    EDIT: Found it (though VBA)
    https://learn.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/execute-method-ado-connection

    ...
  36. Replies
    59
    Views
    1,525

    Re: Adding a huge number of records to a MariaDB

    it does exist. At least in the lib i use (6.1 i think), though in vba, but that shouldn’t make a difference
    Dim the connection object WithEvents and you‘ll see

    or go through the object catalog F2
  37. Replies
    59
    Views
    1,525

    Re: Adding a huge number of records to a MariaDB

    Ahhh….. that async-thing….. I should have mentioned that‘s ADO.
    that „Statement“ from MariaDB import page (LOAD DATA….) is basically an SQL-Statement you can fire off using the Connection/Recordset...
  38. Thread: RFID reader

    by Zvoni
    Replies
    8
    Views
    712

    Re: RFID reader

    your point? That’s your job to provide a „configuration“ functionality.
    Say, a form called „Config“ where the user can decide „today COM1 is check in, COM2 is check out“.
    the reader itself, and the...
  39. Replies
    59
    Views
    1,525

    Re: Adding a huge number of records to a MariaDB

    ... and since quantum computers are on the rise, this introduces a new "question": what to do if a coin falls on heads and tails at the same time? :D
  40. Replies
    59
    Views
    1,525

    Re: Adding a huge number of records to a MariaDB

    Just saw this one:


    Hell yes to it!
    Specifically when doing UPDATE's or DELETE's (though using Transactions for INSERT's is good practice).
    Though nothing to do with speed, but more with...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width