Search results

I know its ages since we spoke about this but I came across a discussion about pairing in a stack overflow discussion directly relevant to the above. How do you constrain a database so there are only unique pairs in a database table? If Kirk is friends with Victoria if we store that as a...

Quite possibly my ignorance I have never done anything but development by myself and then really only in two platforms.

That to me seems to be an optimal way of supporting citizen developers, improving security while taking advantage of MS Access's flexibility.

I see IT departments disliking MS Access applications often but consider this an illogical argument. What they actually dislike is the fact that there is only a single developer and they don't know how the business logic works. So if that single developer goes no one knows how to fix or adjust...

I have answered questions but I m often unsatisfied with my own answers. I often make the effort purely because I think I learn as much from answering as asking. I do accept that if I am going to ask a question I should if possible create a worked example of the starting point and the target end...

Don't think its practical but wow a starship I think one day - probably not in our lifetimes but maybe in our descendents - it will be a thing... I certainly wouldn't really want to go on a startship unless there was somewhere nice to go... but it might be the step before there is somewhere to go.

It certainly wasn't obvious to me initially but the benefit of trying to solve other peoples coding problems is often felt more by the improved understanding of the person answering the question rather than the person receiving the answer. This is why I think teachers get so good.

Big congratulations - My wife asked me a couple of times - "But why did you choose to go to that particular consultancy?" I said - "They've got a couple of MVPs" She said - "What does that mean?" I said - "They know what they're talking about"

I would probably choose the same if I had the same task.

I should say that with my naming conventrion the number part is only a prefix a textual word description comes after my prefix... so for example t001users - anyway only personal preference. I do have to write queries against a massive oracle database at work and it can be really difficult to...

Its a great project and I even come across Northwind in SQL Server examples - Naming convention seems perfectly fine to me.. One thing which seems quite personal to me which might be of interest- I usually prefix my table descriptions with incremental reference t001 t002 etc.... going forward...

So I have started implementing this specifically for my case which is for a whisky distillery splitting whisky into bottles. As a first step I went through Arnel's and CJs code and just made sure I understood it. I just thought I would document it here so others can follow more easily as well as...

Hi guys I've actually updated some details on PHPRunner which is a personal favourite web application code generator that I use. Its basically MS Access for the web - a CRUD Web application Creation tool that connects to MySQL / Oracle / MS Access / Postgres and SQL Server. I've used it against...

I think we might be going round in circles here. You could argue that a 1-1 relationship is the most common relationship and is the core of what a tuple is defined as. We just rarely model it specifically because it is covered by putting all the attributes in the same table and therefore...

Big thanks guys right on the money.

I think the best position is to try and give something back if at all possible. Even for open source... At the end of the day if it adds value for you the value should be proporational to the value you get from it... Yes we are often forced into situations especially in markets that lack...

OK started thinking about this.. First issue I've thought of is that I need to deal with decimals rather than integers. I guess I can multiply out to remove the decimals I thought that there might be a remainder issue as well but I don't think there will be because I am not dividing by a...

Thank you that looks like the solution

Dear All Looking for TSQL appropriate for SQL Azure. I have a need to create sub records on a table by calculating a split of a volume. I probably haven't explained that very well but if you see the example below it might be clearer. Essentially I have casks and I want to split them into...

Thank you guys much appreciated