Search:
Type: Posts; User: ThiagoPSanches
Search:
Search took 0.03 seconds.
-
This forum is amazing...
Lots of knowledge and useful information . . .
thank you all
-
What would be a better option for Stream?
(I like Stream from RC5/RC6)
-
What is the purpose of using the "MainTbl" table?
Or rather, what do you need to get?
-
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...
-
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
...
-
"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,...
-
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
-
If the code in the first post suits you...
The problem would be just opening excel instead of saving the 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...
-
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
-
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)
-
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
-
Would it be this...?
Dim i As Long, sRet() As String
ReDim sRet(999)
For i = 0 To 999
-
That's pretty interesting!
Use a formatted Excel file template, without needing excel installed...
-
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...
-
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...
-
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...
-
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...
-
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)"
-
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...
-
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...
-
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...
-
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...
-
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...
-
There are parameters (pragmas) there that I didn't know...
Thank you for the informations!
-
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...
-
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
-
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...
-
It's solved!
It was something I was looking for ...
thanks
----------
Just a question / curiosity about your code ... it's better to use:
-
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...
-
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...
-
Very good ... thanks for the tip!
-
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
-
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...
-
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...
-
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...
-
Interesting!
This helps a lot to organize and better control the code ... exactly Timer operations.
Thank you.
-
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...
|
Click Here to Expand Forum to Full Width
|