Search results for query: *

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 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...

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...

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...

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]...

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

Hi all, I've searched about a bit on line but haven't founf anything on my query yet. Since we have moved to XP, when I open 'my computer' (or attempt to save documents and such) the drop down menu listing the available drives displays the drives in this format: Drivename01(C:) Now some...

Hi all, We are about to move from using attachmate extra sessions (controlled with a lot of VBA code, primarilly from MSaccess) to using hummingbird software. How easy is hummingbird to control and interface with in the same way that attachmate extra allows? Also if anyone has any links...

Hi Guys I've got a query here, its returning the following error: ( I find that pasting the below query into notepad or text editor of your choice lets you see the formatting properly) Select * FROM dbo.tblMonthEndEstimate LEFT OUTER JOIN (SELECT AssetClass, SecurityDescription FROM...

Hi Guys Below is an update query. It keeps returning the following error: Server: Msg 8152, Level 16, State 9, Line 1 String or binary data would be truncated. The statement has been terminated. I would assume this refers to my destination fields being to narrow for the data I'm inserting...

Hi All I was just wondering if its possible to send a delivery report (the thing thats sent by notes when you view an email which someone has marked to be notified about) either with some code or by forcing a normal email to look like/be a delivery report?

Hi guys, I'm planning an application that will allow a user to select their choice of fields from a table into a spreadsheet/report. I'm still very much an access user/programmer but have been using SQL more recently (so my thinking is probably not completly SQL orientated and I'm doing things...

Hi All, Heres a quick snatch of sql: UPDATE [tblGSP55S9X - Security Data] INNER JOIN ASSETS_TO_ESTIMATE] ON [tblGSP55S9X - Security Data].CUSIP=[Assets_To_Estimate].CUSIP SET [Assets_To_Estimate].ISIN= [tblGSP55S9X - Security Data].ISIN (sorry for the shabby looking formatting here) When I...

Hi all, I seem to remember reading somewhere, many ages ago that there was a function within VBA that would allow a larger chunk of processor intensive code to 'sleep' just for a few milliseconds over and over every so many times through a loop (for example). I'd love for this to be as simple...

Hi, I want to clear a directory of text files before I start populating it with new ones. Whats the quickest most elegant way of doing this from a DTS package/Activex script task?

a return value from an sp? The sp checks that some values from tables equal each other. if the numbers equal then the results of an analysis package are correct. I then truncate a table. However if the numbers do not match to within a tolerance I want the truncate skipped (which I've done) but...

hi all, I have a table/view (at this stage I'm running it as a view but figure I can make it a temp table in an sp) which is subtracting one field from another. This will result in a value that, will hopefully be zero, give or take a tolerance of $5 in either direction. Whats the best way of...

Hi all, I have a table containing a number of fields. Two of those fields contain strings I need to concatenate to display the whole name of an item. Occasionally one of the fields is NULL, which is a failing of the data scource, so theres not much I can do from that end. This seems to be...

Hi all, Below is the code I am using in my stored procedure. I want to pass in the date. I will be taking this date from a field in a table. I am extracting this date with the following query: SELECT TOP 100 PERCENT Proc_Date FROM dbo.tblGLNLoanall GROUP BY Proc_Date ORDER BY...