Syndicate content

Page list for MS-Windows

  • A quick CSV (Comma Separated Values) reference:

    1) Row separator

      \n   \r\n

    In order to separate lines, use a newline character sequence.

    Most loaders probably support the \r sequence too. (Especially on MacOS/X)

    [toc hide:1]
  • Working with MS-Access and writing SQL queries to run via QODBC to get data from QuickBooks, I ran in a problem with dates.

    I needed to sum the sub-total of all the rows for a given year. So that is pretty simple SQL1:

    SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = YEAR(NOW())

    That does not work. So I tried to generate the year in the macro code and sticked that to the statement:

    SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = 2009

    And that does not work either.

    I tried ...

    • 1. Although at first I tried with BETWEEN, I simplify my samples here
  • Today I ran in a problem with cmake which was to very simply select /MT instead of /MD for a small set of projects. The problem is that so far this feature was at least on a per directory basis. Since the exact same directory is used to build the dynamic (DLL) and static (.lib) libraries, having two directories is not exactly an option here.

    set ( CMAKE_CXX_FLAGS_RELEASE "${CMAKE_CXX_FLAGS_RELEASE} /MT" )
    set ( CMAKE_C_FLAGS_RELEASE "${CMAKE_CXX_FLAGS_RELEASE} /MT" )
    set ( CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_FLAGS_RELEASE} /MTd" )
    set ( CMAKE_C_FLAGS_DEBUG ...
  • Synergration AccessBooksRT is a tool we use to get a copy of QuickBooks tables in an MS-Access database.

    It works great for our purpose and transformed some super sluggish forms into lightning fast forms. We still use QODBC for some of the work (updates) but 99% now goes through the database generated by Synergration instead.

  • Today I found a table describing the keystrokes you can use to generate different letters in another language than the bare ASCII set used in the US. For example, it is nice to use "à" in French whenever necessary because "à" (a preposition) has nothing to do with "a" (a conjugated verb).

    Microsoft includes that feature for most of their software. It may not work in all software, although you can always open wordpad and then copy and paste the output. (Notepad is not enough, it does not support UTF-8 or Unicode too well.)

    ...
  • I was ask by a customer to add line numbers to each entry in a table shown in an invoice.

    The concept is pretty simple, but really, how do you do that properly in MS-Access?

    Microsoft actually has a solution (see link below) and it comes down to writing a function that counts the number of items from that item's current position to the beginning of the table (i.e. going backward). It works, it is just really bad if you have very large invoices since it will tend to slow down as you start getting many items.

    There is the function, we can see the counting in the do until near the end ...

  • As I write programs, mainly in C++, I document them using the Doxygen tool. This is a very powerful parser that is capable to finding functions, variables, macros, and many other things in the source code and attach the corresponding documentation to those functions, variables, macros, etc.

    This is extremly practical when creating large projects or libraries that you want to share with others.

    One problem though, by default it seems like global functions (and thus C functions) and variables do not make it to the documentation, when C++ classes work fine.

    There are two potential issues:

    ...

  • Let's start with my rant!

    I like Drupal, in general. But like most PHP code bases, if an "error" (mistake) occurs, nothing is reported.

    I spent hours trying to make one of my menu work (Note that the "menu" module is also called the "links" module.) It just did not want to go. In order to have the nice breadcrumb and other such features, you need to have menus with sub-sub-menus...

  • Whenever you want the end user to edit a table, you create a form that shows a set of cells. These are defined in your form Details area. Up to here, nothing special about that.

    The fact is you cannot easilly access rows individually. That is, the TextBox, ComboBox, etc. in each row is considered the same whatever the row. So if you change the background color of a TextBox, all the TextBoxes of that column will be highlighted, not just the current row.

  • Pre-Pre-Scriptum: Please, look for the edll library. It is now available as a free library for MinGW.

Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

Find the page/content you are looking for with our index.

  • HTTPS

    Hyper Text Transfer Protocol Secure—The protocol used by browsers to communicate to web servers securely. The security is done with similarly to SSH. The transfer uses FTP like commands, but only one connection. Since HTTP 1.1 it is also possible to reuse the same connection for multiple files (pages, images, videos, etc.)

  • SSL

    Secure Socket Layer, this is a protocol used to transmit secure data between two computers. Both computers will first agree on an encryption secret code, then all the data sent back and forth will be encoded using that code. In order to make it secure, you generate two set of numbers (called keys) one that is public and one that is private. The public key sole purpose is to encrypt the data. The private key sole purpose is to decrypt the data.

  • inside
  • qemu
  • zlib

    The Z library is a compression library based on an algorithm that compresses at best in some automated and simle way. For better performance, the entire input file is necessary. Note that you can get better results with other methods, this one is excellent for streaming, however.