Rajrajcoomar replied to a post below in regard to an SQL statement saying that he would first make an updatable SQL table. How do you do this? I've been trying to figure it out for some time now. I have several places in my app where I want to pull selected records out of an existing table and put them in a grid for the user to select from. I need one or two fields from the original table and a TAGGED field that can be toggled by the user's actions. I would love to use an SQL query to fill the grid, but that always makes a read-only cursor, which is useless to me, so I end up with a page of code from CREATE CURSOR to the SCAN FOR..ENDSCAN block that fills it.
So, how do you make an updatable SQL table?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.