The Butter Connection

aka "stanguru.com" and "themargerums.com"

Computer Tips & Help
AS400
PC
Hardware
Programming
Web Development
Virus
Spyware/Malware
Spam
Hoax Don't Spread It
Sports
Multiple Sclerosis
Election Stuff
Photography
Handy Links
Interesting
Cool Things
Gamer Stuff
Gallery
Clarion · SQL · SQL Dates · SQL RPG examples · Batch Files

Programming Stuff

 

Sections(click on link below to goto a section on this page)

Misc Links

 

Icons

www.veryicon.com
www.iconspedia.com



 

 


Microsoft Data and Development

 

You might need some of these things to get programs working. Sometimes the programs come with them built into the install.

MDAC is used by alot of things.

 

LINKS

Microsoft SQL Downloads - http://www.microsoft.com/sql/downloads/default.mspx

.NET downloads - http://www.microsoft.com/downloads/browse.aspx?displaylang=en&productID=DE7BB609-3FD0-4B0F-865D-5ED2463AD5D0

.NET fix - http://support.microsoft.com/default.aspx?scid=kb;en-us;824643#XSLTH3137121124120121120120

MDAC downloads - http://www.microsoft.com/downloads/browse.aspx?displaylang=en&productID=B7ADDC23-DEC1-4C5F-8479-EAD9245A8D61

Troubleshooting MSDE2000 - http://support.installshield.com/kb/view.asp?articleid=Q111105

 

MDAC - Microsoft Data Access Components - latest is v2.8 (11/06)

  • there are different versions of this, but you should be safe d/l'ing latest...unlike the .NET packages

.NET ("dot net")- wiki says "is an umbrella term that applies to a collection of products and technologies from Microsoft"

 


TextPad Info and Tips

 

its like notepad on steriods, lotsa functionallity www.textpad.com

 

  • find 2 words in line: "word1.*word2" (check the box for regular expression)

Remove spaces and tab characters at the beginning of a line:
Find what: ^[ \t]+
Replace With: don't enter anything in the field
Remove spaces and tab characters at the end of a line:
Find what: [ \t]+$
Replace With: don't enter anything in the field
Add “Hello” to the beginning of every line:
Find what: \(^.*\)
Replace With: Hello \1
Add “Hello ” to the beginning and ” World” to the end of every line:
Find what: \(^.*\)
Replace With: Hello \1 World (watch the spaces)
Find empty fields (i.e. “, ,”) with spaces or tabs in, and replace with empty field (”,,”):
Find what: ,[ \t*],
Replace With: ,, (just that, nothing else, just 2 commas)
Remove blank lines in a text file, by searching for two linebreaks next to each other, and replacing with one:
Find what: \n\n
Replace With: \n

 

 


Date Stuff


Dates are always a problem... from formatting to storing to converting between systems ... they can be a real pain

  • MS Excel: The 1900 Date System vs. the 1904 Date System - http://support.microsoft.com/kb/180162
  • Day 1's - System Listing(OS and Programming) - https://en.wikipedia.org/wiki/System_time 
  • Clarion Date Stuff - on Clarion page
  • SQL Date Stuff - on SQL page
  • System Comparison(cut paste into SSMSE and play)

    /*

    MSAccess #1 = 12/31/1899 - format(0,"short date") - get opposite of a field defined as date/time to real/double - format(testdate,"Standard")

    MSSql #0 = 01/01/1900 - 1900-01-01 00:00:00.000 - select cast(0 as datetime) - get opposite - cast(getdate() as real)

    Clarion = 12/28/1800 -December 28, 1800 (starts at 4 being Jan 1 1801)
    MS Excel #1 = 01/01/1900

    */

    select

    CAST(CONVERT(datetime,'1900-01-01 00:00:00.000') as float) as SQLDay_0

    ,CAST(CONVERT(datetime,'1900-01-02 00:00:00.000') as float) as SQLDay_1

    ,CAST(CONVERT(datetime,'1899-12-31 00:00:00.000') as float) as [MSAccessDay1_negcomparedtoSQL]

    ,datediff( dd,'18001228','19000102' ) as clarion2example

    ,datediff( dd,'1800-12-28','1900-01-02' ) as clarion2example

    ,datediff(dd,-36163,'1900-01-02' ) as clarion3example

    ,datediff(dd,-36163,'1800-12-28' ) as ClarionDay_0

    ,datediff(dd,-36163,'1800-12-29' ) as ClarionDay_1

  • MS Access seeing the real number
    MS Access KB Article - https://support.microsoft.com/en-us/kb/210276
    Double number Date portion Actual date Time portion Actual time
    1 1 December 31, 1899 .0 12:00:00 A.M.
    2.5 2 January 1, 1900 .5 12:00:00 P.M.
    27468.96875 27468 March 15, 1975 .96875 11:15:00 P.M.
    36836.125 36836 November 6, 2000 .125 3:00:00 A.M.

  •  

     


     

     


  •  


    You are here: Home-Computer Tips & Help-Programming

    Previous Topic: Hardware Next Topic: Web Development

    Subtopics: Clarion SQL SQL Dates SQL RPG examples Batch Files