Hi
Please help me create a trigger. This is the code but i am getting errors
CREATE Trigger MyTrigger
AFTER
update [or delete] on dbo.Products
REFERENCING OLD AS oldRow
for each row
BEGIN
UPDATE ncache_db_sync
SET modified = 1
WHERE cache_key = (Cast(Select oldRow.ProductI D FROM deleted OLD) As VarChar) + ':dbo.Products'
END TRIGGER;
...
questionit
Last Activity: Sep 10 '09, 06:10 AM
Joined: Feb 14 '07
Location:
-
sql statement writing
Hi
I have following SQL Queries. Is there a way to to write a single query instead somehow instead?
-Get OrderID from this query
SELECT OrderID FROM Orders WHERE CustomerID='" + reader.Item("Cu stomerID")
-Using OrderID, get ProductID
"SELECT ProductID FROM OrderDetails WHERE OrderID=" + readerp.Item("O rderID")
-Using ProductID, get... -
sql statement writing
Hi
I have following SQL Queries. Is there a way to to write a single query instead somehow instead?
-Get OrderID from this query
SELECT OrderID FROM Orders WHERE CustomerID='" + reader.Item("Cu stomerID")
-Using OrderID, get ProductID
"SELECT ProductID FROM OrderDetails WHERE OrderID=" + readerp.Item("O rderID")
-Using ProductID, get... -
gridview custom no. column
Hi
New to vb.net
I create a GridView. It has default three columsn. cant find the way to delete a colmn, i want only 1 column in it
how to do this from design view?
thanks
qi -
retrieve n number of rows from table
How do i retreive 10 rows from a table using SQL
SELECT Names from Customers... how do i change it to retrieve only 'n' number of rows?
Please suggest an easy method
Thanks -
insert into - add multiple values in a column
Hi
How do i write multiple values in a single column, using INSERT INTO
I have a listbox and i want all the selected values from that listbox inserted into a table column
INSERT INTO Orders(OrderID, Items) VALUES ____?????______ __
Do i need to run the above statement in a loop?
Thanks
qi -
reading error from table - vb.net- using OleDbDataReader
Hi
When i run the program, i get error on the statement inside Do While Loop. The piece of code from my application is:
...Code:Dim selectString As String selectString = "Select ContactName, Address from Customers" Dim cmd As OleDbCommand = New OleDbCommand(selectString, con) Dim reader As OleDbDataReader reader = cmd.ExecuteReader()Last edited by tlhintoq; Jun 22 '09, 05:00 PM. Reason: [CODE] ... your code here ... [/CODE] tags added -
retrieve all records from table using OleDbConnection
Hi
Like we can retreive all the records from a table using this method:
While (Not rst.EOF)
....
End While
How to retrieve all the records when using OleDbConnection
Thanks
qi -
retrieving data from a database (sql server)
Hi
What is the best data collection method to store data from database in the following format:
Table: Customers
Fields: Name, Address, Telephone
Is HashTable good, or something else you would recommend? If its hashtable, what would be the key since there are all "string" data type in the table. Also, since there are more than one field i.e Address, Telephone, how would i save these in... -
Toolstrip ASP.NET
HI
I am using Visual Studio 2005 and creating ASP.NET page. The problem is that i can not find Toolstrip in the ToolBox. When i tried to locate it by clicking on Choose Items , but there is no such toolstrip for Web.
Please help -
That was so clear and informative.
Thanks a lot !! -
Linking
What is Linking in a compiler. What does linking do, why is it required?
Thanks
qi -
open websites automatically with javascript
Thanks for reply. that was helpful
but i do not want a button. instead when the HTML file is double-clicked, it should open the specified websites automatically, how to do that?Leave a comment:
-
open multiple websites with javascript
Hi
how can i write a javascript that will open multiple websites together.
when the jaascript file is created and saved on the hard drive. when i double-click on it, it should open different websites that i type in the javascript code ?
Thanks
Qi -
Network Setup Wizard - XP
Hi
I have set up networking between two PCs, conntected them with LAN cards.
I ran Network Setup Wizard and both computers have now access to Internet.
The problem is that the secondary computer (the one not directly connected to Internet) looses network connectivity whenever it is restarted. I will then have to re-run Network Setup Wizard on the primary computer everytime.
What could be... -
PCi vs SATA
Hi
Could any one please explain the difference between PCI and SATA ?
I cudnt find it on the internet
Thanks
Qi -
networking
Hi Don
thanks for your reply
I checked the Firewall, but it is already enabled.
i am able to use Internet and
anything else to check?Leave a comment:
-
networking b/w 2 PCs
I have connected two PCs with thier LAN cards. Both PCs run Windows XP.
I ran Network Setup Wizard and now i am able to access Internet from the other PC.
The problem is that i can not ping the new PC . I am unable to ping from the primary PC ( Where i ran the Network Setup Wizard and which is connected to Internet), it outputs "Request timed out" in all 4 tries. But can ping from the other PC.
... -
Networking
DonRayner,
I am trying wireless networking, which means i am using wireless LAN (Ethernet) cards instead. So i do not need any cable.
Only problem i am having is with the USB wireless ethernet card which is not detecting any network whereas the PCI ethernet card is detecting one network.Leave a comment:
-
networking between two computers
Hi
I have installed a PCI Ethernet card on my Desktop PC and a USB Ethernet adapter on Laptop PC.
When i search for networks from PC, it finds one external network but no other internal network. When i do the search from Laptop, it does not find any network at all ..... what could be the reason?
I am wanting to network between my Laptop and Desktop. Are there any special settings needed for USB ethernet?...
No activity results to display
Leave a comment: