Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use again from private datasession to default
Message
De
12/01/2002 14:08:07
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
11/01/2002 01:16:16
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00601842
Message ID:
00603931
Vues:
25
>Dragan
>You are absolutly right in your explanation- the wall between sessions
>I knew this , but had temptation to jump through it
>It was to sad to repeat queries
>By the way, if I used remote views, opening view each time
>in the form makes server query again.
>Now I took the following method
>In customer object I add dynamically ( addproperty) 2 vector properties
>Go to first form ( set it session)and put afields() in first
>property and make sql select ( from the cursor I took form server)into array in the second property
>Go to the second form ( set its session)
>Create cursor from first property
>Makes insert in it from the second property, drop 2 properties, besause next
>cursor could have absolutly diffrent data types.
>So, I avoided cicle. It does not makes the work more fast in one user variants, but
>decrease numbers of the server requests and many clients will work faster

Neat trick. If you're using VFP7, you can also try to use CursorToXml to post the cursor content to your form, and XmlToCursor to retrieve it. Depending on the size of your cursors, you may exceed the maximal number of members in an array (65000) and XML can hold any size you like - but then with large recordsets it would probably be slower.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform