General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Why not just use a view?
>Well Steven I would say to do a work around and not a filter
>
>
>
>select recno() as recno, *; && record number and every field
>
>then get _TALLY
>
>n_tot = _TALLY && returns number of records returned by query
>then upon exit of the form update the orignal table
>do while n_tot <> 0
>select tmp_tbl
>m = tmp_tbl.recno
>select org_tbl
>goto m
>replace org_tbl.a with tmp_tbl.a, org_tbl.b with tmp_tbl.b
>n_tot = n_tot - 1
>select tmp_tbl
>skip 1
>enddo
>
>this will replace everything, which is not what you want but it is on the right path, you could add a logical field called "change" and make it "T" after a record is changed, then only update those records
>
>hope this helps
>
>>I need to be able to update the records with the grid.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only