New Commands in SQL CE 3.5 SP1 ?

  • jrlvid-657235

    SSC Journeyman

    Points: 80

    Hi,

    I am trying to port over from SQL Server 2005 Express

    to > SQL Server CE 3.5 SP1 (sql 2008 Commands mabee?):w00t:

    Want to use a query internal to Visual Studio 2008's Query

    Builder...

    Here is How the code looks in the Query Window of VS 2008 VB... Do NOT wan't to use Linq...!:hehe:

    SELECT [Record Number], Date, Car, Miles_Start, Miles_Stop, Gallons_FillUp, Miles_Stop - Miles_Start AS Miles_Total, (Miles_Stop - Miles_Start) / Gallons_FillUp AS MPG

    FROM Sheet1_Table

    ORDER BY Car, Date DESC

    It processes fine but does not work: Just Want to Preform Basic math on the Data Table. Add, Subtract, Devide and Multiply.

    In the "Advanced Options" of Query Builder the " Refresh The Data Table" Is greyed out... :w00t:

    Any Ideas where I can get a good command reference or PDF

    Book on SQL Server Compact Edition 3.5 sp1 ? 😉

    Any and all help would be appreciated!

  • Clinton-1139465

    SSC Journeyman

    Points: 79

    Hi,

    It uses Microsoft's query builder to edit the CommandText property among lots of other designer things. It's also open source so you can peek under the hood. Be warned though, in order to use Query Builder, you'll need to have a fully-functional GetSchema() method on your Connection object.

    ----------------------------------
    database browser

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply