Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Suggestions for new web app
Message
De
28/03/2013 19:40:24
 
 
À
28/03/2013 18:22:40
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
C# 5.0
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01569267
Message ID:
01569501
Vues:
36
>>>I tried the DBF() function and the function wouldn't work either.
>
>=> Memory-resident cursor so no file. So how about
>
>
Select *,12.45 as rte_base from a_slips into cursor rptfile readwrite where .f.
>
>I'm betting that you then load data from a_slips into this cursor- so maybe you can make the SELECT a lot smarter to get the data straight in there.

John
That's a good solution. Hmm why didn't I think of that?
I redimension'ed the array with the added column and that did the trick so this one is in the books
I came across another usage of ALTER TABLE in the same app, but it drops 2 columns in this case.
There are too many columns for me to go picking the ones I want in the SELECT, so I'll have to figure a clever workaround.
I'm thinking about using ADEL() to remove the unwanted columns from the array before creating the cursor.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform