English|Português|Español
UserPasswordLogin

HOME
SESSIONS
INFO
how to 300

How to: Create a Data View to connect to SQL Server from a PocketPC

In the example below we will create a data view to the apersona database in order to allow local data to be synchronized with the central sql server when mobile devices are connected to the network.
The NET Mobile platform supports the use of both SQL CE and SQL Server as database.

We can define the tables of the mobile application in SQL CE and some in SQL Server and access them through a Data View. This would allow us to use a GeneXus procedure to copy data directly from one table to another.

Upon performing the following steps, the network can be “seen” while being connected to the device base and it is connected, in turn, to a PC (read communication mechanisms). Being part of the network allows you to view the rest of the machines and this enables you to access the central databases. That’s how the creation of Data Views to the tables of those bases will make it possible to develop mobile applications that handle that data.

Read step-by-step information on the CommunityWiki 
 



The Data View object allows defining all the information related to a table of an external database, in order to access it as any other table created with GeneXus.
Related
How to: Define a Query Object in the Knowledge Base
How to: Expression Data Type
How to: Query Object
How to: Transform the pattern templates into dll and make them available to the client
How to: Workflow
How to: My first pattern
How to: GXflow in GeneXus X Evolution 1
How to: GXflow and Query Object in GeneXus X Evolution 1
How to: GXflow
How to: Transferring changes from GeneXus 9 to GeneXus Evolution 1 safely
How to: Conversions of GeneXus applications
How To: GXportal 5.0 Image Gallery
How to: GeneXus with DBMS in the cloud
How to: GXflow
Special Edition #GeneXusTheBestOf2014 :: Cloud Computing, the Internet of Things, GeneXus X Evolution 3, Success Stories, Smart Devices and ... Much More!