Adding New User to LANSA SQL Database LANSADB

Because we have migrated to a new network profile, our access to our LANSA SQL database will now be denied.  These instructions can also be used if inheriting someone’s LANSA install and would like to continue using their existing environment.

 

You need SQL Management studio to add a new login user to SQL, if  not installed you can down load it from Microsoft’s Download center.

 

http://www.microsoft.com/en-us/download/details.aspx?id=7593

 

To add a new user to your SQL database

SQL SERVER 2008

Number 3 Microsoft® SQL Server® 2008 Management Studio Express
ugly2

Install using your pc name/ SQLSERVER as server name
ugly3

Right Click LOGINS and select New
ugly4

This is the ADD screen, use my credentials as a guide.
ugly5

ugly6

ugly7

ugly8

SQL SERVER 2008

 

 

Sterling Silver Small Currituck Beach Lighthouse Charm

Sterling-Silver-Small-Currituck-Beach-Lighthouse-Charm
Currituck Lighthouse was built in 1875 and is 162 feet tall. It took one and a half years to build and cost around $178,000 to construct. It was the last of four beacons placed at intervals from Cape Henry, Virginia to Cape Hatteras. It is located thirty-four miles south of Cape Henry Lighthouse and thirty-two and a half miles north-northwest of Bodie Island Lighthouse. This Charm was hand designed with great detail by Linc Mason. It has a hollow back and is 1″tall.

JDE Events

Listing of ER for Application : Item Master Application (P594101)
=======================================================================
     FORM: Item Master Revision [FIX INSPECT] (W594101A)
=======================================================================
     CONTROL:  FORM
     EVENT:  Dialog is Initialized
———————————————————————–
0001 VA frm_szProgramId_PID = “P594101”
0002 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0003 //

———————————————————————–
     EVENT:  Clear Screen Before Add
———————————————————————–
0001 // Instrustor led assignment
0002 // This event point occurs when the form first appears

Default today’s date
0003 FC Effective Date = SL DateToday
0004 // as the effective date
0005 //

———————————————————————–
     EVENT:  Add Record to DB – Before
———————————————————————–
0001 // FIle IO Trigger occurs before the add record
0002 // Initialize audit fields
0003 BC Program ID (F594101) = VA frm_szProgramId_PID
0004 //

———————————————————————–
     EVENT:  Update Record to DB – Before
———————————————————————–
0001 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0002 BC Program ID (F594101) = VA frm_szProgramId_PID
0003 //

———————————————————————–
     EVENT:  Variables
———————————————————————–
     frm_szProgramId_PID

=======================================================================
     CONTROL:  EDIT Effective Date
     EVENT:  Control is Exited
———————————————————————–
0001 // If left blank default to today’s date.
0002 If FC Effective Date is equal to <Null Date>
0003    FC Effective Date = SL DateToday
0004 Else
0005 End If

=======================================================================
     FORM: Work With Item Master [FIND BROWSE] (W594101B)
=======================================================================
     CONTROL:  FORM
     EVENT:  Dialog is Initialized
———————————————————————–
0001 Hide Grid Column(FC Grid, GC WorkStn ID)
0002 // This is initially hiding audit columns in grid..
0003 Hide Grid Column(FC Grid, GC UserID)
0004 Hide Grid Column(FC Grid, GC Time ofDay)
0005 Hide Grid Column(FC Grid, GC DateUpdated)
0006 Hide Grid Column(FC Grid, GC ProgramID)

———————————————————————–
     EVENT:  Media Objects – Row def
———————————————————————–
0001 Media Object Structures(GT594101, <MedObj Setup>, <MedObj Setup>, <MedObj Setup>, GC ItemNumber)

=======================================================================
     CONTROL:  HYPITEM &Select
     EVENT:  Button Clicked
———————————————————————–
0001 Call( App:P594101 , Form: W594101A )
        GC ItemNumber -> FI mnItemNumber

=======================================================================
     CONTROL:  HYPITEM &Add
     EVENT:  Button Clicked
———————————————————————–
0001 Call( App:P594101 , Form: W594101A )
0002 //

=======================================================================
     CONTROL:  HYPITEM Cop&y
     EVENT:  Button Clicked
———————————————————————–
0001 Call( App:P594101 , Form: W594101A )
        GC ItemNumber -> FI mnItemNumber

=======================================================================
     CONTROL:  CHKBOX Show Audit
     EVENT:  Selection Changed
