I am populating a DataGrid with the following LINQ code : Dim myClients = From p In dc.Persons _ Select p I can navigate my DataGrid, make changes and then click on a button that calls dc.SubmitChanges() All of this works well and updates SQL Server. I then wanted to add a single additional colu...
Please tell me how to use a calculated column in where condition in oracle 9i? I want to use something like select decode (:pValue,1, select sysdate from dual, select activation_date from account where AcNo = 1234) as calDate where caldate between startDate and endDate; ...
Hi I have two tables, Products and BundleProducts that have o2o relation with BaseProducts. A BundleProduct is a collection of Products using a m2m realtion to the Products table. Products has a price column and the price of a BundleProduct is calculated as the sum of the prices of its Products. BaseProducts have columns like name and ...
I have a SharePoint list with a column that was originally defined as date/time and has been manually populated with date/time information. I'd really like to populate this column automatically based on the status of another field changing (e.g. =IF([theStatus]="Closed",[Modified]). When I edit this date field that I'd like to add the ...