Search results for query: *

Thanks for the feedback Genomon. I had tried all that, which is why I was at a loss :) It turned out that the source table, a Paradox table needed to be 'repaired' despite being perfectly 'open-able' from a Paradox interface. Still live and learn. Thanks Dave

Hi All, I have an access database that is linking via a DSN to some paradox(version 10) tables. All but one of the tables is fine, when I click onto the offending table I get told that 'ODBC Failed' and the fields in the table are populated with multiple ####'s. This is only affecting one...

I'll give that a try Jon. Thanks for swapping ideas :) I'll post back with the results.

the views are exclusivly for this one sp. They offer summarised views on a couple of the tables that are created. These figures are then worked back into those tables. I've taken the liberty of simplifing the table and view names. (the layout of the code looks a little better when pasted into...

Thanks for the input John. That had occoured to me, as did just making the tables perm and simply truncate and insert into them within the procedure. Really I was curious as to ways to deal with things within the one procedure. Would using aliases work? Creating the views from within the sp...

I have a series of statements/code that runs with no problems in QA, using the word 'GO' inbetween each statement. The same series of statements/code requires me to remove all but the last 'GO' from the code. This is causing me problems. Please, anyone, correct me if I'm wrong, but a QA window...

Thanks Von. I'll give it a whirl.

Hi Chaps/Chapettes Heres what I'm trying to do: ID_number 507119 507119 507119 506225 506225 703665 703665 703665 We have a system (third party vendor, so we can't make changes to it) that ids a bulk transaction by a number, for instance 507119. There may be many allocations/sub transactions...

Not sure if this counts but... My pet peeve is people crediting themselves as the originator of a quote (particularly in signatures) that they did not originate. Because lets face it, its rather obvious you did not in fact originate that quote, you have, if at all, simply changed a few words of...

That was just what I was looking for PH. A star for you both for sparing me your time and knowledge. Many Thanks

That half works, stops someone hitting the return key. Good stuff, I didn't know about that :) However, using the cursor keys I can still advance to the next and previous records.

Hi chaps (and chapettes :) ) Heres the deal, (all this exists within a legacy db that I really want to decomission but as yet have to maintain) I have a form, within that form is a sub form. That subform allows people to change data in a records fields. I plan on taking a snapshot of that...

Latifa? :)

This may very well be appropriate :) You could try reading a book by Iain M. Banks called 'Feersum Endjinn' , or Fearsome Engine in non pidgin/phonetical speech. Half the book is conducted in an odd cyber scape with someone of seemingly (while in the cyber scape) reduced mental stature. Iain...

Von, my code was just a simplified representation of my thinking, not the actual code :) Thanks all for the input everyone, I think my syntax was just a little squiffy, blame it on my time with VBA ;)

I'd like to do something like Select CASE (field1) WHEN <> 9 THEN FIELD1 ELSE ' ' END AS IDTYPE1 TSQL does not like this syntax :) Am I missing something obvious that my tired eyes are not seeing?

Hi All, Heres my query (excuse the formatting as it gets squashed inot the form window): SELECT dbo.[tblLending Accounts].[ACCT-NUM], dbo.[tblLending Accounts].[SHORT-DESC], dbo.[tblLending Accounts].[CLIENT-NAME], dbo.[tblLending Accounts].[Lending Account Name]...

How can I work this into a view? It says the query designer does not support the case function.

Just wondered if there was a way to do something like the following (Which is possible in MS Access): FieldnameAlias: if([Fieldname]<0,0) Which would produce a 0 for any value under 0. Is the way to accomplish this to priduce a copy of the data and run an update statement against it? Cheers

So its just a case of use the power toys? :) Not sure if the desktop software guys will be happy with me going around messing with things, but live fast and go get hired somewhere eh? :) Cheers Rick