New Commands in SQL CE 3.5 SP1 ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server CE » New Commands in SQL CE 3.5 SP1 ?

New Commands in SQL CE 3.5 SP1 ?

Rate Topic

Display Mode

Topic Options

Author

Message

jrlvid-657235

Posted Sunday, November 02, 2008 4:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, November 02, 2008 4:43 PM
Points: 0, Visits: 9

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!

Post #595622

Clinton-1139465

Posted Thursday, August 06, 2009 7:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 06, 2009 7:05 PM
Points: 1, Visits: 0

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

Post #766641

« Prev Topic | Next Topic »

Permissions