Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: I have my GUI concept but am unsure how to structure/implement my database

    Now this look promising.
    you‘re on the right path
  2. Re: I have my GUI concept but am unsure how to structure/implement my database

    That's pretty much, how my sample-DB looks like, except "Rarity" which has its own table ("table occurence")
  3. Replies
    8
    Views
    216

    Re: Search listbox in any order vb

    What about throwing the listbox-items at RegEx, using his search "word" as pattern?
  4. Re: I have my GUI concept but am unsure how to structure/implement my database

    Are those Column-Names or Sample-Entries for the 3 tables left hand side (What you've written within each "square" after/below "ID")
    Because i think you haven't understood how relationsships work
  5. Replies
    3,349
    Views
    413,030

    Re: What song are you listening to right now?

    Recently......

    Me: "Alexa, play 'Last Christmas' by Wham"
    Alexa: "Okay, i'm playing 'Last.... ?!?!? THE HELL I WILL!"
  6. Replies
    3,349
    Views
    413,030

    Re: What song are you listening to right now?

    So, in short: Watch a College-Football-Game, and you'll see/hear "Sousa"-Music? :D
  7. Replies
    3,349
    Views
    413,030

    Re: What song are you listening to right now?

    Well, the reason i started to listen to "other" music (and actually liking the odd song, i mean.... come on... 2PAC's "California Love" is a brilliant song),
    and let me tell you, that I've been...
  8. Replies
    9
    Views
    217

    Re: How to enable REGEX for RC6 SQLite?

    No idea, since i never used RC6, but wouldn't surprise me, since SQLite offers to use custom Functions --> https://www.sqlite.org/appfunc.html

    since SQLite is written in C, it's probable that the...
  9. Replies
    9
    Views
    217

    Re: How to enable REGEX for RC6 SQLite?

    Might be, but wouldn't have anything to do with OP's question.
    OP's question is about using the REGEXP-Operator/Function within SQL-Statements.
    And in DB Browser's case i'd guess they compiled the...
  10. Replies
    9
    Views
    217

    Re: How to enable REGEX for RC6 SQLite?

    Correction: Not compile sqlite.dll, but compile the regex.dll-extension yourself, and then load the extension
  11. Replies
    9
    Views
    217

    Re: How to enable REGEX for RC6 SQLite?

    Or compile the sqlite.dll yourself enabling the RegEx-Extension.

    If you download the source-code for sqlite, you'll find a folder "misc" in the folder-tree beneath "ext", and there is "regexp.c"
  12. Replies
    3,349
    Views
    413,030

    Re: What song are you listening to right now?

    First off: Metal is not Rock is not Metal.
    Confusing? Yes.
    Problem: The Definition of "Metal" has changed through time.
    e.g. --> A lot of people think Motörhead "Heavy Metal".
    The thing is: Lemmy...
  13. Replies
    9
    Views
    217

    Re: How to enable REGEX for RC6 SQLite?

    because Regex in SQLite is a application-defined function, which DB Browser has implemented
    https://www.sqlite.org/lang_expr.html
  14. Re: I have my GUI concept but am unsure how to structure/implement my database

    Here is an example based on your data (I've taken just the rudimentary stuff)

    For looking at SQLite-Databases i use DB Browser for SQLite: https://sqlitebrowser.org/dl/
    Just take the standard...
  15. Re: I have my GUI concept but am unsure how to structure/implement my database

    Imagine an entity called "Person"
    This "Person" has Attributes like a Primary Key called "ID", then First Name, Last Name, Date of Birth, Weight, Height, .......
    You'll find it very often, that...
  16. Re: I have my GUI concept but am unsure how to structure/implement my database

    To get you started:
    “Subject“, „Class“ and „Crystal System“ have their own (simple) table.
    “Name“ (obviously) goes into „stone“ as well as any numeric value („Hardness“ both) and the „magnetic“...
  17. Re: RecordsAffected Always Returns 1 After Update

    https://www.sqlshack.com/working-with-sql-server-rowcount/
    have you tried to SELECT @@ROWCOUNT immediately after your Insert/Update/Delete and check that value?
  18. Re: I have my GUI concept but am unsure how to structure/implement my database

    Tg answered the points for 1) and 2)

    For 3): you have to differentiate between how you display your Data, and how your Data is structured (tables, columns, primary keys, foreign keys etc.)
    e.g....
  19. Re: I have my GUI concept but am unsure how to structure/implement my database

    1) SQL is not a Database-System. It's the "Query"-Language. Or did you mean "Microsoft SQL-Server"?
    2) Ask yourself the following questions: Who is going to use that program at any time? Just...
  20. Replies
    10
    Views
    271

    Re: Access Update With Join

    Especially considering, since when MS Access is "available" (November 1992), and Microsofts "habit" of doing everything their own way .
    Considering, that MS had to support "Legacy" Sybase, they...
  21. Replies
    10
    Views
    271

    Re: Access Update With Join

    Untested


    Update T1
    Inner Join T3 On T1.WaypointID=T3.WaypointID
    Inner Join T2 On T1.SurveyID=T2.SurveyID
    Set T1.UploadDate=T2.StartDate


    It‘ Microsoft. What did you expect?...
  22. Replies
    6
    Views
    225

    Re: Issue with SQLite DB

    And did you try that on your time-field????
    EDIT: and if you wanted to insert current system-time, you could do it from within the SQL. No need for parameter
  23. Replies
    6
    Views
    225

    Re: Issue with SQLite DB

    agree with tg: there is no DateTime type in SQLite (as well those other „Xxx char“ - SQLite ignores those sizes and assigns TEXT), but there is an affinity. Meaning: SQLite will still recognize it,...
  24. Re: SQL Server Query - count if any rows have a certain value

    I've seen Rammstein in the early "00" in what you would consider "small" venues (capacity some 5-6K people)
    As for german "loud and heavy", the probably two "known" names would be
    Scorpions and...
  25. Re: SQL Server Query - count if any rows have a certain value

    You have two „then“ after the coalesce
  26. Re: SQL Server Query - count if any rows have a certain value

    OK, my Mistake.
    Remove the LAST GROUP BY

    and EXTPRICE comes from P21, so here goes


    SELECT M1.SONumber, COALESCE(IIF(M2.CountS>0,0,M3.EXTPRICE), M4.SumPrice, 'Ooops') AS Result
    FROM Jobs AS...
  27. Re: SQL Server Query - count if any rows have a certain value

    OK, i've cleaned up my code a bit

    I'm assuming EXTPRICE and ITEM are a Columns of Jobs.
    If it's somewhere else, do tell.


    -- zvoni's way:
    SELECT M1.SONumber, IIF(M2.CountS>0,0,M3.EXTPRICE)...
  28. Re: SQL Server Query - count if any rows have a certain value

    That‘s the part i don‘t understand:
    in which table is disposition now? In jobs or in this P21?

    edit: ah, ok, got it.
    just qualify disposition with p21
    ….. p21.disposition inside the subquery
    ...
  29. Re: SQL Server Query - count if any rows have a certain value

    Ok, missed that.
  30. Re: SQL Server Query - count if any rows have a certain value

    Have you tried my solution?
    adding the sum of EXTPRICE in my query is not black magic

    btw: your query doesn‘t correspond with your task.
    “if there is a line with S in disposition return 0...
  31. Re: SQL Server Query - count if any rows have a certain value

    [/B]
    Agreed. Missed that one (SQlite doesn't complain about such stuff).


    Agreed. But as you said: Table_Schema would explain it.
    As i understood it, there can be only one row with...
  32. Re: SQL Server Query - count if any rows have a certain value

    eh... No.... EQ_Port is in Column ITEM
  33. Re: SQL Server Query - count if any rows have a certain value

    Tested in SQLite.
    Syntax might differ to SQL-Server



    SELECT M1.SONumber, IIF(M2.CountS>0,0,M3.EXTPRICE) AS Result FROM tbl_mock AS M1
    LEFT JOIN
    (SELECT SONumber, COUNT(disposition) AS...
  34. Re: Open with OLE from VB6 Shell (or ShellExecute)

    i wouldn't know how OLE comes into this.

    1) what's the exact error message of this program?
    2) Have you checked if this program needs a "qualifier" for the file? --> in a shell: MyNonVB6Programm...
  35. Replies
    5
    Views
    185

    Re: Make CommonDialog filename non-editable

    Couldn't he provide the "planned" Filename, say, in the Caption of the Dialog?
  36. Replies
    3,349
    Views
    413,030

    Re: What song are you listening to right now?

    https://youtu.be/1S1fISh-pag
  37. Replies
    48
    Views
    884

    Re: Let's form an IT-Band....

    I think this one takes the cake……

    https://youtu.be/1S1fISh-pag
  38. Re: Check if same app runs on other PC in local network

    http://www.solidautomation.com/bryon/Using_UDP_and_Winsock_in_Visual_Basic_6.htm
  39. Replies
    6
    Views
    405

    Re: LOOPING dir and sub dir

    Somewhere deep in here i had a solution for this.... would have to search it
  40. Replies
    2
    Views
    237

    Re: An incredible bug in vb6 Int function!

    Just tested it. Cannot confirm.

    OTOH, if you want to remove the last digit, making sure no rounding whatsoever happens, use Integer division



    Dim g As Long
    g = 39838669
    g = g \ 10...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width