Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suggestions for new web app
Message
From
28/03/2013 19:40:24
 
 
To
28/03/2013 18:22:40
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
C# 5.0
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01569267
Message ID:
01569501
Views:
37
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform