Search results for query: *

Thanks for the responses, BlueJay was correct, it required vbNullstring. I am the SQL developer, I rebuilt/ expanded the database that works with a new c#/xml front end. All stored procedures using this legacy spreadsheet have now been re-created but with parameters to scope them to the data...

...code that has worked fine for years (without the additional needed parameter): With rstReports .ActiveConnection = con .Source = "SELECT * " & _ "FROM nr0810_tblNationalReportTableDefs " & _ "ORDER BY CAST(TableID AS int) DESC;" .CursorType =...

...//Patient overall score as a percentage patient.OverallScore = ((patient.OverallScore / maxPossResult) * 100.00); //insert into results table SearchResults.Rows.Add(patient.EventID, patient.PatientID, patient.OverallScore); }...

Thanks RiverGuy, that was essentially my issue with it! As a self taught SQL developer I was just worried that I was being "dumb" and had missed some feature that lets you reference to a component of a primary key rather than the entire key. It seems that after much procrastination on my part...

Thanks for responding Borislav, that was my initial suggestion and was discussed as a solution however It was decided that the insert method was better for our needs (I agree with this after being talked round). The issue boils down to, "Is it possible to maintain a referenced relationship...

Hi All, I wondered if you could clear something up for me. I have a database that we are currently attempting to roll out as a web app. Large scale changes are happening to the schema and we are currently working on provision for recording history within the database concentrating on the...

...I have just got this working declare @db_name varchar(max) select @db_name = top1 dbName from dbases declare @q varchar(max) set @q = 'select * from ' + @db_name + '.[dbo].infoSchema' exec(@q) infoschema definition create view infoSchema as select * from Information_schema.columns where...

Hi bborissov, I know the names of the databases, that isn't the problem. Are you suggesting that I use a stored procedure to retrieve the data from Information_schema.columns by building a string? i.e. exec 'select * from ' + @db_name + '.Information_schema.columns'

Hi all, I need to create a view of Information_schema.columns for a particular set of databases, all located on the same server. The project is to improve the data documentation manuals that we currently hold as word documents, I Intend to create a database that contains a view listing all of...

Sorry I possibly should have said I am purely a copy and paste VBA programmer and I generally guess how to do these kinda things and google it. If that would be the way to do it I would appreciate direction to a tutorial, especially the referencing the field element bits. I'm guessing from...

...to use the following query for each combo box to supply the appropriate values. select ID, description from lookuptable where tablename = "**TARGET TABLE NAME**" and fieldname = "**TARGET FIELD NAME**" Is there a way to detect **TARGET TABLE NAME** and **TARGET FIELD NAME** from the...

Hi all I would apreciate some generic help with the following problem as it's probably far too complex to document and solve on a forum but I need some more ideas on how to diagnose this problem. situation: PHP running on a Hiawatha server using an mssql 2000 database. all of my queries run...

Thanks Chris, Mental block - I am officialy dumb! worked first time. again thanks!

...elements to no avial. any help greatfully recieved - code follows. <style type="text/css"> div.tableContainer { width:800px; height: 295px; /* must be greater than tbody*/ overflow: auto; margin: 0 auto; } table { border: none; background-color: #f7f7f7; } table>tbody { /*...

Thanks Denis I will look into that. Normm

Ok my general question is :- If I have a cursor with 2 stored procedures in it each with an identically named cursor inside of them and an error occurs in the first procedure - is this cursor left open? Secondly is the cursor left open after the end of the first stored procedure leading to an...

Dennis, I thought about this but decided that it would make no difference as each process is not mutually exclusive. Records created by proc1 are then used in proc2 so if the first part of the program falls over then the rest of the run is invalid.

Hi Mark, I'm not sure that it would be possible to do a set based insert on this table for one reason. The none auto incrementing primary key would make it difficult to insert multiple records directly into the table. The solution(s) to this that we have found so far are to do it in the way I...

...first of all the main procedure the second error - the one regarding the cli_cursor that already exists comes from the redobedanal function /*re do Group Anal top level procedure inside this proceedure reDoFeeAnal reDoBedAnal reDoHomeAnal and then builds the group anal*/ create...

Hi Mark - the cursors are neccecary - by design there are only ever 2 cursors open accross the whole process at any one time. 13 million is not the number of rows processed it is the number of update statements executed by the system as a whole. all cursors only hold a limited amount of data...