Priya -
Let me show you the way, you would need to walk through,
Two parts,
1. GUI - getroproperty should give you the text.store it in a variable say VarGui
2. DB - recordset of the executed query should give you the same text.
You will need to define a " connection string " in order to connect to db. Use the API adodb.connection and adodb.recordset. Granulaize your sql qury so that it would fetch only the text you are going to compare. Store it in a variable. Say VarDb
3. Once you have both the values stored it Should be a cakewalk. Compare both the string which would mean If VarGui=VarDb then pAss else fail. If there is discrepancy in string then use instr or strcmp.
Does it help?
3.
Let me show you the way, you would need to walk through,
Two parts,
1. GUI - getroproperty should give you the text.store it in a variable say VarGui
2. DB - recordset of the executed query should give you the same text.
You will need to define a " connection string " in order to connect to db. Use the API adodb.connection and adodb.recordset. Granulaize your sql qury so that it would fetch only the text you are going to compare. Store it in a variable. Say VarDb
3. Once you have both the values stored it Should be a cakewalk. Compare both the string which would mean If VarGui=VarDb then pAss else fail. If there is discrepancy in string then use instr or strcmp.
Does it help?
3.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
