Help! UpdateRecord SQL

Help! UpdateRecord SQL

Post by Yang Seung Ko » Thu, 23 Jan 1997 04:00:00



 I Used Updated SQL And
Added Parameter to Modify SQL Like this
Update EMPAUDIT
SET salary = :salary, changed = :date_changed
where empno = :old_empno

date_changed is not a field in data set

In Runtime Delphi Complain like this "Field 'date_changed' Not Found"
Why ??
Please Give your advice

 
 
 

1. Help with Updaterecord method warning

--

I am using a query to combine several tables in a database to
populate a data control. Several VB controls are bound to this data
control. These tables are linked through referential integrity.
I am using the following to allow the user to make changes which
works fine except for one case.

Data.updaterecord :Data.refresh

When I update the Primary Key field, I get the following warning. This
is linked to the highest table.

Object doesn's support this property or method

After clicking OK the operation still works. I know it has do with
the integrity checking. I have tried several things with out any luck.
Can someone tell me how to avoid this problem?

If I allow the fields to updated automatically after a repostion this
does not occur.

Thanks in advance,
Jeff

-----------------------------------------------------------------------
Jeffrey A. Joines, Ph.D.              Research Associate

P.O. Box 7906                         Fax:               (919) 515-1543        
North Carolina State University       Phone: (Office) -  (919) 515-5188
Raleigh , N.C.  27695-7906                   (Home)   -  (919) 851-9396
----------- http://www.fmmcenter.ncsu.edu/fac_staff/joines.html --------

2. Which DBs are in online?

3. Runtime Error 91 on Mydata.UpdateRecord (long post)

4. ADO to MS SQL server trace

5. UpdateRecord

6. layout?

7. "UpdateRecord" property

8. (PDXJOBS) Oracle Financials Expert Perm

9. UpdateRecord error

10. UpdateRecord = MovePrevious?

11. Data control UpdateRecord property

12. "UpdateRecord" Property

13. GPF from UpdateRecord (in TDBGRID-LostFocus)