Question about Microsoft Computers & Internet

1 Answer

Time based triggers or procedures

How to write triggers, in a table one field value decrement by one for next day

Posted by on

  • better-swiss May 11, 2010

    segrireddy,



    is this SQL Server or what other product ?!?!

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 20 Answers

Syntax to create Triggers in SQL are :

Create Trigger trigger_name // "trigger_name" : Give name to the trigger
on
table_name // "table_name" : name of the table on which trigger has to created
for Update
as

Begin

// Here Query has to be written here

End


Posted on Dec 20, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I need to open port for xbox live


Starting the SBG900 Setup Program

1. On a computer wired to the SBG900 over Ethernet or USB, open a Web browser. Do not attempt to configure
the SBG900 over a wireless connection.

2. In the Address or Location field, type http://192.168.100.1 or http://192.168.0.1 and press ENTER to display
the Log In window:brymz.jpg

3. In the User ID field, type the User Name; the default is "admin" (this field is case sensitive).
4. In the Password field, type the Password; the default is "motorola" (this field is case sensitive).
5. Click Log In to display the SBG900 user configuration and status windows:
brymz_0.jpg

6. Then click on "Gateway" located at the left corner.
7. Then click on "Port Triggers".
8. Then choose "custom"

brymz_1.jpg

And from there:

ADD NEW SPECIAL
APPLICATION

Name Enter the unique name for the port trigger. This is typically the protocol.
Enable Select this box to enable the custom port trigger.
Protocol Sets the transport protocol for the port trigger - TCP or UDP.
Port Range Sets the port range for the port trigger. Type the start of the range in the
(From:To) left field and the end in the right field.

Session Chaining Enable session chaining if the application needs to open one or more ports in
different ranges to operate properly. The options are Disable, TCP, TCP/UDP.

Session Interval Sets the session interval for the application:
• If the port triggers detect traffic on the Port Range within the Session
Interval, it is considered to be related to the initial session.

• If the port triggers detect traffic on the Port Range after the Session Interval
expires, it is considered to be a new and unique session.

Address Replace Sets the address replacement method for the application.
Multi Host Select if appropriate for the application.
Add Click to add the port trigger to the PORT TRIGGERS TABLE.
PORT TRIGGERS TABLE Lists all port triggers you defined and their parameters.

Hope it help you....

Sep 13, 2011 | Arris SURFboard SBG900 Wireless Router...

1 Answer

Configure.csv


CSV means:
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.

Dec 27, 2010 | Acer TravelMate 2300 Notebook

1 Answer

How do i get my gprs working


AT&T:
Main Menu
* Entertainment
* Services
* Data Account
* GPRS
- Find one free account (like Account 8, etc)
* Edit
- Change 'Account Name' and put the value 'ATT MMS'
- In 'apn' field put the value APN (which is wap.cingular)
- Fill the fields username and password with the ones on the table USER and PASSWORD (you don't actually need a user name and password for AT&T, you can leave these blank)
-Click 'Done' and say Yes to Save.

* Main Menu
* PIM
* Messages
* MMS
* Message Settings
* Server Profile
- Find one free account (like Profile 8, etc)
* Edit Profile
- Rename Profile and put the value 'ATT MMS'
- In Homepage field put the value HOMEPAGE (which is http://mmsc.cingular.com)
- In 'Data Account' select GPRS and then the account created before (the MMS one).
- Select 'Connection Type', choose HTTP and click OK
- Fill in the fields Proxy Address with PROXY and Proxy Port with PORT. Then click OK (066.209.011.061 is the proxy and 9201 is the port number)
- Fill the fields username and password with the ones on the table USER and PASSWORD (don't need a user name and password)
* Go back and Activate Profile

Nov 16, 2009 | AT&T CECT Unlocked i68+ Quadband GSM FM...

2 Answers

Access database was copied now no tables in dropdown list


Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Computers & Internet

1 Answer

Excel


Would you not be better off with a pivot table ?

To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.
When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..
you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.

Hope this makes sense

Aug 12, 2008 | Microsoft Excel for PC

1 Answer

MySQL Auto Increase


Try this -


CREATE TABLE users (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
login TEXT NOT NULL,
password TEXT NOT NULL,
PRIMARY KEY( id )
);

INSERT INTO users VALUES ( null, 'bob', 'mypassword' );
INSERT INTO users VALUES ( null, 'bill', 'pass' );
INSERT INTO users VALUES ( null, 'sean', '1234' );

Aug 04, 2008 | Sun MySQL

1 Answer

Conversion of nemeric value


If you just want to change the format to text in a query, you can use the Str function in your query. In MS Access, in the Field area of your query in Design View, you can type the following:
YourDesiredCharFieldName: Str([YourNumericFieldName]).

On the other hand, if you prefer to convert the data once and for all in your table, you can go to the Table Design View for that Table, change the Data Type of your numeric field to "Text", and close that window to save the changes. This will convert all of your data in that field from numeric to text permanently.

Jul 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Ms access


Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

Computers & Internet Logo

Related Topics:

123 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...