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?
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?