———————————————————————–
0001 // This is to show or hide audit fields , by using check box
0002 If FC Show Audit is equal to “1”
0003    Show Grid Column(FC Grid, GC ProgramID)
0004    Show Grid Column(FC Grid, GC DateUpdated)
0005    Show Grid Column(FC Grid, GC Time ofDay)
0006    Show Grid Column(FC Grid, GC UserID)
0007    Show Grid Column(FC Grid, GC WorkStn ID)
0008 Else
0009    Hide Grid Column(FC Grid, GC UserID)
0010    Hide Grid Column(FC Grid, GC WorkStn ID)
0011    Hide Grid Column(FC Grid, GC Time ofDay)
0012    Hide Grid Column(FC Grid, GC DateUpdated)
0013    Hide Grid Column(FC Grid, GC ProgramID)
0014 End If

=======================================================================
     FORM: Item Master Revisions Multiple [HEADERLESS DETAIL] (W594101C)
=======================================================================
     CONTROL:  FORM
     EVENT:  Dialog is Initialized
———————————————————————–
0001 // Initialize the program ID
0002 //
0003 VA frm_szProgramId_PID = “P594101”

———————————————————————–
     EVENT:  Variables
———————————————————————–
     frm_szProgramId_PID

=======================================================================
     CONTROL:  GRID Grid
     EVENT:  Add Grid Rec to DB – Before
———————————————————————–
0001 // Populate Audit Field when a record is updated
0002 //
0003 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0004 BC Program ID (F594101) = VA frm_szProgramId_PID
0005 //
0006 // Force grid fields into db fields because system tries to use fields from
0007 // header instead of grid.
0008 BC Item Number (F594101) = GC ItemNumber

———————————————————————–
     EVENT:  Update Grid Rec to DB-Before
———————————————————————–
0001 // Populate Audit Field when a record is added
0002 //
0003 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0004 BC Program ID (F594101) = VA frm_szProgramId_PID
0005 //
0006 // Force grid fields into db fields because system tries to use fields from
0007 // header instead of grid.
0008 BC Item Number (F594101) = GC ItemNumber

———————————————————————–
     EVENT:  Row Exit & Changed – Asynch
———————————————————————–
0001 // Default to days date if left blank
0002 If GC EffectiveDate is equal to <Null Date>
0003    GC EffectiveDate = SL DateToday
0004 Else
0005 End If

Thursday January 03, 2013  15:32

What to Tip at Hotel

Not everyone agrees what guests should tip at hotels. Here’s what three etiquette and hospitality experts and three hotel companies suggest.

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Suggested tip by hotel guest

Etiquette expert Patricia Rossi:

Etiquette expert Jacqueline Whitmore:

Hospitality expert Roberta Nedry:

The Ritz-Carlton:

Hyatt Hotels:

Omni Hotels:

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Opening car door

$0

$0

$0

$0-$2

$0-$2

$0

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Parking car in valet lot

$0

$0-$3

$0

$0

$0-$2

$2

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Returning car from valet lot

$2-$5

$2-$5

$1

$2-$4

$1-$5

$2-$5

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Transporting bags from car to lobby

$1-$2/bag

$1-$2/bag

$1-$5

$0

$2-$5

$1/bag

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivering bags to guest room

$1-$2/bag

$1-$2/bag

$1/bag

$1/bag; $2/heavy bag

$1/bag or $5

$1-$2/bag

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Concierge

$0 for directions/restaurant recommendation; $3-$5 for show tickets/restaurant reservation; $15-$20 for sold-out-event tickets/premier restaurant reservation

$0 for directions/restaurant reservation; $10-$50 for hard-to-get event tickets/premier restaurant reservation

$0 for directions, information or simple reservations; $10 minimum for hard-to-get tickets/premier restaurant reservations

$0; $20-$30 for high-demand theater tickets/premier restaurant reservation

$0 for an answer to a simple question; $5-$10 for making dinner reservation and arranging transportation; $10-$50 daily for multiple bookings

$2/errand outside hotel; $1-$5/dinner reservation; $10-$20/reservation if recommended restaurant is outstanding; $5/event tickets; $10-$20/hard-to-get event tickets

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Maid

$3-$5/daily

$1-$2/twice daily

$1-$2/daily

$1/daily

$5 for one-night stay or $2/daily

$1-$5/daily

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Pool towel attendant

$1

$0; $1-$2 for special service

$0 unless special service is provided

$1-$2

$0

$1 if towel brought to you

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Spa personnel

15%-20%/service

15%-20% if not included in bill

