Syndicate content

Pages with category Development

  • MS-Access defines many different types, including a newer one called DECIMAL.

    You are supposed to be able to create tables with the DECIMAL type. So a statement such as:

       CREATE TABLE MyTbl (decimal_test DECIMAL(20, 5))
    

    should work. Right?

    I have been using CurrentDb.Execute for a while and that statement was causing the Execute function to return an error saying that the field definition was erronous (Syntax error in field definition, to be exact).

    The trick is very simple!

  • As I am now using git, I like to create my own repositories. In most cases the documentation is not that easy to follow. Here are the instructions I use.

    First of all, I setup my own personal configuration (it can be used as a global setup for you). This is written in the ~/.getconfig and looks like this:

    [user]
        name = AlexisWilke
        email = me@my-top-secret-email-address.com
    
    [core]
        excludesfile = ~/.gitignore
    [push]
        default = simple
    [giggle]
        main-window-maximized = false
        main-window-geometry = 1114x789+144+184
        file-view-vpane-position = 389
        ...
  • I have been wondering, for a while, how the triggers where generated in Drupal. I know that one can catch a message by writing a hook function and you have hundreds of those available. However, how are the triggers working?!

    The fact is that triggers require you to write a function. The Core Trigger module has a set of specialized functions for the Core modules and it is limited to that. In other words, you cannot expect new modules to simply define an array and get the triggers to work (I was really wondering how could that really work?!)

    [toc hidden:1]
  • Today I finally found out how to fix the path of the forums.

    The name of the vocabulary is "Forums". To access it as expected in pathauto, you use [vocab-raw].

    The result of [vocab-raw] is "forums" (all lowercase.)

    Then, by default, pathauto adds the list of categories to the path. This is done using the [catpath-raw]. Say you have a forum named "Linux Stuff", [catpath-raw] will return "Linux Stuff" as is. This makes sense because paths on Linux are case sensitive (actually, it's the same thing with Apache wherever you are using it, although it's a

  • As I'm slowly learning CUDA, I got some of the tests running. Those under 1_Utilities actually define the parameters (stats) of the card. There are the parameters for an NVidia Quadro 600:

    Device 0: "Quadro 600"
      CUDA Driver Version / Runtime Version          5.0 / 5.0
      CUDA Capability Major/Minor version number:    2.1
      Total amount of global memory:                 1024 MBytes (1073283072 bytes)
      ( 2) Multiprocessors x ( 48) CUDA Cores/MP:    96 CUDA Cores
      GPU Clock rate:                                1280 MHz (1.28 GHz)
      Memory Clock rate:                      ...
  • Yesterday, I got a nice little surprise...

    I inadvertendly added two copies of an uncompressed MS-Access data in my CVS. The files were over 400Mb (about 434Mb if I'm correct.) This started okay, then slowly I could see my memory going banana.

    Wow! It took a good 20min. to check-in. My CVS is on my computer, so it is not the transfer that's slow... The fact is, the allocated a buffer for the entire file! My computer was on its knees!

  • 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:

    • 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.

  • Large version of the waiting wheelAs I'm working on a new feature for our Snap! Website system I wanted to have a turning wheel that asks users to wait while the computer does work.

    The graphic is very simple: a rectangle with a border and a background color that rotates. However, I do not have a tool (that I know of) which could create the graphics automatically. So I did it with quite a bit of manual labor, but it was fun to learn a few things along the way.

    I use inkscape to create such graphics. First I created the rectangle on the left. With that I had to have it rotated going 360 degrees repeating the rectangle 24 ...

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.