Search results for query: *

That doesn't really change anything if you think about it. I'm talking about splitting a field up; you're suggesting concatenating several fields. Either way you have the issue of, if you choose to use intermediate calculations, how do you refer to them in your Update statement? The source data...

Ah! It's coming back to me. What you do is use a view (ie a Query). Save the select query as a Query and then create another query which joins your base table to your query. You can then refer to the calculated fields as if they were real fields and use the values to update your base table

I did think of that approach. However I am a believer that for functional languages (like SQL) you should take advantage of the visibility of what is going on, and burying values in complex functions is just making de-bugging more difficult. The other reason is that it's so basic, it must be...

This is a basic question. I want to pull out some substrings and load two new fields. I get my values from: SELECT Interface_List.ID, Interface_List.Identifier, InStr(1,[Identifier],'_') AS Len1, Mid([Identifier],1,([Len1]-1)) AS T1, Len([Identifier]) AS LenId...

You could consider Access as the most accomplished of serverless database products. If you just want a database then SQLite is very widely used. Some versions of MS SQL Server will fit your bill (I think the limits are in terms of threads not users, so you could probably support your workload...

My original question was categorically about compiling a program in Excel format (ie a spreadsheet) to make it run on another platform eg F#. You perhaps haven't read the full thread. I floated F# as it is also a functional language and therefore might find it more natural to deal with Excel's...

Paul - I didn't mean Excel the program. I meant a given spreadsheet. To take the most simplistic case, if my spreadsheet took 10 numbers and contained the function A11 = SUM(A1:A10) then I would want a program that took 10 numbers as parameters, and returned the sum. Actually you make a fair...

Well, I don't want to 'use' multiple languages. That's really the whole point of the exercise. If I cross compile Excel, that's behind-the-scenes just like programming in Coffeescript uses JavaScript behind-the-scenes. In the scenario I mentioned, only the core system is down for...

Thanks guys. The question was did you know where I should look for a cross compiler. I think what you are saying is you've never heard of one, which is probably why I couldn't find one, googling. The original idea for this train of thought actually came from the international health insurance...

Zack I was reading this. MS are saying you shouldn't run Excel on a server, and it is likely to infringe your licence. That might be academic, unless you want to use the Cloud - maybe it's more dificult to get hosting for something contravenes licence conditions. Perhaps if I put it another...

OK Let's take an international health insurance example: Sheet1 has fields where you can enter date of birth, country of origin, country of cover, cover level, additional features (travel etc). Sheets 2 to 10 do various look ups on pricing, elligibility etc tables, error checking and message...

Yes - not very clear, Zack. I'm treating Excel as a model. You put some figures in, press enter and it calculates some other figures. Once you're satisfied your model is what you want, you could then change it from Excel into something Microsoft like you to run in a server environment. Their...

Have you seen a cross-compiler that turns Excel into something that can run on a server? Googling, all I can see is things that turn Excel into a package. The spreadsheet seems to still be/need Excel. I can see somethings would be tricky to translate (eg Pivot tables) but I guess the main...

If you record and track everything, you are a micro-manager. You need to list all the things you need to understand how long the the project will take, how many people are needed, and what are the dependencies. No project follows that plan, so you then constantly identify what needs attention...

Sorry - I don't get it. You say you are preparing these questions but asking other people to answer them. Do you think you know the answers? Why don't you say what the answers are and then we can comment on whether any are debatable. 39 and 40 are fatuous. 38 - what is 'POS' 37 is a psychology...

Hi Lora What help do you need? Are you expecting someone to answer 40 questions for you or is there something specific you are asking?

If you have a composite key, you have a composite key. There's nothing you can do to change that. Whether you tell Access, or ask it to do anything about it, is a separate issue. You will still be able to use it as a key. I'd be inclined to add an autonumber field as a surrogate because it's...

I'm just reading through the WebMatrix notes. What I've not seen is anything that refers to creating your web page except by writing HTML. Does it not have that capability? If not, what are you expected to use?

Email is great for everyday communication. Windows Server is great for file postings. Excel is great for bug tracking although there is merit in the likes of Test Director/HP Quality Centre. Basecamp etc are solutions looking for a problem.

Typically you put in a task that covers the time you are on the project. It's optional though, and rather depends on whether the plan is serving other purposes eg tracking costs and resource utilisation.