Rational robot sqlexecquery doubt
it is possible to execute the query say "select * from table" by using sqlexecquery in rational robot to retrieve data and diplay it .... likewise...
How to insert a record into the table via this query?
d is a user dsn name for a table say table1
handle = sqlopen("dns=d")
col= sqlexecquery(handle,"Insert into table1 values (45)")
anyidea .. pl guide me
Re: Rational robot sqlexecquery doubt
Yes you can do
1. Open your Robot IDE
2. Type SQL
3. HighLight SQL
4. Press F1
5. Popup will appear and shows possbile commands related to SQL. Get in to each command