Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple row per record in a grid
Message
De
27/06/2005 02:48:59
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Allemagne
 
 
À
20/06/2005 05:35:17
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MySQL
Divers
Thread ID:
01024759
Message ID:
01026619
Vues:
20
Hello Cetin !

Thank you for your hits, but i can't get it running in the way i want ??

My application works with sql_passthrough.
I define my grid at init of a form
...
thisform.grid1.column1.header = ...
thisform.grid1.column1.width = ...
thisform.grid1.column1.currentcontrol = mycombo && if i want a combobox instead of the default textbox

thisform.grid1.column2.header = ...
thisform.grid1.column2.width = ...
...


l_cursor = "mybuffer"

With the values of some searchfields i build a select string

thisform.grid1.recordsource = " "
l_select = "select a,b,c,d,e,f from ....... where ....."
sql_execute(connection,l_select,(l_cursor))
thisform.grid1.recordsource = (l_cursor)

Now i build a containerclass with two textboxes (mydoubletext)
I put the container in column1.
At init of my form i do :
...
thisform.grid1.recordsource = " "
Thisform.grid1.column1.currentcontrol = mydoubletext
thisform.grid1.recordsource = (l_cursor)
...
The 2 textboxes in column1 are empty, column2 shows b, column3 shows c ....

I want a + b of each record of mybuffer in the 2 textboxes of column1,c in column2 ....

I tried
Thisform.grid1.column1.currentcontrol = mydoubletext
thisform.grid1.column1.controls(1).value = mybuffer.a
thisform.grid1.column1.controls(2).value = mybuffer.b

but then the 2 textboxes of column1 show a + b of the first record in all rows and column2 shows the different b values,column3 shows the different c values ...

How to put a + b of each record of mybuffer in the 2 textboxes of column1,c in column2,d in column3 .... ??????

Any help welcomed
Best Regards
Albert
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform