How to do something like:
Proper(“GALHANO.COM”) = “Galhano.com”
there’s no builtin function to do this but we combine CONCAT and SUBSTRING:
CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)),LOWER(SUBSTRING(`fieldName`, 2)))
Author Archives: admin
mysql ‘Proper case’ formating a column?
21 de Novembro de 2012 – 15:27
Enterprise Library
26 de Outubro de 2012 – 8:32
The Microsoft Enterprise Library is a collection of reusable software components (application blocks) designed to assist software developers with common enterprise development cross-cutting concerns (such as logging, validation, data access, exception handling, and many others). Application blocks are a type of guidance; they are provided as source code, test cases, and documentation that can be used “as is,” extended, or modified by developers to use on complex, enterprise-level line-of-business development projects.
Yahoo Condition Code
22 de Outubro de 2012 – 9:01
Yahoo Condition Code
Condition codes are used in to describe the current conditions.
If you want to personalize conditions image icon, you must provide this set of icons:
Code Description
0 tornado
1 tropical storm
2 hurricane
3 severe thunderstorms
4 thunderstorms
5 mixed rain and snow
6 mixed rain and sleet
7 mixed snow and sleet
8 freezing drizzle
9 drizzle
10 freezing rain
11 showers
12 showers
13 snow flurries
14 light snow showers
15 blowing snow
16 snow
17 hail
18 sleet
19 dust
20 foggy
21 haze
22 smoky
23 blustery
24 windy
25 cold
26 cloudy
27 mostly cloudy (night)
28 mostly cloudy (day)
29 partly cloudy (night)
30 partly cloudy (day)
31 clear (night)
32 sunny
33 fair (night)
34 fair (day)
35 mixed rain and hail
36 hot
37 isolated thunderstorms
38 scattered thunderstorms
39 scattered thunderstorms
40 scattered showers
41 heavy snow
42 scattered snow showers
43 heavy snow
44 partly cloudy
45 thundershowers
46 snow showers
47 isolated thundershowers
3200 not available
This allows you to create your own custom icons.
<img src=”/img/{current_condition_code}.png”>
Outlook.com
15 de Outubro de 2012 – 14:41
With the arrival and availability of its latest e-mail service, the Outlook.com, Microsoft takes a giant step forward in renewing the service Hotmail disponibilizava, and seeks to bring back all users over the years were opting for other services that were appearing and showed themselves better.This email service based on the Internet has all the features you would expect from a similar platform, but also brought some of the features that were already in Hotmail, albeit reinvented and adapted to this new platform.
One of the most interesting that we have at Outlook.com is the ability to create email addresses associated with your personal account. Watch as they can.
A modern interface: faster and cleaner
The simple, fluid and interactive design of Outlook makes it easy to use whether you’re on a desktop, phone or tablet.
Get an Outlook email address for your new inbox
You can get a new email address from Outlook. You don’t have to worry about your contacts and previous emails, you’ll keep them. And, you’ll continue receiving messages sent to your Hotmail address.
Bring your inbox to life — Connect Facebook and Twitter
Connect and see your friends’ Facebook updates and Tweets directly in your inbox. Your contacts’ information is automatically in sync so you don’t miss a thing.
Yahoo! Query Language
25 de Setembro de 2012 – 9:50
What is YQL?
The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint.
Yahoo! and other websites across the Internet make much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endure the pain of locating the right URLs and documentation to access and query each Web service.
With YQL, developers can access and shape data across the Internet through one simple language, eliminating the need to learn how to call different APIs.
How Do I Get Started?
- Check out the YQL Console.
- Complete the The Two-Minute Tutorial.
- Read how to access YQL from your application.
- Get your API Keys to sign your requests if you need them.
- Check out the YQL frequently asked questions (FAQ) for answers to common issues.
read more
Gerenating a GUID using Delphi 7
21 de Setembro de 2012 – 11:49
GUID – Globally Unique IDentifier
In Delphi, GUID values are represented with the TGuid record defined in the System unit. A Guid value is a 128-bit integer (16 bytes) that can be used in database applications when a unique identifier is required.
When developing database applications, the TGuidField is used to represents a guid field in a dataset.
procedure TForm1.btnGetGUIDClick(Sender: TObject); var Guid: TGUID; begin CreateGUID(Guid); form1.label1.Caption := GUIDToString(Guid); end;
Consuming ASP.NET 2.0 Web Services in Delphi for Win32
20 de Setembro de 2012 – 20:00
A couple of years ago I wrote an article Consuming C# Web Services with Delphi 7 Professional, and while the information in the article is still correct, it’s no longer complete, because ASP.NET 2.0 changed the rules a little bit.
Even if you follow the examples exactly on creating the web service in C# and in creating the consuming application in Delphi for Win32, no matter what you try to echo, the result will always come back as 0 for numbers or as an empty string for strings.
This is due to the fact that the C# web service is deployed on an ASP.NET 2.0 machine (which changed some of the ways WSDL was published compared to .NET 1.1).
The problem is caused by the fact that any .NET Web Service is using the document|literal binding. With ASP.NET 1.x Web Services, this was specified using element, but with ASP.NET 2.0 Microsoft has changed that and now specifies the style in the operation input and output nodes instead of the binding element. The Delphi Win32 WSDL Importer is not able to recognise this, and as a result the generated import unit is using the (for Delphi default) binding type of RPC instead of the .NET document|literal binding type.
CodeGear is aware of the situation, and is already working on fixing the problem in the Win32 WSDL Importer. In the meantime, there is a workaround available that you can use, namely manually specifying the ioDocument as InvokeOptions for the SOAP interface type, as follows:
InvRegistry.RegisterInvokeOptions(TypeInfo(xxx), ioDocument);
Where xxx is the name of your SOAP interface type.
This line of code needs to be added to the initialization section of the generated Win32 import unit, and will make sure the parameters and result types are no longer empty when Win32 clients are talking to ASP.NET 2.0 Web Services.
source link:
Bob Swart 2/5/2007 10:04:56 AM (GMT+1)
Delphi Default IDE Shortcut Keys
20 de Setembro de 2012 – 18:27
Delphi Default IDE Shortcut Keys read more
How to close Apps in Windows 8
12 de Setembro de 2012 – 16:39
There are 4 ways you can close metro apps in the new Windows 8:
- If you have a touch screen tablet or laptop, touch your finger on the top of the screen and drag it all the way to the bottom. It will minimize and move the app from your way.
- If you don’t have a touch screen but you use a mouse, do the same with the mouse. Point your mouse on the top of the screen and drag it all the way down. When you point the mouse to the top of the screen, you can see the cursor is changing.
- Press ALT key + F4. This will still work just like the traditional Windows programs.
- The killer option: use ALT+CTRL+DEL and kill the app using the task manager.
Home