Hello FoxPro Users!

I've created a new form with two grids connected to ORACLE database (8.1.6) through cursor adapter.

Two grids work as master/details - when I select the row in the master grid, I update the selectcmd property of the details grid and fill the cursor.

Everything works fine - I see the records of the master row.

But, the strange thing is that in details table I have a field of type VARCHAR2(10) and it contains values with leading zeroes.

When I scroll through records in details grid I get the data corrupted like the following:

00000001
00000001
00000001
00000001
00000001
0000001
0000001
0000001
0000001
0000001
000001
000001
000001
000001

As you see each set of records zero disappears, although in database it does exist and this is a key field between master and details tables.

When I browse the contents of the details cursor I see the same thing so this is not related to data presentation.

I'll appreciate any ideas for solving the problem.

Thanks in advance.