Search results for query: *

  • Users: Robert_SF
  • Content: Threads
  • Order by date
  1. R

    Question Can't get SQL parameter to work here

    SQL CE 3.5 -- This query returns a list of account numbers plus columns for current and late amounts, a simple A/R aging. SELECT accountnum, SUM(CASE WHEN DATEDIFF(d, GETDATE(), billeddate) < 31 THEN amount ELSE 0 END) AS curbal, SUM(CASE WHEN DATEDIFF(d, GETDATE(), billeddate) >= 31 THEN...
  2. R

    Order or invoice details table normalization

    A lot of times the rows that make up the body of an "order" are not column compatible. Even in the case of an ordinary grocery tab, you have things sold by weight and things sold by the piece. So you need a column for "weight" and a column for "$/weight" when you ring up a half-pound of...
  3. R

    Get identity of last inserted record

    Using VS2010 and SqlCE 3.5, I have the following code. Me.Validate() Me.CasesBindingSource.EndEdit() Me.CasesTableAdapter.Update(Me.DbCases.cases) 'Now we need the identity of the record just added To retrieve the identity (autoincrement number), I created a query in CasesTableAdapter with...
  4. R

    Same bindingsource between two forms: good practice?

    The MSDN documentation explains that you can use the same bindingsource between two forms, so that changes made on one form automatically reflect on the second. The procedure is explained here: How to: Share Bound Data Across Forms Using the BindingSource Component However, doesn't this...
  5. R

    Development strategy with VS Designer and Datasets

    I've programmed in various languages but am just getting started with VB Net under VS2010 Express and SQL CE 3.5. It's pretty cool how you can drag-and-drop from a Dataset and create forms that display parent records and their synchronized child records with no programming at all. But I've run...
  6. R

    Question Optional parameters and dates

    Hi everyone. I'm using VS2010 Express and SQL CE 3.5, and I'm trying to create a Query By Example form for a table. I read The Ins and OUTs of Parameterized Queries... and the subsequent discussion. I have my table adapter with a FillBy query: SELECT recid, clientid, lawyerid, inre, opened...
Back
Top