Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mobile SQL CE problem

Status
Not open for further replies.

prija

Programmer
Oct 17, 2002
28
YU
Hi,
I publish two sdf file to my handheld terminal from MSSQL server.
In my application on handheld I need to connect data from this two sdf file.
There are the model of two tables that I need to make relation and display data to grid.
First sdf file name are static_data.sdf and table are
PriceList with two filed:
IdPrice integer,
NamePrice nvarchar(50)
Second sdf file name are sales_data.sdf and table are
Sales with several field:
IdSales Integer(counter),
IdPrice integer,
DateSales datetime,
...
I need to display:
Sales.IdSales,PriceList.NamePrice,Sales.DateSales

On SQL server, when I have two database I write this code:
sales_data..Sales.IdSales,static_data..PriceList.NamePrice,sales_data..Sales.DateSales from sales_data..Sales,static_data..PriceList
where sales_data..Sales.IdPrice=static_data..PriceList.IdPrice

How to, I do the same on handheld with two sdf file?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top