Search results for query: *

Hi all, I am dealing with a piece of legacy code in an Excel spreadsheet. The following code has worked successfully for years however we have recently moved to a new SQL server and our stored procedure now requires a parameter. The code retrieves stored procedure names from the database which...

Hi all, I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a TVF. I am not a fluent C#...

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

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

Hi all hopefully someone can help me with this, I think it should be possible but I'm not sure how to do it, my access experience is limited. If this is a question that has been answered somewhere else a link to a guide would be appreciated however I cannot currently find one. I have a very...

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

Hi all, I'm having a little bit of a problem making my table look as intended. I am attempting to make a table to display data with a fixed header. After adapting the example at http://web.tampabay.rr.com/bmerkey/examples/nonscroll-table-header.html for my purposes I have inserted some form...

Hi all, I have written a series of stored procedures intended to process a large amount of data and have errors that I now feel that I have fixed. However due to the insanely large amount of processing conducted the process takes a very long time to run fully (around 13 million update...

Hello all, I have a legacy database on MSSQL 2005 Express where I need to do a complicated delete. I need to know if the following is possible and if it is what is wrong with my code. Concept of Schema. Database holds information on members of staff based at many care homes within an...

Hi all I'm currently working with a:- Sun Java™ System Application Server Platform Edition 8.2 which for some unknown reason keeps hanging at random intervals. during normal operation the the program hosted on the application server appears to become unavailable for no apparent reason - the...

Hi all, Is there a really quick simple way to detect all of the variables within a database of a certain datatype. I'm currently working with a large MS SQL server 2005 Express database and need to check for date and time fields within the whole database. Any help Greatfully recieved. Normm

Hi All, I'm currently trying to refresh a browse box from a Tin Tools Calendar lookup button in C6.3 using ABC templates. The lookup button supplies inserts a date value into a local value that is then used as part of a conditional filter on the browse box. everything seems to work fine but I...

Hi all, I have been asked to add image retreval from a CCTV camera to our application. I have figured out the indexing of files and how to manipulate them once an image file has been recovered from the camera however I cannot seem to get clarion to recover the file from a location on our local...

Hi all, I am experiencing the above error after upgrading from clarion version 6.2 to version 6.3 and then trying to re compile an application written previously. The Application worked perfectly well before upgrade and has not been changed at all before re compilation. The error seems to be...

Hi all hopefully someone could assist me with this. I'm currently learning Clarion for a new job, Im using ABC templates wheras my colegues are experienced in Legacy templates. I need to produce a report that firstly lists an Item from a TPS table and then lists all related items in another...

Hi all This is my first post on this forum, hopefully you will be able to make some suggestions for me. Background. Ok the story is that an old peoples home ran by family friends Employed a young man. This young man, as he was the most computer literate employee, was given the task of...