Hi!

I have a recordset with data from a database and I bind it to a MSHFlexGrid.

Problem is that I need to set the value of the 1st row of that grid. So I either have to fill the 1st row of the recordset and then bind it to the FlexGrid or have fill the 1st row of the FlexGrid and then bind the recordset to it. I'm having all kind of problems with this 2 solutions... :( Inserting the 1st row I want to the database and then retrieving the table to the recordset isn't a solution amongst other things because of data type. So what do I do now?

Thanks!

Rui

the solution would be is to insert the row you want into A TEMP table then insert the rows you want into that TEMP table and retrieve that table into your recordset. If your concerned about the data type, my question is why do you have to insert a row in the GRID that is not of the same data type (column) as with the other values in that column?

hi all...

bluefrench option is very good.. but i will also ask you.. why do you need that?? maybe there is a better solution if you xplain what are you train to accomplish...

HTH

Gonzalo

Hi All!

What I was trying to do was to have a FlexGrid with data (i.e. Part Numbers) that I could drag and drop to a textbox. The 1st item on the Grid would be "New Part" so that if I dropped it into the textbox and pressed a button, it would create a new part. (it's a bit more complicated than this. I simplified so that it would be easy to explain).

What I ended up doing was to create a button that when pressed creates a new Part Number. It's not a great solution from the usability point of view but it works. Parsing a temp recordset/flexgrid was too time consuming so it wasn't an option.

Thanks for the input guys!

Rui

you wouldn't have a temp recordset from what i suggested. it's not clear to me what you wanted to do, though. but if you could clear it more i would be glad to help.

If you want to have the first record be "New Part" what I might suggest is to create a field in your database named Priority set all values to zero. Set the "New Part" record Priority to one. Link the Flexgrid to a query and have the ORDER BY clause Priority Desc. If the query is dynamic always ensure the first parameter in the ORDER BY clause is Priority Desc and do not allow users to change, access, or sort by the Priority field. This will always keep the new part record at the top of the view.

Hope this helps.

Larry Asher

Nice idea xgbnow. Thanks!