Search:

Type: Posts; User: ThiagoPSanches

Search: Search took 0.03 seconds.

  1. Replies
    19
    Views
    1,991

    Re: Quirkiness with VB6 file I/O?

    This forum is amazing...

    Lots of knowledge and useful information . . .

    thank you all
  2. Replies
    19
    Views
    1,991

    Re: Quirkiness with VB6 file I/O?

    What would be a better option for Stream?

    (I like Stream from RC5/RC6)
  3. Replies
    12
    Views
    1,352

    Re: Count function and inner join problem

    What is the purpose of using the "MainTbl" table?

    Or rather, what do you need to get?
  4. Replies
    12
    Views
    1,352

    Re: Count function and inner join problem

    I'll try to explain what I did...

    ( you can also specify better what you need )

    From what I understand, the occurrences you want to "count" are contained only in the table "Tbl2"... so, the...
  5. Replies
    12
    Views
    1,352

    Re: Count function and inner join problem

    I wrote wrong, WHERE instead of ON.

    Try now:


    SELECT PID, count(*) AS totalDue FROM Tbl2 WHERE Due = 1 AND EXISTS(SELECT 1 FROM Tbl1 WHERE Tbl1.Item_ID = Tbl2.PID LIMIT 1) GROUP BY PID

    ...
  6. Replies
    12
    Views
    1,352

    Re: Count function and inner join problem

    "I think" this SELECT is right for you:


    SELECT count(PID) AS totalDue FROM Tbl2 WHERE Due = 1 AND EXISTS(SELECT 1 FROM Tbl1 ON Tbl1.Item_ID = Tbl2.PID LIMIT 1)

    Or this one:


    SELECT PID,...
  7. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    Delete the last line:


    xlObject.Visible = True

    Put this in place:


    xlWB.SaveAs "PathAndFileName.xlsx" 'Complete correctly with the Path and Name of the Excel File that will be saved
  8. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    If the code in the first post suits you...

    The problem would be just opening excel instead of saving the file?
  9. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    thanks!
  10. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    I really only see advantages too...

    But it's less usual for me to receive or work with XLSB files...

    When users in general save a file in Excel, they almost always save in XLSX (this is my...
  11. Replies
    5
    Views
    816

    Re: Overflow error

    Theoretically, there would be nothing wrong with your code...
    I don't know how to explain what is done internally, but this works:


    Long1 = (CLng(Byte1) * &H100) + Byte2
  12. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    Elroy and dilettante, perfect...

    My question is related to wqweto's library: Biff12 Writer

    Why doesn't this library generate in XLS or XLSX? (from what I understand it generates only in XLSB)
  13. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    I understand the limitations, I was surprised because it was something I thought was not possible...

    But with this module it is possible to generate in .xlsx or xls ? ... instead of xlsb
  14. Replies
    23
    Views
    1,975

    Re: Formatted data in textbox

    Would it be this...?




    Dim i As Long, sRet() As String

    ReDim sRet(999)
    For i = 0 To 999
  15. Replies
    35
    Views
    2,985

    Re: Can we create an Excel file?

    That's pretty interesting!

    Use a formatted Excel file template, without needing excel installed...
  16. Re: VB6 Like Operator Bug (Potentially Dangerous!)

    Now it's clearer!

    It's really not my case... I use Like a lot in internal functions, but never in data provided by users... for these cases I use Database Like, which you already mentioned that...
  17. Re: VB6 Like Operator Bug (Potentially Dangerous!)

    Hello Jpbro...

    I'm confused as to what the exactly problem is and if there is any workaround...

    I continue to use the Like operator in my projects and I have never had any reports of...
  18. Re: export sqlite table to excel

    Just adding to Schmidt's answer...

    There is also the option to transform the Rs RC5/6 into Rs ADO (via the "GetADORsFromContent" option) and then use the "CopyFromRecordset" command to generate...
  19. Re: Windows 11 and VB6 DBGrid not populating

    Do you use DbGrid (dbgrid32.ocx) and DAO?

    There is a "newer" version (5.1.98.39) of this grid that may have the bug you reported...

    ( If that's the case, one solution would be to replace the...
  20. Re: SQLite: delete all records from table that do not exist in another table

    We can do this with the "Exists" command:


    sSql = _
    "DELETE FROM Tbl2 WHERE " & _
    "NOT EXISTS(SELECT 1 FROM Tbl1 WHERE Tbl1.PID = Tbl2.PID AND Tbl1.Item = Tbl2.Item)"
  21. Re: RC6 - New encrypt option for Sqlite DB: SqlCipher

    Just change "OpenDB" to "CreateNewDB"... Like this:


    Dim sCn As New cConnection

    '*** Define 'CodecType' before 'OpenDB'
    sCn.CodecType = CODEC_TYPE_SQLCIPHER

    '*** Inform the Path and NEW DB...
  22. Replies
    14
    Views
    3,063

    Re: [RESOLVED] RC6.CSV ignores blank lines

    It worked really well...

    cCsv is a great solution for reading and processing large files... it has been very useful for me.

    Olaf, thanks for your help and attention!


    --
    Thiago Peres...
  23. Re: RC5 Simplest way to copy table from ADODB to SQLite

    I understand that we have to look ahead... and soon Windows XP will no longer exist (just as Windows 98 no longer exists)

    But, particularly for me, it has been a great loss that RC6 doesn't work...
  24. Replies
    14
    Views
    3,063

    Re: [RESOLVED] RC6.CSV ignores blank lines

    Olaf, thanks for the feedback, changes and explanations!

    But it still didn't work well for me...

    Here are some of those situations in the code...
    and also a workaround that served me...
  25. Replies
    14
    Views
    3,063

    Re: [RESOLVED] RC6.CSV ignores blank lines

    Taking advantage of this open and recent topic
    (if this is not appropriate, please let me know)

    I'm having a problem when any column has quotes

    Here is a clear example of the problem that...
  26. Re: RC6 - New encrypt option for Sqlite DB: SqlCipher

    There are parameters (pragmas) there that I didn't know...

    Thank you for the informations!
  27. Re: RC6 - New encrypt option for Sqlite DB: SqlCipher

    I meant that I was not able to open a DB created and encrypted by SqliteStudio on RC6...

    Everything is fine with SqliteStudio (it generates SqlCipher, by default, version 3... but it has options...
  28. Re: RC6 - New encrypt option for Sqlite DB: SqlCipher

    Now it worked!

    I tested it with the SqlCipher version 3 and 4.

    Here are some notes, in case anyone needs...



    Dim sCn As New cConnection
    Dim sRs As New cRecordset
  29. RC6 - New encrypt option for Sqlite DB: SqlCipher

    RC6 Sqlite provided some options for DB encryption (new "codec" property) ...
    One of the options is SqlCipher ... however, I couldn't find a way to open a DB generated and encrypted by the SQL...
  30. Re: Question about OpenDB Sqlite in RC5 / RC6

    It's solved!

    It was something I was looking for ...

    thanks

    ----------

    Just a question / curiosity about your code ... it's better to use:
  31. Re: Question about OpenDB Sqlite in RC5 / RC6

    jpbro, thanks for that more information ...

    It partially worked:

    When opening a DB, set 'locking_mode = EXCLUSIVE' and perform a save operation ...

    I tried to open the file in SqliteStudio...
  32. Re: Question about OpenDB Sqlite in RC5 / RC6

    I tested "PRAGMA locking_mode = EXCLUSIVE;"

    He accepted this "execute" and when consulting this Pragma, he returns "exclusive" ...

    However, the result was not what I expected ... because the...
  33. Re: Question about OpenDB Sqlite in RC5 / RC6

    Very good ... thanks for the tip!
  34. Question about OpenDB Sqlite in RC5 / RC6

    Is there a way to open a Database in exclusive mode (as in Access) ... ?

    If I want to guarantee this, should I do a separate control?



    --
    Thiago
  35. Re: replace Access database with SQL Express LocalDB in VB6 project on Windows 10

    As for the operation of Access in Windows, I really use it in all versions of Windows without problems.

    As for security, I felt obliged to share a solution, which I use... but I don't know if...
  36. Re: vbRichClient - Proxy configuration for Internet access

    Understood...

    Currently I already use ASP (IIS in 32-bit mode)... Converting 'ADO Rs' to 'RC5 Rs' (CreateTableFromADORs) and returning to the client in compressed bytes (FastLZCompress)...
    This...
  37. vbRichClient - Proxy configuration for Internet access

    First of all, I can't help commenting again, how amazing vbRichClient is (who still has doubts about it, look more carefully... is missing out on an unbelievable tool).

    Recently, I was studying...
  38. Re: [vb6] Block execution until Async method finishes

    Interesting!
    This helps a lot to organize and better control the code ... exactly Timer operations.
    Thank you.
  39. Re: VB6 elevated IE-Control-usage with HTML5-elements and COM-Event-connectors

    I did not know such a simple and effective way to "capture" IE events via vb6 pure - even here in the forum, there are many interesting tips on how to use IE Control, but not that way. The solution...
Results 1 to 39 of 39



Click Here to Expand Forum to Full Width