RefreshRecord problem

yeah_xxc · Post by **yeah_xxc** » Thu 17 Aug 2006 10:20

I use the SmartQuery->Append,...,SmartQuery->Post method to insert a record including field named "TDATE", and get the record with additional field "TO_CHAR('TDATE','YYYY')". Problem happens while "TDATE" is refreshed but "TO_CHAR('TDATE','YYYY')" is still "".After RefreshRecord is used, it doesn't work.

p. s: Using Refresh methord is OK but not fitting to my need.

Don Horn · Post by **Don Horn** » Thu 17 Aug 2006 14:08

"TO_CHAR('TDATE','YYYY')".

Are quotes around TDATE just a typo?

yeah_xxc · Post by **yeah_xxc** » Fri 18 Aug 2006 07:13

yah! just typo! And then?

Plash · Post by **Plash** » Fri 18 Aug 2006 09:02

To make the RefreshRecord method refresh the field TO_CHAR(TDATE,'YYYY') you should set SQLRefresh property of TSmartQuery. For example, if your table primary key is named as 'ID' then assign such a string to SQLRefresh property:

Code: Select all

WHERE ID = :ID

yeah_xxc · Post by **yeah_xxc** » Fri 18 Aug 2006 09:53

I got this "Refresh failed, found 0 record", but the record really exists when I use oraExplorer to check it out.

yeah_xxc · Post by **yeah_xxc** » Sat 19 Aug 2006 02:46

??????

Plash · Post by **Plash** » Mon 21 Aug 2006 09:26

Please provide us values of SQL and SQLRefresh properties that you have assigned for SmartQuery.

yeah_xxc · Post by **yeah_xxc** » Tue 22 Aug 2006 11:38

The SQL contains "WHERE ID Refresh().

Plash · Post by **Plash** » Wed 23 Aug 2006 12:44

In this case you need to assign to SQLRefresh property full SELECT statement. This statement should be the same as in SQL property but instead of "WHERE ID < 5" write "WHERE ID = :ID". For example:

Code: Select all

SELECT *, TO_CHAR(TDATE,'YYYY') FROM Table1
WHERE ID = :ID

yeah_xxc · Post by **yeah_xxc** » Thu 24 Aug 2006 11:39

It works!
Thanks very much!

Devart Forums

RefreshRecord problem

RefreshRecord problem

Re: RefreshRecord problem