Featured Article: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
mNo edit summary
m (Featuring Eddy Kleinjan :P)
Line 1: Line 1:
For some kinds of system - typically those which provide the same service to a number of different customer organisations - there may be a need to maintain multiple versions of some of the database tables, held within the same database server instance.
... sample code that fills up a 2-column grid with data which is retrieved from a SQL Server backend using a SQL Statement that is dynamically created. Note that it uses the existing connection from an already opened table called Customer. This way you don't have to make the connection with the SQL Server yourself and it is more maintenance friendly in case the tables get move over to a different server or database.
A typical example might be where the same database was to hold data for a number of customers, about their customers, but some of the tables would ideally be global - shared by all the customers.


('''[[Dynamic_Database_Switching|more...]]''')
 
('''[[ExpressConnectivity|more...]]''')

Revision as of 12:11, 5 September 2008

... sample code that fills up a 2-column grid with data which is retrieved from a SQL Server backend using a SQL Statement that is dynamically created. Note that it uses the existing connection from an already opened table called Customer. This way you don't have to make the connection with the SQL Server yourself and it is more maintenance friendly in case the tables get move over to a different server or database.


(more...)

Retrieved from "https://dataflex.wiki/index.php?title=Featured_Article&oldid=2123"