Is it possible to execute create sql view through Fivewin and use the same?
Regards,
Milos
mtajkov wrote:Is it possible to execute create sql view through Fivewin and use the same?
Regards,
Milos
CsQL := "CREATE VIEW CUSTATE AS SELECT C.ID, C.CITY, S.NAME FROM CUSTOMER C LEFT OUTER JOIN STATES S ON C.STATE = S.CODE"
oCn:Execute( cSql )
oRs := FW_OpenRecordSet( oCn, "SELECT * FROM CUSTATE" )
xbrowser oRs
nageswaragunupudi wrote:No comments on RDDs
It appears the authors make the RDDs only for individual tables and do not allow to use the full power of sql.
cSql := "CREATE VIEW CONTACTS AS SELECT TABLE1.FIRST, TABLE1.LAST,"+;
"TABLE1.AGE, TABLE2.ADDRESS, TABLE2.EMAIL "+;
"FROM TABLE1 LEFT OUTER JOIN TABLE2 ON TABLE1.CODID = TABLE2.CODID"
GETADOCONN():EXECUTE(cSql)
SELE 0
USE CONTACTS
BROWSE()
SELE 0
USE table1 ALIAS "TEST1"
SELE 0
USE table2 ALIAS "TEST2"
GO TOP
SELE TEST1
SET RELATION TO CODID INTO TEST2
BROWSE( FIELDS OF EACH AREA)
nageswaragunupudi wrote:I did not understand your question. Can you please explain more clearly?
Return to FiveWin for Harbour/xHarbour
Users browsing this forum: Google [Bot] and 37 guests