15%-20%/service

$20/service*

15%-20%/service

10%-15%/service

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

One drink from bartender

$1

$1-$2 or 10%-15%

at least $1

$3-$4

15%-20%

$1

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

More than one drink from bartender

$1/drink

$1-$2/drink or 10%-15%

10%-20%

$5-$7

15%-20%

$1/drink; $5/round of drinks

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Waiter/waitress in restaurant

15%-20%

15%-20%

10%-20%

15%-20%

15%-20%

15%-20%

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Waiter/waitress at buffet meal

10%-15%

15%-20%

10%-15%

$5

15%-20%

10%-15%

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Wine steward

15%/wine bill

10%-20%/wine bill; $20-$30 if very expensive wine is ordered

10%-15%/wine bill

10%/wine bill

$0; tip on bill is sufficient

15%-20%/wine bill

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Servers during free food/drink at happy hour

$0 for food server; $1/drink

$0 unless tip jar is provided

$0 if guests get everything themselves

$0-$2

tip based on estimated retail value of free items received

$0

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Front-desk agent

$0; $3-$5 if give special service

$0

$0

$0 unless special service is provided

$0 unless concierge or bellman service is provided

$0 unless concierge service is provided

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivery of room-service order

$1 extra if 15%-18% tip is on bill; $18%-20% if no tip on bill

$0-$3 extra, plus tip on bill

$0, plus tip on bill, unless special service is provided

$2-$3 extra, plus tip on bill

$0, plus tip on bill

$0 unless very quick service is provided, plus tip on bill

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivery of extra towel, phone book or other requested item

$1/item

$1-$3

$0 unless hard-to-do item is requested

$0-$2

$0 unless special service is provided

$1

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivery of laundered/ironed clothing

$1-$3/item

$1-$3

$0; $5-$10 if require very quick turnaround

$2-$3

$0 unless special service is provided

$1

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Repair person fixing a problem in room

$2-$5

$0

$0

$0-$5

$0 unless special service is provided

$0

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

* = 10%-15% all-day service; $2 for robe/towel deliverySource: Etiquette and hospitality experts, hotels

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

 

Godaddy Coupon Codes Save Big

THURSDAY, NOVEMBER 10, 2011

10 november 2011 godaddy source codes
Last check 10 Nov 2011 Thursday checked and verified manually*, 22 Godaddy promo code listed.
1-click the code (automaticalaly copies to your clipboard)
2-just Ctrl+V (paste) to code field in Go daddy.
Popular Codes:
…………
7.49$ .Com domain registration (not for Renewals)

*Better then other codes on registrations
……………..
7.95$ .Com RENEWALS–Save more then 35% —

Best for .com renewals
……………………
$7.49 .Net .Org .Biz

*Better then other codes on registrations–
………..
Save 20% on ALL hosting plans

………………………………………….
Web Hosting from just $1.99 per month for 3 months!

…………………….
Save more than 50% on Ssl certificates /12.99$ ssl certification

………………………………………………………
General Codes–You can save for ANY product on your order with this codes.
……………….
Save $1 on your order

……………………..
Save 10% off your order -No minumum-Works for Renewals also-

…………………………
Save 5$ off your order 30$ or more-May work for Renewals also-

………
Save 5$ off your order 30$ or more

…………..
Save 10$ off your order 50$ or more-may work for renewals also-

……………….
Save 10$ off your order 50$ or more

………
Save 15% off your order 75$ or more–For renewals also-

…………..
Save 25% off your order – no minumum

……….
Save 26% off your order

………….
Save 33% off your order!

…………….
Godaddy Domain Promo Codes
…………..
Free private registration!

Expires november 23 2011.
…………
Register or renew .COM and .NET domains and SAVE before prices go up January 15, 2012.

……………
$7.49 .Net .Org .Biz

*Better then other codes on registrations–
…….
7.95$ .Com RENEWALS–Save more then 35% —

Best for .com renewals
………………
7.49$ .Com domain registration (not for Renewals)

…………
7.49$ .com domain registrations

…………
3.49$ .Us domain registrations

3.69$ with icann fee.
………………..
Renew your .Mobi domains for 10.99$-save over 40% and .Tv domains

The is the best code for .mobi renewals.means over 40% savings.
…………….
OTHER PRODUCTS
………………………
Save $30.00 off all Reseller Plans!

………..
Godaddy Auction Discount-save more then 40%

………………..
This blog is a service of Godaddy Promo Codes
*gmt +3