Export data in a MSHFLEXGRID

[dvannoy]

is it possible to export the data in a MSHFLEXGRID? if so how is it done?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[scarfhead]

I've seen this question multiple times with no answer. I've never used the hierarchical flexgrid. What is so special about it that makes this question so difficult?

Does it allow you to traverse across rows and keep heirarchy information intact?
How do you populate the grid to begin with?
Can't you just use the same algorithm, but read instead of write and use each row to create a recordset?
Are you trying to write to a database or to a text file or to XML?

scarfhead

 

[dvannoy]

I am pulling data from a AS400. the only grid I could get to work was the hierarchical flexgrid. it is very easy to populate. what i am trying to do is, pull data from a AS400 with certain conditions(works fine) then once the grid is populated(works fine) export or append that data to a table on my SQL server. I think I might of figured it out. but still have some testing to do. I was looking to see if anyone had this issue in the past and maybe get some help from them. DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[dvannoy]

i am using this code below to try and write the results to a db.

For i = 1 To MSHFlexGrid1.Row

rsdatabase.AddNew
tbltest!field= MSHFlexGrid1.TextMatrix(i, 1)
tbltest!field= MSHFlexGrid1.TextMatrix(i, 2)
tbltest!field= MSHFlexGrid1.TextMatrix(i, 3)

rsdatabase.Update

Next
rsdatabase.Close

I get no error..but it wont write the data. I know it connects to the db fine but i cannot get it to write the results.

any help would be great
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com